How to sort records in Airtable

Sort records in an Airtable grid view by any field. Open the Sort menu, pick a field, and switch between A → Z and Z → A in a few clicks.

Quick answer

Click Sort in the Airtable toolbar, choose the field you want to order by, then pick a direction. Switching the direction between A → Z and Z → A reorders your records immediately, and the toolbar button then reads Sorted by 1 field so you can see the view is sorted.

Steps at a glance

  1. Click Sort in the grid view toolbar
  2. Choose the Name field to sort by
  3. Open the A → Z direction menu
  4. Select descending (Z → A)
  5. Confirm the toolbar reads Sorted by 1 field

Interactive demo

Loading demo…

Summary

Sorting puts the records in an Airtable grid view in the order you choose, based on any field. It keeps long lists readable and lets you find the record you need without changing the underlying data.

Step-by-step guide

  1. Step 1

    Open the Sort menu

    Open your base and go to the grid view. In the toolbar above the records, click **Sort** to open the sort menu. The menu is where you choose which field controls the order of your records.

  2. Step 2

    Pick the field to sort by

    In the **Sort by** menu, a list of your fields appears under **Find a field**. Click **Name** to sort the records by that field. The records reorder as soon as you pick it, and the toolbar button changes to **Sorted by 1 field**.

  3. Step 3

    Open the sort direction menu

    Next to the field, the direction button shows **A → Z**, which sorts ascending. Click it to open the direction options. You can also use **Add another sort** to layer a second field.

  4. Step 4

    Select descending order

    In the direction menu, choose **descending**, shown as **Z → A**. The records flip so the last item alphabetically comes first. Switch back to **ascending** at any time to restore the original order.

  5. Step 5

    Check the sorted records

    Look at the toolbar, where the button reads **Sorted by 1 field**. The **Automatically sort records** setting stays on, so new or edited records settle into the right position. Use **Remove sort** to clear the sort.

Why this matters

You have a table of tasks or assets in no particular order and need to scan it alphabetically. Sorting by one field puts everything in order in seconds, so you can find a record or compare neighbours without rearranging anything by hand.

Frequently asked questions

  • Can I sort by more than one field?

    Yes. The Sort menu has an Add another sort option, which lets you add a second field after the first.

  • Does sorting change my data?

    No. Sorting only changes the order records appear in the view, and the Automatically sort records setting keeps new records in position.

Create interactive demos like this one — free, no coding required.

Start for free →