How to export from Zotero to Excel

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.

  1. Export the database from Zotero using the BibTeX format.Export Zotero
  2. 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.

    Import JabRef

  3. 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.

    Export JabRef

  4. Open the OpenOffice Calc file and save it as a Microsoft Excel file.

    OpenOffice

  5. Finally, we can open the Excel file and format the results as we like.

    Excel file

Share Button

3 Comments

  1. Hola Belén,

    Estoy tratando de seguir tus pasos para exportar una colección de zotero a excel y tengo unas dudas pues no lo logro. En el jabaref no me aparece la opción de open office calc. ¿Será por que estoy en un ambiente windows en vez de un mac? O ¿tengo que instalar el open office para que esa opción salga desde jabaref?
    Gracias por tu ayuda y felicidades por tu sitio,
    Saludos,

    1. Hola, gracias. Después de ver tu comentario, acabo de comprobar lo que dices en un portátil Windows y sí me aparece la opción. Es la versión 2.10 de JabRef y el ordenador donde lo he hecho no tiene instalado Open Office. Comprueba si tienes la última versión de JabRef, o prueba a descargar el .jar si lo que tienes es el .exe, o al contrario.

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload the CAPTCHA.