Answered By: Citations Committee
Last Updated: Jun 22, 2023     Views: 54547

Please be aware that this method will export your references in rows (there is an image of the end result below under links & files). 

Step 1) Download the Excel Style

  1. Download the file entitled, EndNote_to_Excel (below).
  2. Save it in the Style Folder in the EndNote application folder on your computer.

Step 2) Modify the references to remove carriage returns

If there are references in your Endnote library with carriage returns (line breaks, paragraph marks, etc.), this export style may not handle them properly. To remove these, follow the steps below.

  1. Save a backup of your Endnote library!
  2. Select All references in your library (or click Ctrl+A on a PC or Cmd+A on a Mac).
  3. In the Library menu, launch Find and Replace.
    1. Select Any Field.
    2. In the Find box, click Insert Special and choose Carriage return.
    3. In the Replace With box, type the following characters: -//-
    4. Click Change. This may take a few minutes.

Step 3) Copy the records into Excel

  1. Choose the EndNote to Excel style you just saved in the Style Manager in EndNote. 
  2. Select references to copy (Ctrl+A on a PC or Cmd+A on a Mac). From the References menu, choose Copy Formatted (Ctrl+K or Cmd+K on a Mac).
  3. Open a blank workbook in Excel and paste (Ctrl+V or Cmd+V on a Mac) your saved references into the blank workbook.
  4. Insert column headings as desired.
  5. In Excel, do a Find and Replace for the characters -//- and replace with a space. 

EndNote to Excel displays the following information in the Excel document in a Tab-Delimited format.

Generic Style

Record Number / Author / Year / Title / Reference Type / / / /Abstract / /

Style for Journal Articles

Record Number / Author / Year / Title / Reference Type / Journal / Volume / Pages / Abstract / Keywords / Accession Number

Style for Books

Record Number / Author / Year / Title / Reference Type / / / / / /

Style for Conference Proceedings

Record Number / Author / Year of Conference / Title / Reference Type / / / / Abstract / /

Once you have saved the output style, you can edit it from Edit > Output Styles > EndNote_to_Excel (or Open Style Manager to select EndNote_to_Excel)

Links & Files

FAQ Actions

Comments (15)

  1. I followed all the steps correctly (numerous times) but my library has exported into rows, not columns - and I can't transpose it (too much data) is there a particular way to ensure data is exported into columns and not rows?
    by Kate on Mar 19, 2019
  2. Thank you, this is fantastic! I wondered why it wasn't working at first but I then realised that I had not selected the "Excel Style" from the Style menu before doing the copy and paste. And to import into Excel, I selected, Paste > Text import wizard > Tab Delimited. Worked a treat. Thank you again.
    by Jodi G. on Apr 17, 2019
  3. This post wasted my time. I followed every detail and exported it as suggested. Unfortunately, it exported them as rows. Every detail of the reference file is saved in one row one column :( @Kebede Thanks for your comment! The reason it exported your references as one row/one column is because you didn't remove the carriage returns from your references. If you do, each element (author, title, year, etc.) will be in a different column (just like the image linked).
    by Kebede on Apr 27, 2020
  4. https://support.clarivate.com/Endnote/s/article/EndNote-Export-references-from-EndNote-to-Excel?language=en_US
    by sl on Jun 12, 2020
  5. I did it like explained in the text and got in all in rows. What solved the problem for me is to paste the copied references from endnote as text in excel (Mac: control+command+v : selecte as "text"; windows it is ctrl+alt+v i think)
    by Torsten on Jul 01, 2020
  6. This is great. Providing the style file also very helpful. There are two obvious steps omitted in the instructions. This may have been the reason why it did not worked for the researchers commented above. Once you copy the downloaded style file;1. Goto Edit>Output styles> tick endnote_to_excel (this will make it visible for the next step.2. Select the endnote_to_excel style from the dropdown menu or Edit>output style>endnote_to_excelAfter that you can copy formatted and paste to Excel. -------- Hi Anjana, Thanks for your comment! For your step 2, it's actually listed in the instructions under Step 3.1. Choose the EndNote to Excel style you just saved in the Style Manager in EndNote. Best, McGill Library
    by Anjana Ranasooriya on Jul 05, 2020
  7. At first, it didn't work for me also. the following steps worked perfectly: 1- save endnote to Excel file in the styles folder 2- tick the "endnote to excel" and "tab-delimited" and close 3- select references 4- again, tick "tab-delimited" from edit>output style> 5- copy, Ctrl+K 6- paste in excel using Ctrl+V
    by Idris Jae on Nov 24, 2020
  8. This worked for me! I needed to read the comments but I got there in the end. Thanks :)
    by Rachel Couban on May 04, 2022
  9. You saved me! After several wasted hours! Although depleted from energy, I will celebrate for this win! Hooray
    by AngieBen on Jun 30, 2022
  10. This process only kind of works and, as has become typical with Clarivate, the ens file doesn't include the DOI, which is critical. What i found to work is to do the steps, all the way up to the -//-, export the file and then open it up in Excel. That seems to work.
    by Jimpithecus on Oct 18, 2023
  11. I have discovered that the step involving the -//- is unnecessary for my purposes. Simply using a "; " for all fields worked just fine.
    by Jimpithecus on Nov 29, 2023
  12. Can I change the order of the output tabs? As in first column is author, second column is year, etc.?
    by YMF47 on Mar 25, 2024
  13. THANK YOU SO MUCH. I have done workarounds using a combination of EndNote, Word, and Excel for years. This is so much more elegant.
    by Karen Bannick McQuoid on May 10, 2024
  14. Great for Windows (11), it worked as a charm the first time!
    by Alfredo on Aug 28, 2024
  15. Thanks so much for this post! It actually works, but it took a while for me to understand how to use the Endnote to Excel style (finding style manager was difficult as I am not very familiar with EndNote). Otherwise, everything worked as you described! Can't be happier.
    by Anon on Sep 27, 2024

Related Topics