Export EndNote to Excel: 4 Easy Ways

How-to basics · Updated November 22, 2026

Yes, you can export references from EndNote to Excel. The fastest method is to use EndNote’s built-in “Export References” feature to save a text file, then open that file in Excel using the Text Import Wizard. Alternatively, you can copy selected references and paste them directly into Excel, or use EndNote’s “Output Style” to format references as a table before copying. This article explains each method step by step, covers common formatting issues, and answers frequently asked questions.

Why Export EndNote References to Excel?

EndNote is a reference manager that stores bibliographic data like authors, titles, journals, and DOIs. Exporting to Excel is useful when you need to:

  • Create a custom bibliography or reading list
  • Share reference data with colleagues who don’t use EndNote
  • Perform data analysis, such as counting publications by year or author
  • Clean or edit large batches of reference data
  • Combine references from multiple sources into one spreadsheet

Excel is a natural destination because it handles large datasets, allows filtering and sorting, and can be used for further processing like merging with other data.

Method 1: Export as Text File and Import into Excel

This is the most reliable method for preserving all fields. It works with EndNote 20, EndNote X9, and earlier versions, and on both Windows and Mac.

  1. In EndNote, select the references you want to export (hold Ctrl/Cmd to select multiple).
  2. Go to File > Export.
  3. In the Export dialog, choose a file name and location.
  4. Set “Save as type” to Text File (*.txt).
  5. In the “Output Style” dropdown, choose Tab Delimited or Refer/BibIX. Tab Delimited is easiest for Excel.
  6. Click Save.

Now open the text file in Excel:

  1. Open Excel and go to Data > From Text/CSV (or Data > Get External Data > From Text in older versions).
  2. Select the exported .txt file.
  3. In the Text Import Wizard, choose Delimited and click Next.
  4. Check Tab as the delimiter (uncheck others), then click Finish.
  5. Choose where to place the data (e.g., New worksheet) and click OK.

Your references will appear with each field in a separate column. Note that the order of columns depends on the output style; Tab Delimited typically includes all fields.

Method 2: Copy and Paste Directly into Excel

If you only need a few references or want a quick snapshot, copy-paste works well.

  1. In EndNote, select the references you want to copy.
  2. Right-click and choose Copy (or press Ctrl+C on Windows, Cmd+C on Mac).
  3. Open Excel and select the top-left cell where you want the data.
  4. Right-click and choose Paste Special, then select Text (or just paste normally).

This pastes each reference as a single row, with fields separated by tabs. However, the column order may not be consistent, and some fields may be missing if the current output style doesn’t include them. To control which fields appear, change the output style in EndNote before copying (e.g., choose Numbered or Author-Date).

Method 3: Use an Output Style to Create a Table

EndNote’s output styles can format references as a table with columns. This is useful if you want a clean spreadsheet without extra steps.

  1. In EndNote, go to Edit > Output Styles > Open Style Manager.
  2. Select a style that supports tables, such as APA 7th or MLA. Some styles have a “Table” option.
  3. Close the manager. In your library, select the references.
  4. Go to File > Export and choose Rich Text Format (.rtf) or HTML.
  5. Open the exported file in Word or a browser, then copy the table and paste it into Excel.

This method is more complex but gives you a formatted table that you can then adjust in Excel.

Method 4: Use EndNote Online (Web Version)

If you use EndNote Online (the free web version), the export process is slightly different.

  1. Log in at myendnoteweb.com and go to your library.
  2. Select the references you want to export.
  3. Click Export in the toolbar.
  4. Choose Tab delimited as the format, then click Export.
  5. Save the downloaded .txt file and import it into Excel as described in Method 1.

EndNote Online does not offer a direct “Export to Excel” button, but the tab-delimited file works the same.

Common Problems and Troubleshooting

Users often run into these issues when exporting to Excel:

  • Data appears in one column: This happens when the delimiter is not recognized. In Excel’s Text Import Wizard, make sure you select Tab as the delimiter and not just Comma.
  • Missing fields: The output style determines which fields are exported. If you need specific fields (e.g., DOI, abstract), choose a style that includes them, or create a custom output style.
  • Special characters garbled: If your references contain accented characters, ensure the text file is saved with UTF-8 encoding. In EndNote’s Export dialog, there is an Encoding option—choose UTF-8.
  • Line breaks within fields: Some fields (like abstracts) may contain line breaks. In Excel, these will appear as separate rows unless you handle them. One workaround is to replace line breaks with spaces in EndNote before exporting.
  • Excel truncates long numbers (like DOIs): This is a common Excel issue. After importing, select the column and format it as Text to prevent scientific notation.

Comparing Methods: Which Should You Choose?

The best method depends on your needs:

  • For a complete, accurate export of many references: Use Method 1 (Text File + Import). It preserves all fields and is most reliable.
  • For a quick copy of a few references: Use Method 2 (Copy/Paste). It’s fast but may require cleanup.
  • For a formatted table: Use Method 3 (Output Style with Table). This is useful for presentations or reports.
  • For EndNote Online users: Use Method 4, as the desktop methods don’t apply.

If you need to export references regularly, consider creating a custom output style that includes exactly the fields you want, in the order you want. This saves time in the long run.

Frequently Asked Questions

Can I export EndNote to Excel directly without a text file?

No, EndNote does not have a direct “Export to Excel” button. However, you can copy and paste references directly into Excel, which is a form of direct export. For a more structured approach, the text file method is recommended.

Why does my exported file show only one column in Excel?

This usually means the delimiter was not set correctly. When importing the text file, ensure you choose Delimited and then select Tab as the delimiter. If you used a comma-separated file, choose Comma instead.

How do I export only certain fields (like title and year) to Excel?

You need to use an output style that includes only those fields. In EndNote, go to Edit > Output Styles > Open Style Manager, select a style, and edit it to include only the fields you want. Then use that style when exporting.

Can I export EndNote references to Excel on a Mac?

Yes, the process is the same on Mac, but the keyboard shortcuts differ (use Cmd instead of Ctrl). The Text Import Wizard in Excel for Mac works similarly; you may need to go to Data > Get External Data > Import Text File.

Will my EndNote attachments (PDFs) be exported to Excel?

No, attachments are not included in the text export. Only bibliographic fields are exported. If you need to link to PDFs, you can export the file paths as a field (if you add a custom field), but the PDFs themselves are not embedded.

What if my references have special characters like Greek letters?

To preserve special characters, make sure you export with UTF-8 encoding. In the Export dialog, look for an Encoding option and select UTF-8. When importing into Excel, choose the correct file origin (UTF-8) in the Text Import Wizard.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.