Showing results for 
Search instead for 
Do you mean 
Reply
New User
Posts: 2
Registered: ‎03-01-2018
0

How to search my EndNote library for titles contained in an excel/CSV of exported titles

Hi everyone,

 

I exported a list of titles (tab-delimited) into an excel spreadsheet which I then used to select relevant titles for my literature review.

 

Is there an easy way of searching my existing EndNote library (from which the titles were sourced from) to select the titles that I chose in the exported CSV? The alternative would require me to individually search 600-700 papers within my library.

 

The reason that I need to return back to my EndNote library is for: 1) ease of use, and 2) I only exported titles, I didn't export the other relevant information.

 

Thanks for your help!

Highlighted
Mentor
Posts: 7,772
Registered: ‎04-10-2008
0

Re: How to search my EndNote library for titles contained in an excel/CSV of exported titles

[ Edited ]

Can you create a  new library with those titles?  If so, then you could import your library with duplicates settings as "title" only (in preferences/duplicates) with discard duplicates ON into the title only library and to discard them into a new library, which would essentially be those that were the titles you started with?   

 

So from the titles library -- file>import (on a PC)  -- import endnote library, with setting for duplicates as in attached image, and then find your original library and import.  This time you want to open and save the duplicates as a new subset.  

 

Alternatively (and this will retain any endnote record numbers of your original library) -

 

Make a copy of your original library and create a new library of the titles only set. After ensuring your duplicate settings in preferences only look at the fields in your CVS imported library -- this time,  import without discarding duplicates, the titles only into the library copy (Doing this on a copy is so, if things go pear shaped, you can go back to the original library).  Create a group -- like Literature review.  Now run the duplicate search, close it.  You should be left with the new set highlighted and the original set not highlighted.  from references hide those highlighted.  This should leave you with your original set that matched your titles selected.  select them all and drag them into the group you created.  Do the duplicate search again, and close and now delete the selected set (which should be titles only.)  and you now have the group of titles you want to use in your lit review in a group, still in the context of your whole library. 

 

But next time, why not select them and move them to a group, in the first place rather than export and decide?   

(long time Endnote user)