How to filter records in Airtable
Filter 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.
Quick answer
To filter records in Airtable, open your table's grid view, select **Filter** in the view toolbar, choose **Add condition**, then pick a field, an operator such as **contains**, and a value. The grid immediately hides every record that does not match, and the toolbar button changes to **Filtered by Name**.
Steps at a glance
- Open your table in grid view.
- Select Filter in the view toolbar.
- Choose Add condition.
- Enter the value to match.
- Check the filtered records in the grid.
Interactive demo
Summary
Filtering narrows a grid view to the records that match a condition you set. It keeps large tables readable, because you see only the records you care about without deleting or moving anything.
Step-by-step guide
Step 1
Open the Filter menu
Open the table you want to work in. In the view toolbar above the grid, select **Filter**. A panel opens that says no filter conditions are applied yet.
Step 2
Add a condition
In the **Filter** panel, select **Add condition**. A new row appears starting with "Where", with a field, an operator, and an empty value.
Step 3
Enter the value to match
The first condition uses the **Name** field with the **contains** operator. Click the value box and type the text you want to match, for example "launch". The grid updates as you type.
Step 4
Check the filtered records
Click outside the panel to close it. The toolbar button now reads **Filtered by Name**, and the grid shows only the matching record, with the count at the bottom reading 1 record.
Why this matters
You have a table full of tasks and need to find the ones about a single launch. Filtering the view on a keyword shows just those records in seconds, so you can review or update them without scrolling through everything else.
Frequently asked questions
Does filtering delete the records that are hidden?
No. The panel only changes which records the view shows. Remove the condition and all records appear again.
Can I add more than one condition?
The panel also offers **Add condition** again and **Add condition group** once a condition exists, so you can combine rules.
Related guides
Continue with more step-by-step guides for getting work done.
How to add records in AirtableAdd records to an Airtable table in Grid view: click the plus under the last row, type a name into the new row, and check the record count.
How to create a kanban board in AirtableLearn how to create a kanban board in Airtable: add a Kanban view, name it, and stack your records by the Status field to track work visually.
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 →