Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

CSV multi-select import separator

Solved
Jump to Solution
2572 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Romain_Gle
4 - Data Explorer
4 - Data Explorer

When importing a CSV with a multi-select column, Airtable will always detect commas as a separator and make tags from it. But in my case the tags contain commas I don’t want to have as a separator.

Do you know any workaround to either avoid thos specific commas to be detected as a separator, or change the separator character ?

Thanks !

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Try importing the phrases (with quotation marks) into a normal text field first, and then convert the text field into a multi-select field afterwards. See if that works.

See Solution in Thread

5 Replies 5

Before importing, try putting quotation marks around the phrases that contain commas.

Thanks for your answer.

Already tried this and it didn’t work…
image

ScottWorld
18 - Pluto
18 - Pluto

Try importing the phrases (with quotation marks) into a normal text field first, and then convert the text field into a multi-select field afterwards. See if that works.

It works !

Thank you for your answer it will be sufficient for my need for now… It’s not very comfortable though. Maybe if we could choose the separator between “;” or “,” (as they are both used is CSV) it would make the import feature easier to use… Or at least having the same splitting method between import and update…

Thx again.

I would suggest emailing support@airtable.com with this feature request!

However, in the meantime, you may want to try doing all of your importing using Make’s CSV tools and Make’s Airtable integrations.

Make lets you specify whatever separator you want to use in a CSV file! And Make gives you array tools to work with arrays like multi-select fields.

I give a demonstration on how to use Make to import CSV files into Airtable in this Airtable podcast.

And I show how to work with Airtable arrays in this Airtable podcast.

p.s. I am available for hire as an expert Airtable consultant to help with any of this! 🙂