Export selected columns from Zotero to Excel

Candemum
Hi there,

Does anyone know how to export selected columns from Zotero to Excel?

When I export to a .csv file, some Zotero columns are merged into one in Excel while others, eg authors' names, are separated and in my example, take one Excel column by name. This is inconsistent between columns. I do not see how to do what I want without doing it by hand which could be very burdensome with >500 references.

Thank you for your help.
  • adamsmith
    Use Data --> From Text/CSV to get Zotero-exported CSV into Excel. For some reason, Excel's default CSV import has some bizarre bugs in correctly importing perfectly valid CSV like Zotero's export.
    Using another spreadsheet tools (like LibreOffice Calc) is also an option.
  • Candemum
    Awesome. Thank you very much. It is working perfectly.
Sign In or Register to comment.