In order to perform more custom analyses or build your own reports, you can export all the research outputs (with associated metadata), their mention counts, and their Dimensions citation counts to a spreadsheet in CSV format.

 

For Altmetric Explorer for Institutions instances with a data implementation, you can also view verified authors and departments from your institution in the exported spreadsheet.

 

Once you have created a search query for research outputs, go to the Research Outputs tab of the Altmetric Explorer, hover over the "Export this tab" button and select "Download results as a CSV". The file download will begin immediately and you will be able to view all of the research outputs and their associated metadata and mention counts in a CSV spreadsheet.

 

 

Opening your CSV spreadsheet file in Microsoft Excel

 

In some countries, Microsoft Excel may default to using a different separator (e.g., a semi-colon) to parse the CSV spreadsheet. However, in order to correctly view the files exported from Altmetric Explorer, you will need to ensure that you are using commas as separators. 

 

Additionally, Excel may truncate numeric IDs (such as the X/Twitter User ID in the 'Outlet or Mention Author' column and the X Post/Tweet ID in the 'External Mention ID' column). This can result in data loss, as the numeric IDs will not be accurate.

 

To ensure that your CSV spreadsheet file can be correctly opened in Microsoft Excel, please follow these steps:

  1. Open Microsoft Excel and create a new spreadsheet.

  2. Use the Import data feature, which allows you to choose the character used to split the columns and edit some other import settings.

  3. Make sure that you select 'comma' as the separator.

  4. Also ensure that the 'Outlet or Mention Author' and 'External Mention ID' columns are formatted as text, rather than as numbers, to ensure that no data are lost.