Skip to Main Content

EndNote

Exporting Endnote Data to Excel

Exporting EndNote data to Microsoft Excel is possible, but not exactly straightforward. Some clean-up of your data may be necessary to do in Excel. The basic process is below. The Style file you need is in the box below this.

Save the Excel All Authors Style below to your EndNote.  Then....

Go to EndNote
File>Export
Give your file a name
Choose the drop down for .txt
Choose the style called Excel
Click Save

When you open the file in Excel, you will need to choose Delimited and then "Other" and put an * in the box.
 

Excel Style for EndNote