CSV Editor

Hey, so it looks like the data import for CSVs that have relationships to other tables is at least a somewhat unique syntax. Adding entire fields to the header is obviously easier in something like excel since it will inject the comma delimeter in all the data rows. Editing the header syntax needs something like notepad++ though since Excel messes with quotations.

Just curious - anyone have a specific tool they use that’s handy for manipulating the CSV and header prior to import?


Hello @James_Hereford,

I’m not sure if it’s the perfect solution, but I use VS Code with the Rainbow CSV plugin installed.
It might be convenient for you as well.


Thanks! I’ll check it out for sure.