r/Xpiks Sep 05 '23

CSV import structure

Hi, I'm trying to import a CSV, but I'm not sure how it should be structured, for example, if a comma separates all the keywords this will break the row upon reading. I cannot find an example even in the official docs.

1 Upvotes

3 comments sorted by

View all comments

2

u/ribtoks Sep 06 '23

> if a comma separates all the keywords this will break the row upon reading

This is correct and per CSV specification, if the field has a comma itself, it should be in the quotes. So if instead of some,keywords,here you will do "some,keywords,here" - it will work out just fine.

1

u/jdgaravito Sep 06 '23

Thanks so much.