Exporting References from Endote

Friday, 17 November, 2006

I was putting together a relational database recently that needed to contain a table of references. The references themselves were sat in Endnote so I thought it would be straightforward to export them into something like a CSV or Tab-delimited file. It’s not though!! The “Export” feature doesn’t do what you expect and supports TXT, RTF or XML, exporting using the currently selected output style.

The solution is to create an output style using the (text) format you prefer. I like working with CSV because they are straighforward to manipulate. Whilst a tab-delimited output style is made available as part of Endnote, a CSV is not. So I created a very simple CSV output style to generate a CSV file. With this output style selected you make sure all the references are highlighted and then go to Exprot in the File menu. A new TXT file will be generated that is a CSV and can be dumped straight in to Excel or a database.

Note: I only created the ouput style for “Reports” and “Journals” and, for some strange reason, Endnote wouldnt put a comma after the author field (but did after all the others). I changed this to a * and then did a simple find and replace to put commas back in, in my text editor.

  1. Parker

    Monday, November 28, 2022 - 09:12:45