Airtable CSV Import and Export: Bases, Views, and Linked Records

Airtable Is Relational; CSV Is Flat

Airtable bases mix attachments, single-selects, collaborator fields, and linked records across tables. CSV can move a lot of that data — but not perfectly. Ops and marketing teams in the US, UK, Australia, Canada, and Europe use CSV to seed bases, sync with agencies, and archive views for Excel stakeholders.

Plan which fields survive a round-trip before you promise a “full backup via CSV.”

Export vs Import: Pick the Job

Exports are easy; imports need field-type strategy.

Step-by-Step: Export a View to CSV

What most collaborators actually need.

• Open the view that already filters/sorts the rows you want.
• Hide fields you do not want in the file (exports follow the view).
• Download / Export → CSV.
• Open in Online CSV Editor to verify headers and row counts.
• Convert to Excel if stakeholders refuse CSV.
• Document the view name and timestamp in the filename.

Name,Status,Owner,Related Projects,Due Date
Website redesign,In progress,Alex,"Brand refresh, Q3 launch",2026-05-30

Step-by-Step: Import CSV into Airtable

Create or merge without wrecking field types.

• Prepare a rectangular CSV: one header row, no title banner.
• Use ISO dates (YYYY-MM-DD) when possible.
• Put multi-select values in a consistent separator format Airtable’s importer accepts.
• Import into a new table first if you are unsure — then copy fields.
• Map each CSV column to the correct field type (number vs text vs date).
• Review a sample of linked/select values before importing thousands of rows.

Linked Records and Attachments

The two features CSV handles poorly.

• Linked record cells export as names (or lists of names), not durable record IDs — rename a record and joins get ambiguous.
• Re-importing links usually means importing parent tables first, then child tables with exact primary-field matches.
• Attachments do not travel inside CSV bytes; you get URLs at best, and those URLs may be temporary or permissioned.
• For true backups, use Airtable’s backup/export features or API — not CSV alone.

Dates, Locales, and Excel Round-Trips

US/UK teams break each other’s due dates constantly.

• Prefer ISO dates in interchange CSVs.
• If Excel opens the export and rewrites dates, clean before re-import.
• European semicolon CSV: convert to comma before Airtable if the importer expects commas.
• Phone, ZIP, and SKU-like fields: force text so leading zeros survive.

Field Type Cheat Sheet

Map intentionally.

Common Mistakes

Base-breaking habits.

• Exporting a filtered view and thinking it was the whole table.
• Re-importing without a stable primary key → duplicate records.
• Putting commas inside multi-select values without quoting rules.
• Using CSV as the only disaster-recovery plan.
• Changing select option names in the base after partners still send old CSV labels.

Best Practices

Make CSV a deliberate interface.

• Maintain an “Export” view with stable column order for agencies.
• Version CSVs with base name + date.
• Normalize dates and selects before import.
• Import links in passes: lookup tables first.
• Clean files in-browser when sharing client bases with freelancers.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Preview Airtable exports in the Online CSV Editor, fix delimiters and dates, and convert to Excel for stakeholders who never open Airtable. Works on Windows, macOS, and Linux browsers.

Conclusion

Airtable CSV is perfect for flat views and first-load tables. Treat linked records and attachments as second-class citizens in CSV, prefer ISO dates, and design stable export views for US, UK, AU, and EU collaborators.