Exporting Endnote, Mendelay, and BibTex databases to MS Excel
This is a basic guide for converting an EndNote database format file to Microsoft XLS or XLSX (Excel).
Converting from EndNote to MS Excel is a far from trivial task as there is no single agreed standard database format for storing academic references. In addition, author fields can have single or multiple authors and this alone allows for a range of possible format options for saving.
The most direct methods are suggested here. However, I have never been able to get either method to work reliably with anything more than a few records at a time. All it needs to go wrong is a stray “tab” character somewhere in the data and the output is corrupted. For large data sets I found the fixed width output option far too time consuming to process, and with 1000+ record sets it became entirely impractical to verify the output quality.
The following method, while a little long winded, has proved extremely reliable for me (tested with data sets over 1,400 records).
Step 1: Export from EndNote to XML
- Highlight the records to export
- File -> Export
- Save as type: XML
- Output style: Show all fields
- Save (note where you are saving the file)
Step 2: Import XML to Mendeley
In Mendeley Desktop (free download)
- File -> Add files
- Select the XML file from Step 1 and Open it
This will import the file with the records properly formatted for Mendeley and you can see them in your Mendeley Library.
Step 3: Export from Mendeley to BibTex
In Mendeley Desktop
- File -> Export
- Save as type: BibTex (*.bib)
Step4: Open BibTex file in Jabref
In Jabref (free download)
- File – Open database
- Select the BibTex (*.bib) file from Step 3 and Open it
Step 5: Export from Jab ref to CSV
- File -> Export
- Files of type: Open Office CSV (*.csv) [There is an option for MS Office XML – I had less success with this format]
Step 6: Open CSV in MS Excel
In MS Excel
- File -> Open (Select “All Files” or “Text Files”)
- Select the Open Office CSV (*.csv) file from Step 6 and Open it
- This should open the converted files and you can now (File->) SAVE AS *.XLS or *.XLSX
As you can see it is a tedious route but, having tried several approaches I think this is the most robust and avoids having to go line by line through the outputs looking for misplaced fields. The added advantage is that if you have already invested in EndNote the other software is free.
It work but, a single step conversion tool would be welcome.
About the author – Robert holds the Chair in Strategic Management at the School of Business and is Co-Academic Director of the Edward M. Kennedy Institute in Conflict Intervention at the National University of Ireland Maynooth. He was the founding Head of the School of Business and served as Dean of the Faculty of Social Sciences. Robert was head of Executive Education at the Irish Management Institute and prior to this spent 18 years in industry.
School of Business
RT @GDruckerForum Mudlarking in the social ecology of cities – breaking the public-policy impasse by Martin Ferguson @martinjf52 @Socitm #GPDF19 #ecosystems #learnings #SmartCities #ShapeTheDebate druckerforum.org/blog/?p=2483 pic.twitter.com/tGKe8Tps0s
Why do I still get shocked that we have to keep explaining it. twitter.com/stratandbiz/st…
This is an absolute gem. Send it to a friend you know would have done the same. Don’t pretend you don’t know any 😂 twitter.com/kieransnyder/s…
This has been an interesting case in how poor decisions made worse by appalling comms can do permanent damage to a great brand. Now that the trust is broken, a positive statement, that would have been taken at face value last week, is picked to pieces. twitter.com/patrick_spence…
What possible good do they think could come from this decision. flip.it/DYqZG-
I don’t agree 100%. It’s pretty easy to make staff lose trust in you. twitter.com/stratandbiz/st…
RT @carolecadwalla Right. I have some GOOD NEWS! That legal case that Arron Banks is bringing against me? The one described as a "chilling" threat to journalism by press freedom organisations? He's dropped TWO of the cases against me. Hallebloodylujah. 🎉🎉🎉
Hi @tweethue just checking. You don’t have any plans to do a @Sonos on us and kill working bulbs by refusing to do software updates after 5 years. It’ll be bad enough having a quiet house, but if the lights go off as well🤦♂️ . @SonuS have set back the smart home industry 🤷♂️ pic.twitter.com/5gaxE1DuMn