Help

Re: CSV multi-select import separator

Solved
Jump to Solution
965 0
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!