Skip to main content
Dansk Deutsch Norsk Svenska

Export the EndNote library to Microsoft Excel

Updated
endnote discovery content block rounded optimised.gif

Want to know what EndNote has to offer? Try our  free  series that guides you through the entire process. Read more here.

In this article, we will show you how you can export your EndNote library and references to an Excel sheet.

Alfasoft has created an EndNote output style with a procedure that makes it possible to export your EndNote library, or selected references from your EndNote library, to an Excel sheet.

The difference between the below procedure and using the existing "basic Excel export style" in EndNote is that the below procedure exports all fields (as compared to a selected few) and include headings for the fields in Excel.

DOWNLOAD AND ADD THE ENDNOTE OUTPUT STYLE FILE “ALFASOFT EXCEL EXPORT” TO YOUR ENDNOTE

  1. Download the file EndNote Output Style "alfasoft-export.ens" by clicking here!
  2. Double-click the downloaded file to open it in your EndNote.
  3. EndNote: File > Save as. Choose the name “Alfasoft Excel Export”, and click Ok.

OPEN YOUR ENDNOTE LIBRARY, AND SELECT THE REFERENCES YOU WANT TO EXPORT TO EXCEL

  • If you want to export all the references in your library you do not have to select any.
  • Do a search or click a group to view your references.
  • Ctrl+A to select all references in view.
  • Click first/top reference, and then Shift+click last/bottom reference to select references in sequence.

EXPORT YOUR LIBRARY/SELECTED REFERENCES TO A TEXT FILE

  1. EndNote: File > Export.
  2. Filename: Enter your chosen filename
  3. Save as type: Text file (*.txt)
  4. Output style: “Alfasoft Excel Export”.
  5. If this is the first time using this style you must select “Select another style” from the drop-down list, and then find and choose “Alfasoft Excel Export” from the list.
  6. Uncheck the “Export Selected References” if you want to export all references in your library.

OPEN AND COPY ALL TEXT IN THE EXPORTED TEXT FILE

  1. Open the exported text file in Notepad (or another text editor).
  2. Ctrl+A to select all the text in the text file.
  3. Ctrl+C to copy all the text in the text file.

OPEN A NEW DOCUMENT IN MICROSOFT WORD AND PASTE THE TEXT

  1. Ctrl+V to paste all the text from the text file into your Word document.

REPLACE EVERY PARAGRAPH BREAK IN THE TEXT WITH A SEMICOLON

  1. Word [Home]: Replace
  2. Find what: ^p
  3. Replace with: ;

ADD A PARAGRAPH BREAK AFTER EACH REFERENCE

  1. Word [Home]: Replace
  2. Find what: alfabreak;
  3. Replace with: ^p

COPY AND PASTE THE TEXT TO AN EXCEL SHEET

  1. Word: Ctrl+A to select all text in your Word document.
  2. Word: Ctrl+C to copy all text in your Word document.
  3. (Download and) Open the Excel document “alfasoft-endnote-header.xlsx”: www.alfasoft.com/files/alfasoft-export-header.xlsx
  4. Click the cell A2, and then Ctrl+V to paste the references into your Excel sheet.

For more options you can instead paste the text back into a text file and save. Then open Excel, and choose File > Open, and open the text file (remember to choose File type = Text file, in the Excel file open window). Choose Delimited (Tab) and File origin = “65001 : Unicode (UTF-8)” as defaults/first try.

 

Related articles