Automatically Import Data

Topic Labels: ImportingExporting
1263 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi all,

I have a team of people who need to import data into airtable. I dont want them to actually go into airtable and import themselves.

An ideal example would be, the user creates a CSV or XLS doc, saves it to a specific place, then airtable sucks it up and imports as new rows into a specific table…

Any suggestions or thoughts on this?


1 Reply 1

The only way to do this is with an automation & integration tool like (There are other automation & integration tools as well, but Make is the one that I recommend for my clients.)

Your users would put the CSV file (or the XLSX) file into a “watch folder” in a cloud storage space such as Google Drive, and then Make would process the files that are dropped into this “watch folder”.

I would recommend using CSV files instead of XLSX files, because Make already has a Parse CSV module built into the app, whereas you would need to custom-create your own way to parse your XLSX files.

Note that all of your CSV files will need to share the same structure in order to work properly. If you’re expecting different structures, then one easy way to handle that would be to setup different watch folders + different Make scenarios to process each watch folder.

p.s. If it’s your very first time working with Make, it might take a little while to figure it out. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with this, please feel free to contact me through my website: Airtable consultant — ScottWorld