Export references to Excel

If you want to export your references from RefWorks to Excel, take the following steps:

  1. In RefWorks, select the references you want to export.
  2. Click Share

  3. Click Export references, select Tab Delimited (.tsv) and click on Export

    Your references will now be downloaded to a .tsv file.
  4. Open a blank worksheet in Excel.
  5. Go to the Data tab and select Get Data > From File > From Text File/CSV

  6. From your Downloads folder, select the export.tsv file and click Import.
    Note: If you don't immediately see the file in your file list, you need to change the file type from Text files to All files

    A pop-up screen will now appear.
  7. Click Load.

  8. Your references are now loaded in your Excel sheet.