Export as CSV problem : commas in article titles, lastname, firstname etc.

I want to export into a spreadsheet so that I can sort records by journal name and year. An alternative would be to produce some report directly from Zotero but I don't think that is possible. The commas that are in article titles and the author names lastname, firstname with semicolon separation, etc makes the data misaligned from the column headings.

Am I overlooking something obvious that will fix this. I'm using LibreOffice Calc.

The closest I can come to having data below column headings is to use a double quote (") as the separator. Is there a better idea? I need a count of articles by journal with a count of journal names.
Sign In or Register to comment.