Export Airtable to Google Sheets in 60 seconds

Once your export exists, pasting the formula in Sheets takes about a minute. On the first run, allow a few extra minutes for Airtable sign-in and field selection—the “60 seconds” in the title is that fast path after setup.

1. Connect Airtable

Open web.exportairtable.com. Under Authorizations, click Connect via OAuth (you can use a personal access token instead if you prefer).

Sign in on Airtable, choose which bases to allow, then Grant access.

Tokens refresh in the background. If Airtable asks you to reconnect later, your export URLs stay the same.

2. Create an export

In Create Export, choose your authorization, base, table, and optional view. Reorder fields if you need a specific column order, then Create export.

3. Copy the formula

On the export card, copy the line that starts with =IMPORTDATA(…). The number at the end of the URL is only there so Sheets doesn’t cache an old file; change it if you need to force a refresh.

=IMPORTDATA("https://exat.app/e/9/d10260111b51db85443646b97584ba56c7c00c0c53f6251d.csv?1777185419")

4. Paste in Google Sheets

In a new sheet, select cell A1, paste the formula, press Enter. The first time, click Allow access on the yellow bar if Sheets asks.

After that, your rows load. Example:

Optional: set Auto refresh on the export if you want scheduled updates. More detail: how it works, pricing, usage. Questions? Get in touch.