Keep an Airtable table updated from a publicly accessible CSV file with miniExtensions Automatically Import CSV. Supply the CSV URL and a unique identifier shared by the CSV and Airtable, then run the import to create new records or update matching ones.

What you can do

• Import a public CSV into an existing Airtable table.
• Match rows using a unique identifier.
• Create new records and update existing matches.
• Repeat the import as the source changes.

Matching CSV rows to records

The CSV needs headers matching the Airtable destination field names and a shared unique identifier. For a supplier catalog, Product ID can connect each imported row to its corresponding Airtable product. An existing ID updates the record, while a new ID creates a record.

The import applies supplied non-empty values to the matching fields and leaves unrelated fields in place. Use explicit values such as a Discontinued status when the source needs to communicate a change, rather than expecting a blank cell or missing row to remove Airtable data.

The URL must return the CSV directly without requiring a private login. A sign-in or preview page is not an import file. Once a sample import produces the expected records, recurring runs can keep the table refreshed as the source CSV changes.

Examples of useful workflows

Import a supplier catalog

Use stable product identifiers to bring descriptions, availability, or other catalog values into Airtable. Keep fields managed only in Airtable separate from the source columns.

Bring in a published spreadsheet

Use a direct CSV export URL from a spreadsheet that can be fetched without authentication. The import reads the file available at that URL when the run occurs; editing the spreadsheet does not create an instant two-way connection.

Maintain a recurring report table

Publish a CSV with a persistent row identifier and reuse the URL for successive versions. Matching identifiers let you update the same Airtable records instead of treating every import as a new dataset.

How to get started

Provide a public CSV URL, match its headers to destination fields, and select the unique identifier. Test the import, then choose how often it should run.

Good to know

This is a one-way import. Missing source rows are not deleted, and empty CSV cells do not clear existing Airtable values.

Further instructions

See CSV import guide.