Use Airtable & EasyCSV Together

How to use EasyCSV to enable anyone to upload CSV/Google Sheet data into your Airtable Base & Tables.

Quick Links:

  1. Connect Airtable to EasyCSV
  2. How do I map spreadsheet column names to Airtable fields?
  3. How do I update existing records instead of always adding records as new data?
  4. How do I schedule a daily, weekly, monthly export of my Airtable data to CSV or XLSX?

Airtable quick setup video

How to connect Airtable to EasyCSV

  1. Log into your Airtable account.
  2. Log into EasyCSV
  3. Create a new sheet import page on EasyCSV.io using a CSV export file of the Airtable table you want to import data into (shown how-to in video above).
  4. After the page is created, click the "Import Flow" link at the top of the page.
  5. Scroll to the bottom of the import Flow to see the Airtable options and you will fill out 3 details: Airtable API Key Auth token, Base ID, and Table Name.
  6. Click here to get your API key from your Airtable.com Account Page
  7. To get your Base ID and Table Name, go here to your list of Airtable APIs
  8. Click on the Base you want to create records for.
  9. In the left nav, click the table you want to create records for.
  10. Click "Create Records" for the table.
  11. In the right-hand side code area you will see a POST url that looks something like this: https://api.airtable.com/v0/app1a2b3c4d5/Opportunities
  12. In the example above, your Base ID value would be: app1a2b3c4d5
  13. In the example above, your Table Name value would be: Opportunities
  14. Click the "Test Airtable API Details" below after entering your values.
  15. Select "Airtable" from the "Choose Integration" dropdown.
  16. Click the "Save" button.
  17. Follow the directions below to map spreadsheet columns to the right fields in Airtable.

How do I map spreadsheet column names to Airtable columns/fields?

Use the EasyCSV feature: "Field Mappings". You will find it at the top of your sheet import page if you are logged into EasyCSV and are the admin.

For each Airtable column/field you want populated create a new field mapping.

Select the column value you want pushed into a specific Airtable column/field.

How do I update existing records instead of always adding records as new data?

  1. Once you create your import page for Airtable enter in your Airtable credentials in the Sheet Details area and click save.
  2. Go back into Sheet Details
  3. Scroll down to find the radio buttons labeled: Do you want to check if a record exists before creating a new one?
  4. For "Field to search by" choose the column from your Airtable view that holds the value you want to use as the lookup.
  5. For "Spreadsheet column or Virtual Field with search value" choose the column or EasyCSV Virtual Fielf you created you want to use for checking if the value exists in the lookup field in Airtable.
  6. Make sure the checkbox for "Update matched records with spreadsheet data being imported" is checked.
  7. Click the "Save" button.
  8. Now you can import and matched records will update all fields you submit and new rows will be added as new records in Airtable (if that checkbox was left checked in Sheet Details).