How to group records in Airtable
Group records in an Airtable grid view by a field such as Status, so related rows sit together in sections you can collapse and scan quickly.
Quick answer
To group records in Airtable, open your grid view, click Group in the toolbar, and pick a field such as Status. Airtable sorts the records into collapsible sections, one for each value, so you can scan the Todo, In progress, and Done work at a glance and collapse any group.
Steps at a glance
- Open your grid view
- Click Group in the toolbar
- Pick a field to group by
- Check the grouped sections
- Collapse a group you do not need
Interactive demo
Summary
Grouping sorts the records in a view into sections that share a field value, such as Status. It keeps long tables readable and shows how work is spread across stages without changing the underlying data.
Step-by-step guide
Step 1
Open the Group menu
Open your table in Grid view. In the toolbar above the records, click **Group** to open the grouping menu.
Step 2
Choose a field to group by
In the **Group by** menu, pick the field you want to organise your records by. This guide uses **Status**, which has the values Todo, In progress, and Done.
Step 3
See your records grouped
The toolbar button now reads **Grouped by 1 field**. Your records appear in sections for **Todo**, **In progress**, and **Done**, with each record under its own Status value.
Step 4
Collapse a group
Click the arrow next to a group name to collapse that section and hide its records. Click it again to expand the group and bring the records back.
Why this matters
You have a table of tasks in mixed order and need to see what is still Todo, what is In progress, and what is Done. Grouping by Status gives you that view in seconds, so you can review progress without building a new view.
Frequently asked questions
Does grouping change my data?
No. Grouping only changes how the records are arranged in the view. The values stay the same.
Can I tell a view is grouped?
Yes. The toolbar button changes to show **Grouped by 1 field** once a grouping is applied.
Related guides
Continue with more step-by-step guides for getting work done.
How to filter records in AirtableFilter records in an Airtable grid view: open Filter, add a condition on a field such as Name, enter a value, and see only the matching records.
How to create a grid view in AirtableLearn how to create a new grid view in Airtable: open the list of views, choose Grid, give the view a name and save it as another layout of your table.
How to add a new field in AirtableAdd a new field to an Airtable table from grid view: open the add field menu, pick a field type, name it, and create the new column in seconds.
Create interactive demos like this one — free, no coding required.
Start for free →