Working …
This value you provided is not a number. Please try again.
This value you provided is not an integer. Please try again.
The value entered is not a valid Vanderbilt Medical Record Number (i.e. 4- to 9-digit number, excluding leading zeros). Please try again.
The value you provided must be within the suggested range
The value you provided is outside the suggested range
This value is admissible, but you may wish to double check it.
The value entered must be a time value in the following format HH:MM within the range 00:00-23:59 (e.g., 04:32 or 23:19).
This field must be a 5 or 9 digit U.S. ZIP Code (like 94043). Please re-enter it now.
This field must be a 10 digit U.S. phone number (like 415 555 1212). Please re-enter it now.
This field must be a valid email address (like joe@user.com). Please re-enter it now.
The value you provided could not be validated because it does not follow the expected format. Please try again.
Required format:

Notifications

System Notifications
General Notifications

Conversations

Create new conversation

ANC ObservationPID 28
Data Exports, Reports, and Stats
VIDEO: How to use Data Exports, Reports, and Stats

Below are some additional export options that are available for your project. Instructions for each type of export are provided. You may click the corresponding icon on the right to download the file for each.

Export entire project as REDCap XML file (containing metadata & data)
The entire project (all records, events, arms, instruments, fields, and project attributes) can be downloaded as a single XML file, which is in CDISC ODM format (ODM version 1.3.1). This XML file can be used to create a clone of the project (including its data, optionally) on this REDCap server or on another REDCap server (it can be uploaded on the Create New Project page). Because it is in CDISC ODM format, it can also be used to import the project into another ODM-compatible system.
PDF of data collection instruments containing saved data (all records)
The data for all records in this project may be downloaded in a single PDF file. This file contains the actual page format as you would see it on the data entry page or survey and includes all data for all records for all data collection instruments. Click the icon to the right to begin downloading the file. Also, you may optionally click the Compact option to download a PDF that excludes fields that have no data saved and excludes unselected multiple choice options. (Note: Section headers and descriptive fields will still be included.)

Note: If your project has a large amount of fields/questions or records/responses, the resulting PDF file may be very large both in file size and in page length. Please be patient if the file takes time to download.
NOTICE: When downloading a PDF file containing data for all records, a copy of that downloaded PDF will be archived and stored in the File Repository.

Tableau Export: Extract all records into Tableau via the REDCap API
This feature enables Tableau (v10.0+) users to connect Tableau to a REDCap project using an API token. Project data can be exported on demand and be available for use within Tableau to produce summaries and visualizations. Click the button to the right and follow the instructions to export your data into Tableau.
NOTICE: It is required to have an API token generated for the project in order to use this feature.
Why Tableau?
Tableau is a powerful and fastest growing data visualization tool used in the Business Intelligence Industry. It helps in simplifying raw data in a very easily understandable format. Tableau helps create the data that can be understood by professionals at any level in an organization.
Tableau is a visual analytics engine that makes it easier to create interactive visual analytics in the form of dashboards. These dashboards make it easier for non-technical analysts and end users to convert data into understandable, interactive graphics.
A REDCap user with an API token can have data from their REDCap project downloaded to their Tableau Desktop instance (v10.0+). Please follow the below steps to download data via the Tableau Web Data Connector.
Instructions
  1. In Tableau 10.0+, go to Connect -> To a Server -> More and find "Web Data Connector"
  2. Copy the URL below as the "web data connector URL" in the dialog, and press Enter:
  3. In Tableau, enter your project API token into the text box and select/enter other options, as desired.
    Options available for customizing the extract are:
    • Raw data or labels
    • Include Data Access Group yes/no
    • Subset of fields: specify a comma or space-separated list export field names
    • Subset of records: specify a REDCap filter logic expression
  4. Click "Submit", and your project data will be downloaded into Tableau.
    (The web data connector will be executed and create a Tableau Data Source in your Tableau workbook.)
  5. Click "Update Now" to extract your project data into the Data Source.
Select your export settings, which includes the export format (Excel/CSV, SAS, SPSS, R, Stata) and if you wish to perform de-identification on the data set.
Export Entire Project (metadata & data)
REDCap Project (XML)

The entire project (all records, instruments, fields, and project attributes) can be downloaded as a single XML file (CDISC ODM format).

This XML file can be used to create a clone of the project (including its data, optionally) on this REDCap server or on another REDCap server (it can be uploaded on the Create New Project page). Because it is in CDISC ODM format, it can also be used to import the project into another ODM-compatible system.
Choose export format
CSV / Microsoft Excel (raw data)
CSV / Microsoft Excel (labels)
SPSS Statistical Software
SAS Statistical Software
R Statistical Software
Stata Statistical Software
CDISC ODM (XML)
STEP 2: Archive the export files in File Repository?
Yes, store a back-up copy
No, do not store a back-up copy
De-identification options(optional)
The options below allow you to limit the amount of sensitive information that you are exporting out of the project. Check all that apply.
Known Identifiers:
Remove All Identifier Fields (tagged in Data Dictionary)
Hash the Record ID field (converts record name to an unrecognizable value)
Free-form text:
Remove unvalidated Text fields (i.e. Text fields other than dates, numbers, etc.)
Remove Notes/Essay box fields
Date and datetime fields:
Remove all date and datetime fields
— OR —
Shift all dates by value between 0 and 364 days
(shifted amount determined by algorithm for each record) What is date shifting?
Deselect all options
Apply live filters?
One or more live filters have been selected on this report. Do you wish to apply the live filters to the data export, thus producing the same data set that you currently see displayed on the report?
Apply live filters selected on this report
Advanced data formatting options
Export blank values for gray Form Status?
All Form Status fields with a gray status icon can be exported either as a blank value or as "0" (Incomplete). Hint: Blank values are recommended if the data will be imported back into REDCap, in which this preserves the gray status icons for all the imported records.
Set CSV delimiter character
Set the delimiter used to separate values in the CSV data file (only valid for CSV Raw Data and CSV Labels export formats):
Force all numbers into a specified decimal format?
You may choose to force all data values containing a decimal to have a specified decimal character (comma or period/full stop). This will be applied to all calculations and number-validated text values in the export file.
NOTE: Your data formatting selections above will be remembered in the future and will be pre-selected upon your next export.
REDCap 15.1.0 - © 2025 Vanderbilt University - Cookie policy