How to Import a CSV to Airtable (2026 Guide)

AirtableProductivityHow-toCSVData-Import

There are four ways to get CSV data into Airtable in 2026: import as a new table, use the CSV Import extension into an existing table, paste rows directly into a grid, or sync from a live CSV URL. Each handles a different situation, first-time loads, ongoing updates, small one-off imports, and live data feeds. Here’s how to choose and how each one works.

1. Import a CSV as a New Table

This is the fastest method when you’re loading data that doesn’t have a destination yet.

Steps

  1. Open your base.
  2. In the left sidebar, click Add or import.
  3. Select Import data.
  4. Choose CSV file.
  5. Drag and drop your file (or browse to it).
  6. Airtable opens a preview showing how it parsed the file.

Review field types

Airtable auto-detects field types from the data:

  • Numeric columns become Number.
  • Date strings become Date.
  • Repeated text values become Single select.
  • Comma-separated values become Multi-select.
  • URLs become URL.
  • Email addresses become Email.

For each column, you can override the detected type using the dropdown. The first column becomes the primary field by default, change it if a different column makes more sense as the unique identifier.

Finish the import

  1. Confirm the field types look correct.
  2. Optionally rename columns.
  3. Click Import.

The new table appears as a tab. You can rename it, add views, or link it to other tables in the base.

2. Import into an Existing Table (CSV Import Extension)

Use this method when the destination table already exists and you want to either add new rows or update existing ones.

Add the extension

  1. Open the base and the table you want to import into.
  2. Click the Extensions icon in the top-right (or Tools > Extensions).
  3. Click Add an extension.
  4. Search for CSV import and add it.

The extension lives in the side panel and stays available for future imports.

Run the import

  1. In the CSV import panel, drag your CSV file in.
  2. The extension shows each CSV column on the left and a dropdown on the right to map it to an Airtable field.
  3. Airtable auto-matches columns whose names match exactly. Adjust the rest manually.
  4. Choose what to do with unmapped columns, leave them out, or click Create new fields to add them as new columns in the table.
  5. Choose Add new records (default) or Merge with existing records.

Update existing records (merge)

To update rows that already exist instead of creating duplicates:

  1. Select Merge with existing records.
  2. Choose a match field: a field in your table that uniquely identifies each record (like an ID, Email, or External ID).
  3. The CSV must have a column you can map to that match field.
  4. Click Import.

For each row in the CSV:

  • If the match value already exists in the table, Airtable updates that record.
  • If it doesn’t, Airtable creates a new record.

Match is case-sensitive. “alex@example.com” and “Alex@example.com” are treated as different records. Normalize your match field before importing.

Settings to know

Before clicking Import, expand the settings panel and choose:

  • Skip blank or invalid values: empty cells in the CSV won’t overwrite existing values when merging.
  • Create missing select options: if the CSV has a select value that isn’t in your field’s option list, add it automatically.
  • Set first row as header: toggle off if your CSV has no header row.

3. Paste Data Directly into a Grid

For small ad-hoc imports, copy/paste is faster than the extension.

  1. Open your CSV (or any spreadsheet) in Excel, Google Sheets, or Numbers.
  2. Select the data range, without the header row.
  3. Copy (Cmd+C / Ctrl+C).
  4. In Airtable, click the cell where you want the paste to start (usually the leftmost cell of the first empty row).
  5. Paste (Cmd+V / Ctrl+V).

Airtable matches columns by position, not by name, so make sure the order of columns in your spreadsheet matches the order in your Airtable table. Linked record fields, attachments, and formula fields cannot be pasted into directly, leave those columns out of the paste range.

4. Sync from a Live CSV URL

If your source data changes regularly, set up a sync instead of re-importing.

  1. In the base sidebar, click Add or import > Sync data.
  2. Choose CSV as the source.
  3. Paste a public URL that returns a CSV file. Common sources:
    • A Google Sheet’s CSV export URL (...export?format=csv&gid=...).
    • A Dropbox or Box direct download link.
    • An internal data endpoint at your company.
  4. Choose how often to refresh (manual, hourly, daily).
  5. Click Sync.

A synced table refreshes from the source on its schedule. Records can’t be edited in Airtable directly, they update from the source. You can still add expand fields alongside the synced columns to capture local data (notes, status, owner) that lives only in Airtable.

Plan gating. CSV sync requires a Team plan or higher. The CSV import extension and import-as-new-table both work on the Free plan.

Limits and Common Errors

Limit / ErrorDetail
Maximum rows per import25,000 rows in a single import via the extension; 15,000 for import-as-new-table
Maximum file size5 MB
Records per baseFree 1,000; Team 50,000; Business 125,000; Enterprise 500,000
”Field type doesn’t match”The CSV value can’t be coerced into the destination field type: for example, text in a Number field. Either fix the source data or switch the field type.
Duplicate records appear after mergeYour match field has whitespace, case, or formatting differences between CSV and Airtable. Trim and lowercase before importing.
Multi-select values become a single valueUse commas to separate values in the CSV cell, and confirm the destination field type is Multi-select, not Single select.
Date format wrongCheck the date format in the CSV (YYYY-MM-DD is most reliable) and the date field’s format setting in Airtable.

Take a snapshot before large imports. Click the base name > Base history > Take a snapshot. If anything goes wrong, you can restore in one click.

Which Method Should You Use?

  • First-time load, no destination table yet? Import as a new table.
  • Adding or updating rows in an existing table? CSV Import extension with merge.
  • Quick paste of a few hundred rows? Copy from the spreadsheet, paste into a grid view.
  • Source data changes regularly? Sync from a CSV URL (Team plan).

Stop Importing CSVs Manually

CSV imports work fine when they’re rare. When the same data needs to land in Airtable every day, an AI assistant can pull it from email, Drive, Slack, or your CRM and update the right records on its own. Carly is an AI assistant that connects to 200+ apps including Airtable and handles those repeating data flows for you.

More Airtable guides: How to link tables in Airtable · How to create a form in Airtable · How to export Airtable to Excel · Best AI workflow automation tools

Ready to automate your busywork?

Carly schedules, researches, and briefs you—so you can focus on what matters.

Get Carly Today →

Or try our Free Group Scheduling Tool or Free Booking Page

Related Articles

Guides

How to Create a Form in Airtable (2026 Guide)

Guides

How to Export Airtable to Excel (2026 Guide)

Guides

How to Link Tables in Airtable (2026 Guide)