Guides · Free tools

Export Airtable to JSON (free, in your browser)

Export an Airtable table or view to a JSON file: every record with its ID, created time and fields, or just the fields as a flat array. Pretty-print it, copy it, download it. No signup.

What you get

• One .json file named after the base, table and view, holding every record of the table, or of the view you pick (the view's filters and sort order apply).
• The default format is an array of { "id", "createdTime", "fields" } objects, the same shape the Airtable API returns. Tick Flat to get an array of just the field objects.
• Values keep their real types: numbers stay numbers, multi-selects are arrays. Empty fields are left out, as in the API. Text is UTF-8.

Why JSON instead of CSV?

CSV flattens everything into text cells. JSON keeps the structure: a multi-select is a list, an attachment is an object, and a record keeps its ID. Pick JSON when a script, a database import or another app reads the file, and CSV when a person opens it in a spreadsheet. For a whole base as spreadsheets, see the Airtable to CSV tool or the Excel export.

Things to know about the data

• Linked records come as record IDs (rec...), not names. Export the linked table too and join on the ID, or add a lookup field that returns the name.
• Attachments are objects with a URL that expires after about 2 hours. Download the files soon, or use the attachments downloader.
• API limits: Airtable allows about 5 requests per second per base and returns 100 records per request, so 10,000 records take roughly 25 seconds. If Airtable answers with a rate limit error (429), the page waits 30 seconds and retries.

Also free: export every table to CSV in one ZIP · export a whole base to one Excel workbook · export the base schema as a data dictionary · count records per table vs your plan limit · print a view or save it as PDF · download all attachments as a ZIP.

FAQ