How do I export the data from REDCap?

To export data from REDCap, click on the “Data Exports, Reports, and Stats” link on the Applications panel on your project page. This allows you to easily view reports of your data, inspect plots and descriptive statistics of your data, as well as export your data to Microsoft Excel, SAS, Stata, R, or SPSS for analysis.

Only users identified within a project as the Information Guardian can export full deanoymised data sets from REDCap The Information Guardian is required to complete an investigator agreement on the project when that project is created within REDCap If the person listed as the Information Guardian leaves the research team, the research group are required to contact the REDCap admin and nominate a new member of staff

How can I export my data to SPSS?

Select Data Export in the applications menu of your REDCap project.
Select which fields/forms you wish to export and click Submit.
Next to the SPSS option there are three files.
Download ALL THREE to your desktop.
From your desktop, double-click the “spss_pathway_mapper.bat”.
Follow the instructions and double-click (only once) on the downloaded “.sps” file on your desktop.
The file should look like: “EXPORT_PROJECT_USER_DATE.SPS”.
Wait for SPSS to open. A syntax file will appear in SPSS.
At the top menu, click on run and then “run all”.
After the syntax has completed running, close the syntax file and a new (untitled) dataset will appear with the data you downloaded.
Save it.