EndNote List Archive
Archive by date
This Month By Date
This Month By Topic
Importing/Exporting to MS Excel
|Importing/Exporting to MS Excel
Author: McNeel Environmental, Inc
Posted: Fri, 05 Mar 2004 12:38:23 -0600
|I am working on being able to exchange EndNote library data with MS Excel.
This is important, as I do literature reviews for clients who use programs
other than EndNote, and Excel appears to be a fairly universal medium.
The biggest problem, as noted by many here, is carriage returns in EndNote
fields. There was a work around suggested: end all records with @@@, then
use a word processor to remove unwanted paragraph breaks.
A better solution, using Version 7 at least, is to export your library file,
and choose the "save file type as" option "XML". Open excel, create a new
file, then under "Data" choose "Import external data"; "Import Data" (note
that this on my PC using Excel 2002 on Windows XP. It does note work on my
Macintosh using Excel X). This works seamlessly as long as you take the
carriage returns out of you author and keyword fields. My concern is only
being able to keep carriage returns in the abstract and notes fields.
MY QUESTION IS GETTING DATA FROM EXCEL TO ENDNOTE, with carriage returns in
the abstract and notes fields. The only solution I can come up with is
figuring a way to export tagged files (similar to PubMed for example) from
Excel. Has anyone seen/developed a method/macro for exporting tagged files
The idea of the @@@ record ending is another workable (though less elegant)
Note: you can find / replace carriage returns in EndNote using
<option><return>. See the help file...
Pleas J. McNeel IV, PE
McNeel Environmental, Inc.
This email has been scanned for all viruses by the MessageLabs Email
[View Complete Thread]
Previous by date: Re: thanks, Pirjo Kespre
Next by date: RE: A colon too many in my citations- what am I doing wrong?, Wiedemann, Leanne
Previous thread: A colon too many in my citations- what am I doing wrong?, Bob Hudson
Next thread: A colon too many in my citations- what am I doing wrong?, Bob Hudson