Split a CSV that exceeds Airtable's 100 MB limit

Use a safety margin below 100 MB

The documented limit is a boundary, not a target. Create files comfortably below 100 MB so a browser download or a later field change does not push a batch over the limit.

• A CSV upload stops because the file is larger than 100 MB
• The first batch imports but later batches lose the header
• A retry duplicates records because the accepted batch was not tracked

• Split a large CSV into traceable batches →Keep the header and reconcile every output row.
• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.

Choose size splitting when row widths vary

Wide text fields and embedded line breaks make row counts an unreliable size estimate. Use size splitting, then inspect actual file sizes and preserve the input order.

• Set a target below the published 100 MB limit
• Treat quoted commas and line breaks as part of the row
• Confirm the destination table and primary field before import

• Select the columns required by the template →Remove export-only fields while keeping all data rows.
• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.

Build Airtable batches in LocaCSV

Splitting does not map Airtable fields or merge linked records. Use Airtable's import preview to verify field mapping and primary values.

1. 1Diagnose the CSV and record its byte size, header, and row count
2. 2Choose size splitting with a safety margin below 100 MB
3. 3Download the numbered files and verify each header and size
4. 4Import one batch at a time and mark accepted batches

Reconcile all Airtable batches

• Every output is below the chosen safety threshold
• The header and field order are consistent across files
• The total row count equals the source after intentional exclusions
• No accepted batch is sent again during a retry

• Split a large CSV into traceable batches →Keep the header and reconcile every output row.
• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.
• Select the columns required by the template →Remove export-only fields while keeping all data rows.

If Airtable reports a field or record error

Check field types, select options, linked-record values, and the primary field. These are destination constraints and should not be guessed from the CSV alone.

• Select the columns required by the template →Remove export-only fields while keeping all data rows.
• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.
• Keep only rows that belong in the import →Exclude test, inactive, or incomplete records with a visible count.

Create Airtable-sized CSV files