Import in multiselect column

ThBunte-B-TK · September 21, 2023, 9:48am

Hi,

ist there a way for an csv / excel import into an multiselect Column.
The problem ist, that the values (Product categeries) still have a comma inside the different values.
“Grafik & Design, Layout, DTP| Adobe| Photoshop| Webdesign & -Programmierung”
Means row was assigned to Categorie:
Grafik & Design, Layout, DTP
Adobe
Photoshop
Webdesign & -Programmierung
How to get such values in one cell into an multiselect cell, while import?
All tests with different delimiters doesn’t work.

eash · September 21, 2023, 10:16am

If I understood correctly
Replace all commas with an unused special character in MS Excel, upload a CSV with a separator “,”. In SeaTable, replace these special characters with commas.

Automatic translation

ThBunte-B-TK · September 21, 2023, 10:35am

I try it so (replace comma inside with semikolon or hashtag) and use the comma only as delimiter between the single categories. But these doesn’t help.
Here the cell “Grafik & Design# Layout# DTP, Adobe, Photoshop”
But the import generates these as one, long multiselect
See Screenshot
https://app.screencast.com/1sJdZ9DAJPhVg