Skip to Main Content

Systematic Searching Support

Managing Records

Typical yield for reviews with a comprehensive search methodology are > 1000 records,  It is important to have a strategy for managing citations at the beginning of the project.  Programs listed on this page may be useful for storing, organizing, tracking, and formatting records.

Citation Management Programs

EndNote Style for Exporting Records to Excel

Follow these steps to export your records: 

  1. Select references->right click & select Copy Formatted
  2. Open Excel>Paste

This style is set up to export the following fields into Excel columns as listed below

A –Authors   B– Year   C– Article Title 

D– Record #   E– Journal    F– Volume      

G– Issue   H- Pages   I- Abstract

If more information is needed on customizing a style, contact your subject librarian.

De-Duplication of Records

Using software to identify duplicate records should be done carefully. The following article evaluates 5 options for removing duplicate records, detailing the number of false positive and false negative results: Kwon Y, Lemieux M, McTavish J, Wathen N. Identifying and removing duplicate records from systematic review searches. Journal of the Medical Library Association: JMLA. 2015;103(4):184-8.

Relying on the Find Duplicates function in EndNote to remove duplication is often not satisfactory for systematic reviews. The following article describes in detail how to change settings in EndNote and remove duplicate records efficiently and effectively: Bramer WM, Giustini D, de Jonge GB, Holland L, Bekhuis T. De-duplication of database search results for systematic reviews in EndNote. Journal of the Medical Library Association: JMLA. 2016;104(3):240-3.