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
How can I solve this problem?
Thanks a lot.