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 Style
6. Find “EndNote to Excel” and click “Choose”
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 style
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 Wizard
2. Choose “Delimited”, click “Next”
3. Check only “Tab”, click “Next”
4. The default settings should be “General”, click “Next”
5. Confirm where you want the data to be added and Voilà !