How to convert csv to json for airtable api imports
- Step 1Match CSV headers to Airtable field names — Field names must match exactly. Use the Header Rename tool first if they differ.
- Step 2Convert the CSV to JSON — Drop it onto this converter and pick array-of-objects with inference on.
- Step 3Wrap each batch in records[] — The Airtable API accepts up to 10 records per POST. Slice the array into chunks and wrap each in { "records": [{ "fields": {...} }, ...] }.
- Step 4POST to the table endpoint — Send each batch to https://api.airtable.com/v0/{baseId}/{tableName} with your API key in the Authorization header.
Frequently asked questions
Does Airtable accept large arrays in a single POST?+
No. The REST API caps each create at 10 records. Slice the JSON array client-side and POST in batches with a small delay between calls.
How do I attach an existing record ID?+
Creates do not accept IDs — Airtable assigns them. To update, use a PATCH against /v0/{baseId}/{tableName}/{recordId} per record.
Will linked-record fields work?+
Linked fields require an array of record IDs, not names. Pre-resolve the names to IDs in your script before sending.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.