From EndNote to Excel

Below, I’m presenting tips and codes to transfer a library from EndNote to Excel using an (EndNote) Output Style File.

Before using the code, you should note that only the following reference types* will be correctly exported: journal articles, book, book section, edited book, conference proceedings, report, thesis, blog post, electronic article, web page, generic.

* As defined in EndNote

How to transfer from EndNote to Excel

Exporting from EndNote

  1. Download the Output Style File (*.ENS) here
  2. In EndNote, open the library you wish to export to Excel
  3. In your downloads folder, open the ENS file you downloaded. It will open it as a style to edit in EndNote
  4. Save it using the name “EndNote to Excel” (you can change it, just remember it!)
  5. Back in your library, in Bibliographic Output StyleEndNote to Excel
  6. Find “EndNote to Excel” and click “Choose”EndNote to Excel
  7. Select all the references you wish to export to Excel
  8. In “File”, click on “Export…”
  9. Select “Text File (*.txt)” as save type and “EndNote to Excel” as Output styleEndNote to Excel
  10. Save and note the location of the new TXT file.

 

Import in Excel

  1. In Excel, on a new spreadsheet, import the library using the “From Text” functionality (or “Import from text file” in earlier Excel versions). It will open the Text Import WizardEndNote to Excel
  2. Choose “Delimited”, click “Next”EndNote to Excel
  3. Check only “Tab”, click “Next”EndNote to Excel
  4. The default settings should be “General”, click “Next”EndNote to Excel
  5. Confirm where you want the data to be added and Voilà !

 

Print Friendly, PDF & Email
The following two tabs change content below.

Gatien

Health economist at Johns Hopkins University

Latest posts by Gatien (see all)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.