To export the data from a crosstab, go to the Exports tab.
You will see a list of any prior exports with their status, creation date, and download link.
Use the Preview Export button to see how your export will look. The preview does not contain any figures.
Use Close Preview to exit the modal and return to the Exports tab. If you're happy with the preview, click the Export button.
The EXPORT CROSSTAB modal will open. Enter a name for the export, select the options you want, and then click Submit.
The system will begin creating your file. You will see a green success message.
Your export will be listed. It will probably have a status of Processing as mine does above.
Use the link in the success message to refresh the page. When the export has been completed, the status will change to Ready to Download. Click the Download link.
The file will be named export_name time date.xlsx. I gave my export the name Gender/Color Export Test. The file name is Gender_Color Export Test 13_52_48 11-03-2025.xlsx. (The time is in coordinated universal time, or UTC.)
The exported file will contain several tabs.
The first tab, Settings, shows basic information about the crosstab, including:
- CivicScience
- InsightStore Cross Tabulation
- Crosstab: your crosstab's name
- Date Report Generated: time and date the crosstab was generated
- User: username of the user who generated the crosstab
- Link: the URL for the crosstab
- Comparisons
- (blank space)
- Rows
- Question ID (QID): text of your first-row question
- Filter Segment: any segment you used
- Answer Grouping: any answer grouping you used
- (blank space)
- Columns
- Question ID (QID): text of your first column question
- Filter Segment: any segment you used
- Filter Network: any network you designated
- Filter Weighting Scheme: the weighting scheme you chose
- Date Range: the date range you selected
- Answer Grouping: any answer grouping you applied
- (blank space)
- Statistics
- (Text of row question)(Row) x (Text of column question) (Col)
- Number of responses
- Significance:
- questions in the columns, with filter segment and date range
- number of responses
- significance (Χ2 with df)=(significance figure)
- p-value
- strength of association (T-coefficient)
The second spreadsheet tab, All Results, shows the same information found on the Results tab.
The third spreadsheet tab, Responses, shows the number of responses for each category.
The fourth spreadsheet tab, Row %, shows the row percentage values and their totals.
The fifth spreadsheet tab, Column %, shows the column percentage values and their totals.
The sixth spreadsheet tab, % From Expected, shows the differences between the expected and actual results.
