I recently exported a box of comics to CSV. Here is the data I wanted exported:
My List View columns
Series, Issue Nr, Release Year, Story Arc, Publisher, Key Reason, CovrPrice Value, Storage Box, Variant, Artist, Writer
The issue I’m having is the VOL data is exporting and creating it’s own column that then shifts everything over a column and messes up the rest of my sheet. Is there any way to prevent this?
Below is a screen shot of what I’m talking about.
My guess is that the comma in “, Vol. 2” is causing the problem.
Can you share your other settings in your export?
At least with the Cloud export, you can use other delimiters. I’m wondering if a tab delimiter (and then be sure to tell the import that it’s tab-delimited) would help.
this should probably fix the issue:
(Of course, the program you’re importing the CSV to should also respect those field delimiter/field enclosuers!)
Can you let me know why you’re exporting to CSV? Maybe what you want to do is something you can do in CLZ Comics Web without having to go to Excel/Spreadsheet program.
