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
- Log into your Airtable account.
- Log into EasyCSV
- 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).
- 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.
- 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.
- Choose your Airtable Base and Table in the Import Flow Airtable Destination Options
- Follow the directions to map spreadsheet columns to the right fields in Airtable.
- 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?
- Once you create your import page for Airtable enter in your Airtable info and save.
- Go to the Import Flow and scroll to the bottom for the Airtable destination options.
- Click into the option for Creating/Updating Records when importing
- Scroll down to find the radio buttons labeled: Do you want to check if a record exists before creating a new one?
- For "Field to search by" choose the column from your Airtable view that holds the value you want to use as the lookup.
- 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.
- Make sure the checkbox for "Update matched records with spreadsheet data being imported" is checked.
- Click the "Save" button.
- 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).