Reply To: Categories Export – Multiple? – Part 2

02/22/2016 at 2:47 pm #366391
Steven Zahm
Keymaster

@ Matt

re: when we open the file in Excel, all of the categories get separated into their own cell.

When you import it, change the delimiter from tab to comma.

http://superuser.com/a/407085

*For this to work in Excel 2013, you must uncheck Use system separators in Options>Advanced**

Or add this to the top of the CSV file: http://superuser.com/a/730509

re: It would be nice to have the option of comma separated or tab separated. Is this something that is being considered for future releases?

Technically, that would be a TSV file, not a CSV file. I’m not planning on adding any options to the CSV Export to keep them simple to use.