Cochrane Library exports records in a format that neither Zotero nor EPPI-Reviewer recognizes. While there are easier ways to handle small numbers of records (see the comments below), for large batches it is more efficient to convert them all simultaneously to the commonly accepted RIS format. One solution is to paste your exported references into a custom-built Excel file. If you choose this route, please read my comment, which explains an easy way to improve the result and lists the fields that Zotero still won’t recognize. But you might consider following another procedure that yields more fields that reference-management software can read. Both options have several steps.
- Export your records from the Cochrane Library site.
- Open the file (by default, ‘citation-export.txt’) as a plain text file using Microsoft Word. Leave Windows (Default) as the encoding. Just click on OK.
- Press Ctrl-h to open the Replace dialog box.
- On the top line (Find what:), type abstract^p
- On the bottom line (Replace with:), type abstract^pER:
- Please note: there is a space after ‘ER:’, so it’s ‘abstract^pER: ‘
- Click on Replace All.
- Save the file as a ‘Plain Text’ file. That is, click on Yes.
- Go to the RIS Export website.
- Under Step 1, browse to find your file of references. Then click on Upload.
- For Step 2, choose ID:. from the first drop-down box. Then choose ER:. from the second drop-down box.
- You could choose PT:. from the third box and SO:. from the fourth, but this is unnecessary.
- As soon as you see a table appear with ‘Cochrane, Tagged 5’ in the first two boxes, click on Select.
- For Step 3, click on Export. The result, ‘export.txt’, is now in an RIS format that other programs can read.