How to Export Specific Raw Data Variables to Excel

Requirements

A document with a data set.

Please note these steps require a Displayr license.

Method

1. Go to the Table > Raw Data > Variable(s) from the toolbar.

2. Select the specific variables to export from your Data Sources tree and drag them over to the output's Variables box on your Page, or select them from the Data > Raw Data > Variables field within the object inspector.

3. OPTIONAL: Nominal variables that have merged categories and aggregated Date/Time variables will display as such by default. To change this to only show the original categories and/or responses, go to General > R CODE, delete ProcessQVariables from line 5, then press Yes > Calculate.

4. OPTIONAL: If you have more than a million table cells, you will receive the below error message:

If you still wish to display your table, go to Data > R CODE, delete the lines shown below (lines 8 and 9) and press Calculate:

if (nrow(rawdata) * ncol(rawdata) > 1000000)
stop("Your table contains more than 1,000,000 cells. To get around this limitation, edit the R Code, or, create tables using RAW DATA.")

5. OPTIONAL: Tick Data > Variable names to replace variable set names with their individual variable names.

6. Select the share icon  > Export > Export Pages > Excel to export the table.

Next

How to Export Data Sets to SPSS or CSV Format from Displayr