Export formats: XML, Excel and Parquet
You can export your results in mainly two formats:
Articles (Endnote XML)
This is a bibliographic data format that captures information like the title, abstract, author names, DOI and other bibliographic metadata that you have imported into your project. You can use this filetype with citation management software like Endnote and Zotero.
Articles and Answers (Excel)
This option exports a multi-tabbed Excel file containing detailed information about user and article-level label responses. Specifically, the Excel tabs contain:
- Articles: Unique article IDs assigned by Sysrev, a URL to the article in your Sysrev project and some basic information about the article (e.g., title, publication year, authors)
- User Answers: Each row contains all of the label responses for each article for each reviewer
- Auto Answers: Contains all label answers from the auto labeller (if used)
- Article Answers: Each row contains a pipe-delimited list of reviewers and their label answers for each article
- Annotations: Article annotations (if used)
Parquet
A Parquet file is a columnar storage file format commonly used in big data processing and analytics. While not human-readable, it is readily processed by computers and widely supported by data processing tools. The Parquet export will contain all of the label and article data contained in your project. For a brief overview of Parquet and how to convert it to csv using Python or R, check out this article in Medium.