How to export references from Endnote to an Excel spreadsheet?

EndNote EndNote General
2

Hi. To export references from Endnote to an Excel spreadsheet properly, you need to change the output style to “Tab Delimited”. And if the information is not displayed properly when pasted to an Excel spreadsheet, you may need to remove carriage returns before copying the information from Endnote.

You may find steps for exporting references from Endnote to an Excel spreadsheet at:

https://Endnote?

But if you find the information pasted is not displayed properly, you may need to remove carriage returns. Try again with the steps below:

  1. Save a back up of your Endnote library before making any changes

  2. Select the references you would like to export

  3. Click " Edit" (for X9 or earlier version) / " Tools" (for Endnote 20) to change the output style as " Tab Delimited"

  4. Click " Edit" (for X9 or earlier version) / " Library" (for Endnote 20) > " Find and Replace"

  5. Choose " Any Field"

  6. Click " Insert Special" and choose " carriage return"

  7. Type " -//-" under " Replace with"

  8. Click " Change"

  9. Then, click " Copy Formatted" from Edit (for X9 or earlier version) / References (for Endnote 20) to copy the information of your selected references

  10. Paste the information to an Excel spreadsheet

removecarriagereturns.jpg