excell file into airtable automation

[inesrosemasson]

Hi, 

I would like to import a CVS file into my base and write an automation to adapt the file to my base on airtable. 
For example: the title of the colums are different on each, some info need to be extracted but others not. 
Does someone have a script for that ? 

Thank you so much !

[Pascal_Gallais-]

Hello,

One way to deal with that is to use the "CSV Import" free extension:

You will have the possibilty to choose which fields to import and how to map them with you Airtable fields.

Another way would be to import your csv in a new table and then adapt a view on this "temporary table" to copy / paste manually the records in to the destination table.

Regards,

Pascal

[ScottWorld]

If you want to automate the process of importing CSV files into Airtable, you can do that with Make’s advanced automations for Airtable.

I demonstrate how to do this on this Airtable podcast episode.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

[Pascal_Gallais-]

@ScottWorld 

Thank you, I watched the video, it is very interesting, both for imports and exports.

I am wondering if you have cope with a case when you need to import every day a csv file of about 10 000 rows with the upsert option. I cannot use this make scenario because there are too many runs.

Would you deal with that with another "Make option", or would you have an "import table" in Airtable that would be cleared before each new import and then have an automation in Airtable to upsert records on the "live table"?

Thanks

Pascal

[ScottWorld]

Hi @Pascal_Gallais- ,

You can pay for more automation runs with Make by choosing a different plan here.

If you want to avoid paying for more automation runs, you would need to manually import your CSV file into Airtable using Airtable’s CSV Import extension, which lets you merge duplicates.

Although I’m not sure if the CSV extension will support 10,000 rows. It used to have a limit of 5,000 rows, which might still be in place today.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

[Pascal_Gallais-]

Thanks @ScottWorld ,

Using the CSV import extension is what I currently do and I confirm that it works with 10 000 rows.

Regards,

Pascal

[ScottWorld]

That’s great to hear! Thank you!