Create and export stylized crosstab tables

Updated at April 13th, 2022

Create a stylized crosstab table

1. Create a new tab with the desired questions

Add a new tab to your project. You can give it any name. In this example, the tab is “supertable_questions” and the displayKey is "Online supertable view".  

Drag the questions you want to include in the table into the new tab. Choose the mirror option in the move dialog.

The stylized table or “SuperTable”, only works with single elements like Q1 and compact groups like Q2. SuperTable doesn’t work with groups of expanded elements or a group of groups.

2. Add crosstab banners to the new tab

You can add up to two crosstab banners onto the tab by dragging + dropping from the element tree.

To add more than two banners, set col from the “Edit properties” dialog.

3. Set chart type to SuperTable

Set the chartType attribute to SuperTable from the “Edit JSON” dialog.

4. The result is a neatly stylized table

  • Questions and value formats are on the left.
  • The crosstab banners show as columns to the right.

 

You can choose to hide the overall column from the “Chart type” dialog.

Export SuperTables to Excel

1. Create a new tab

Add another tab to the project. You can give it any name. In this example, the tab is “Export”.  

Drag the SuperTable group you created earlier into the new export tab.

Select “mirror” when the move dialog appears. This will add the SuperTable under Export, but also keep it in it’s original location so you can view the SuperTable online.

2. Add crosstab banners for export

Add the crosstab banners you want to export. The crosstabs on the export element are the banners that will be included in Excel. The crosstabs on the stylized SuperTable does not matter for export.

3. Set chart type to SuperTables

On the export element, set the chartType attribute to SuperTables plural. Use the “Edit JSON” dialog.

4. Generate exports to Excel

After you set the export element to the SuperTables chart type, it will look like this.

There’s a text box where you can specify the file name for your export.

Press the “generate” button, the progress bar underneath will alert you when the Excel is ready to download.

5. Set export options

Open the “More chart options” dialog. The quickest way is to select the export element, then press SHIFT E + P on your keyboard.

Continue stats superscript letters 

  • Selected continueSuperscripts if you don't want the first column of each banner to restart superscript letters at "a".

Show N size row under each question

  • Deselect the hidRedundantBasis if you want to show an N size row under each question.
  • Keep the option selected if you want to hide the N size row at each question when it is identical to the overall N size row of the export.

Hide/show Significance tests

  • Select showSignficance to see pairwise stats markers in the export.


6. Resulting Excel export

The export will be a stylized Excel that looks similar to the look and feel of the online SuperTable.

The export reflects the [NA] state of the export element. Missing values will be hidden if the export element has showMissing set to "No" in edit properties

The export also reflects the state of the global filters. If you save the project with a “complete” global filter, the export will show completes only.

Download the instructions in PowerPoint

create_export_supertables.pptx

Was this article helpful?