Some days ago I needed to export a set of references from Zotero to a Microsoft Excel file. I tried to export and import them in Excel using different formats, but none of them was good enough. For example, a single article was imported into several rows, one per author, and that’s not the result that I wanted. Finally I found out the following mechanism although it requires several steps.
- Export the database from Zotero using the BibTeX format.
- Import it in JabRef as a new database. JabRef is another source bibliography reference manager that uses BibTeX as its native file format. You can download the .jar file from here, so you don’t need to install it.
- Export the database from JabRef using the OpenOffice Calc format. You can export it using the MS Office XML format, but as I mentioned before, each article will be in more than one row.
- Open the OpenOffice Calc file and save it as a Microsoft Excel file.
Finally, we can open the Excel file and format the results as we like.