I tried many combinations with only simple columns, with complicates ones. The result is always unusable since the first category isn't in quotes. I always get results like this:
Code:
Author,Author2,"title"
or
Code:
epub,pdf,txt,"title","Author,Author2"
while it should be
Code:
"epub,pdf,txt","title","Author,Author2"
So splitting to columns is impossible. The best result I get using " as a separator but sometimes " can be in fields and it messes it up too, just not as much.
There are no settings for creating csv files so I didn't mess it up. What could cause this?
Because of this I created unnecessary complicated columns in calibre (so I could export one already modified column without needing to split into columns) which increases workload for calibre a lot.