Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 01, 2022 02:38 AM
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 !
Solved! Go to Solution.
Mar 01, 2022 04:05 AM
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.
Mar 01, 2022 02:40 AM
Before importing, try putting quotation marks around the phrases that contain commas.
Mar 01, 2022 02:54 AM
Thanks for your answer.
Already tried this and it didn’t work…
Mar 01, 2022 04:05 AM
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.
Mar 01, 2022 07:43 AM
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.
Jan 24, 2024 03:53 AM
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! 🙂