Export endNote references to excel issue in "Notes" field

Hello,

I am trying to export my references library to excel sheet. I create new template under Bibliography and put the fields I want seperated by tab.

It exported successfully to excel but, “Note” field which contains: (Times Cited, Cited Reference Count, and Cited References) inserted in  new rows in the excel sheet and the file come disorganised.

For example, when I export : Record number, Author, Year, Note, Abstract  from one reference;

in the excel sheet the first row will be seperated to different cols:

the first col will be the Record number, the second col will be the Author, the third col will be the Year,  the forth col will be the Abstract,

the second row, first col will contains Times Cited number from the Note field

the third row, first col  will contains Cited Reference Count number from the Note field

the forth row, first col  will contains Cited Reference 1 from the Note field

the fiveth row, first col  will contains Cited References 2 from the Note field

the sixth row, first col  will contains Cited Reference 1 from the Note field

etc…

How can I solve this problem?

Thanks a lot.

Alaa

Hello Alaa Alarfaj,

You will want to use the following steps to export from EndNote to Excel.

 http://endnote.com/kb/110482

You will need to remove any carriage returns in your references for them to import properly into Excel.

The steps above have you make a copy of your library then remove the carriage returns and then export a file that Excel can import.