Export csv files?

EndNote EndNote How To
1

Hello!

I hope I don’t post this twice by the other post in “general” disappeared …

I was using Endnote also for collecting and cataloguing artefacts for my thesis which didn’t went so well so I decided to try another database (Ninox) for the artefacts only.

Problem is: I need to export the data in the csv format.

Someone (CrazyGecko) here posted an instruction some time ago (2009) but it didn’t work.

Is it actually possible? And what could I have done wrong? Is Endnote 20 I’m using now different?

Here is the text:

The process for exporting Endnote library references in CSV file format (which is a .txt text file) is provided as follows (which is similar to exporting references in the tab delimited file format).

STEP 1: SAVE A COPY OF YOUR LIBRARY

 You will need to first prepare your EndNote library references by removing the carriage returns in each record prior to exporting. Carriage returns/linebreaks if exported will “bump” the data fields onto separate lines/rows instead of a columnar format. To prepare your EndNote library:

  1. Click on the File menu and select Save a Copy
  2. Save a new temporary copy of your library.

STEP 2: REPLACE CARRIAGE RETURNS

Close your library and open this new library during the following instructions, so as not to remove all of the carriage returns (an important EndNote delimiter) from the original version of the EndNote library. Once the new library file is open:

  1. Click the Edit menu.
  2. Choose Find and Replace. Older versions will have this listed as Change Text.
  3. Set the Select a Field option to Any Field
  4. Place the cursor into the Find: (Search for: in older versions) box.
  5. Click the Insert Special button.
  6. Insert a Carriage return
  7. Click in the Replace with: (Change the text to: in older versions) box and add slashes (//) or any other characters you’d like to replace the carriage returns for that field. ( Refer to image #1, bottom )
  8. Click Change.

STEP 3: EXPORT ENDNOTE REFERENCES USING THE MODIFIED CSV OUTPUT STYLE FILE

Now use the modified CSV output style file to export the Endnote library references. ( Refer to image #2 which shows the resulting CSV file as previewed in Excel and Word.)

After importing the CSV file into the receiving database or spreadsheet then reintroduce the carriage returns by using find and replace to locate the double slashes // with the carriage return. (Note: it’s important that the receiving database or spreadsheet is capable of performing find and replace. Otherwise you will not be able to replace the double slashes with carriage returns.)