UPCOMING WEBINAR: 10 Market Research Predictions Over the Next 4 Years Requirements
A document with a data set.
Method
1. Go to 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 > 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 Data > Show Advanced Options > R Code > Edit Code, and delete ProcessQVariables from line 5, then press Calculate.
4. OPTIONAL: If you have more than a million table cells, you will receive the following error message:
If you still wish to display your table, go to Data > R Code > Edit 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. Go to Share > Export Report > Excel.
7. Select Export Selected from the Choose which pages/outputs to export dropdown.
8. Click Export.