Use Airtable & EasyCSV Together

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

Connect Airtable to EasyCSV and Create or Update Rows - Quick Setup Video & Steos

How to connect Airtable to EasyCSV and import

  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, you will see a banner at the top of the import page to connect Airtable -or- click the "Import Flow" link at the top of the page.
  5. If connecting in the Import Flow view: Scroll to the bottom of the import Flow to see the Airtable options and a link to connect Airtable to EasyCSV.
  6. Choose your Airtable Base and Table in the Import Flow Airtable Destination Options
  7. Follow the directions to map spreadsheet columns to the right fields in Airtable.
  8. Try your first import!

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 info and save.
  2. Go to the Import Flow and scroll to the bottom for the Airtable destination options.
  3. Click into the option for Creating/Updating Records when importing
  4. Scroll down to find the radio buttons labeled: Do you want to check if a record exists before creating a new one?
  5. For "Field to search by" choose the column from your Airtable view that holds the value you want to use as the lookup.
  6. 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.
  7. Make sure the checkbox for "Update matched records with spreadsheet data being imported" is checked.
  8. Click the "Save" button.
  9. 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).

How to reconnect Airtable to EasyCSV - and new Workspaces and Bases

I just want to add a new Workspace or Base so EasyCSV can see it

  1. Log into Airtable, click your name / avatar in the upper-right
  2. Click "Integrations"
  3. Click the tab labeled "3rd Party Integrations"
  4. Click on any EasyCSV connection you have
  5. Click on "+ Add Base" and add any new Bases you want to have EasyCSV see
  6. Go back to EasyCSV and refresh the page for EasyCSV to pull and display the new Workspace(s) or Base(s). It may take 1-3 minutes as Airtable may have to clear their cache.
  7. If you want to make it so EasyCSV can see ALL current & future Workspaces & Bases then follow the reconnect directions below.
  8. Contact EasyCSV via email or chat if you have any issues.

I need to reconnect because I am getting an API or API Permission error

  1. Log into Airtable, click your name / avatar in the upper-right
  2. Click "Integrations"
  3. Click the tab labeled "3rd Party Integrations"
  4. Delete all EasyCSV connections you have
  5. Log into EasyCSV
  6. Click here to: Reconnect Airtable to EasyCSV
  7. Select specific Workspace and Bases you want EasyCSV to have access to -or- select the option to allow EasyCSV to have access to all current and future Workspaces and Bases. If you choose specific Workspaces & Bases, and you add new ones in the future you want to use with EasyCSV. Then follow the directions above to add those to the Airtable <> EasyCSV connection.