New Synapse Feature: Export Your Publications Directly to an Excel Spreadsheet

Synapse is used by many of our faculty, staff, and departments to track their publications and collect bibliographies and statistics for annual reporting. While bibliographies can be formatted directly within Synapse, there are other instances where one might want to export the data for further organization and analysis. This new feature allows you to export your or your department’s publications directly to a CSV file (Excel spreadsheet). Previously, Synapse only allowed for export to RIS format, which can be read by citation management tools such as Endnote. While this is still a great option for many people and purposes, not everyone is familiar with using Endnote, and there are cases where a spreadsheet is the easier or more appropriate solution to our users’ needs:

  • Simple and quick way to see which of your publications have a PMCID, and which might still need to be submitted for grant compliance.
  • Keeping internal administrative notes such as the role of postdoctoral trainees in the publication, special grants, and awards that funded the research.
  • Quickly collect a list of identifiers (such as DOI, PMID) that can then be used to query an external database such as Web of Science, Scopus, or PubMed.
  • CSV files can be imported for use with data visualization and analytics tools, such as Tableau.

To export, simply select the “Export to Endnote/Excel” option from any “Works” section of an author or group profile page. Select “Export as CSV” on the following screen and the file will be automatically downloaded to your computer. 

For more information, contact us.