Protobi

← All help posts

View post

## Create a stylized crosstab table

### Create the online table view

[Add a new tab](/how-to/add-a-new-tab) to your project. You can give it any name. In this example, the tab is “supertable\_questions”.

In the [JSON editor](/intermediate-editor/edit-json) set the chartType to "SuperTable":

After setting chartType:

[Drag the questions](/how-to/how-to-move-questions-elements) you want to include in the table into the grey box labeled "Add stubs...". Drag the banners you want to include to the blue header labeled "Add banners...".

The result is a neatly stylized table:

-   Questions and values are on the left.
-   The crosstab banners show as columns to the right.
-   Press the red "x" on banners and stubs to remove them. 
-   To reorder the stubs, drag + drop.

Export SuperTables to Excel

[Add another tab](/how-to/add-a-new-tab) to the project. You can give it any name-- in this example, the tab is “supertables”.

Drag questions into the new export tab. Select “[mirror](/editaccess/copy)” when the [move dialog](/how-to/how-to-move-questions-elements) appears. This will add the question under Export, but also keep it in its original location.

In the [JSON editor](/intermediate-editor/edit-json) set the chartType to "SuperTables":

The result is an element with "Generate" export button:

-   Specify the file name for your export in the text box.
-   There's a bar to show export progress.
-   The questions included are listed out.

[Add the crosstab banners](/view-access/crosstabs) you want to export with the table. Press the generate button, the progress bar underneath will alert you when the Excel is ready to download.

### Export options

Open the “[More chart options](/edit-access/more-chart-properties)” dialog. The quickest way is to [select the export element](/how-to/select-elements-to-export,-group,-etc), then press SHIFT E + P on your keyboard.

**Continue stats superscript letters**

-   Select **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.

###

### 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\]](/view-access/na-blank-missing-values) state of the [export element](http://help.protobi.com/99791-new-and-updated-articles/create-and-export-stylized-crosstab-tables#1.%20Create%20a%20new%20tab-7). Missing values will be hidden if the export element has showMissing set to "No" in [edit properties](/edit-access/element-properties).

The export also reflects the state of the [global filters](/view-access/global-filters). If you save the project with a “complete” global filter, the export will show completes only.

Publishing

Date

Status

Slug edit

Content

Thumbnail

Categories Manage

Tools

AI Database

Publishing

Content

Tools

Danger zone