Skip to main content
print page banner

The University of Iowa Libraries

Hardin Library for the Health Sciences

Systematic Reviews: Managing Records

This guide provides resources for finding and writing systematic reviews.

Managing Records

Typical yield for systematic searches are > 1000 records. Therefore, 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.