Skip to main content

Importing a csv file with comas in rows

S

Hi everybody, i’ve been facing a problem for a few hours…
I wrote a csv file with python i’d like to upload on Airtable. Originally, i exported my base in csv format, modified it on python and then re-uploaded it on Airtable.
If i open my csv with Excel, no problem, every lines and rows are ok. But on Airtable, the lines which contain a list with comas are wrong interpreted. An example :
I try to upload this table (’|’ represents column-separator) :

prenom|nom|instrument|

jean|dupont|violon,piano,guitare|

marie|moulin|guitare

but i get :

prenom|nom|instrument|

jean,dupont,"violon,piano,guitare"| <-- ERROR

marie|moulin|guitare

Thanks if you have any idea…

2 replies

A

It’s because comma separated lists follow very strict rules, and you’ll need to tell Airtable how to interpret it. I’m not currently set up to show you the right way to do this, but a quick fix is just to add some sample data to Airtable, click “download as CSV” and you’ll be able to reverse engineer the format Airtable is expecting.

Hope that helps!

S
  • Samuel_Chatel
  • Author
  • New Participant
  • 1 reply
  • April 28, 2020

Thanks, it seems to work now !

Reply


Most helpful members this week

Terms & Conditions