# Overview

A tab book consists of some or all of the variables in the dataset crossed with a multitable header.

To export a tab book to Excel:

Create a multitable as described in Multitables, the click **Export** in the upper-right and select **Export tab book** from the dropdown menu.

This opens the **Export to Excel** panel:

On the left side of the panel, you can select which variables will be included as rows in the tab book. By default all variables will be selected.

On the right, you can set what weight and filters will be used in the exported tab book:

**Filters** – Select any filters that should be applied to the entire tab book. Any selected filters will be selected, and you can add and remove filters as described in Filtering Data. If the filter you want to use does not exist, click “cancel” to close the export panel, create the new filter, and then return to the export panel.

**Weight** – Select a weight variable to compute a tab book with weighted data or select **unweighted**. If a weight was applied it will be selected by default. See Weighting for more information.

# Customizing the exported tab book

To customize how the resulting Excel file will be formatted, click **Settings…** at the bottom of the screen. This opens the customization screen. This same screen can also be opened from the main Export menu.

The following sections describe how to set the options.

## General

### Column Fields

When multiple fields are included for each table “cell” (e.g., **Counts** in addition to **Percentages**, **Population Size**, **Index**), they can be added to the same table row as the cell they apply to (**Wide (across)**) or to the same column (**Long (down)**).

### Decimal places

**Means, uncertainty, and tests** — Number of decimal places (up to three) to display for **Means, uncertainty, and tests**. Note that XLSX tables contain the complete double-precision proportion and decimal formatting and rounding are applied as a cell format.

### Organization

**Show empty rows/columns** — Show or hide rows and columns that are valid categories, but contain no data in a given table (this could be the result of, e.g., a filter being applied to the export).

**Table of Contents** — Optionally include a table of contents worksheet as the first sheet or the top of a single-sheet export. It contains the row variable titles and links to the appropriate worksheet (or position in the single sheet if **All variables on one sheet** was selected). By default, each variable in the tab book is written to its own worksheet in the exported Excel file. Select **All variables on one sheet** to write the entire tab book on a single worksheet. Alternatively, select **All variables** in one table to write the entire tab book to a single table.

### Test statistics

The exported data can include any of the following test statistics: **Standardized residual (Z-score)**, **P-value** (the probability that the value differs significantly from the mean), or **Pairwise column tests** (performing pairwise tests between columns in each row – see Hypothesis testing in Crunch for more information).

### Cell coloring

**Color by P-values** — If selected, cells will be shaded in the exported table based on the P-value associated with each cell’s Z-score (a display equivalent to turning on hypothesis testing in the application).

### Uncertainty

**Margin of error** – (e.g., ±3.1%) — This displays the margin of error and is available for percentages and population estimates.

**Standard deviation** — Standard deviation of estimates of scale values.

**Standard error** — Standard error of the estimates of scale values.

## Crosstabs

### Percentages

Percentages exported tables can be configured to sum to 100% across each **Column**, **Row**, or across the entire table (**Total**).

**Index** — Percentage of each cell relative to the row marginal percentage (which is treated as “100”). For example, if the marginal for the row is 30% and a given cell’s column percentage is 60%, the “index” is 200.

**Decimal places** — Number of decimal places shown for **Percentages** (the default, 0, is usually most appropriate). Note that XLSX tables contain the complete double-precision proportion and decimal formatting and rounding are applied as a cell format.

### Counts

You can choose to display **Weighted** or **Unweighted** counts (or both). See Weighting for more information on weights. You can also choose to display **Population** counts.

### Scales

**Mean** — The scale mean of optional numeric values associated with categories. Numeric values may be null and need not be unique.

**Median** — The scale median of optional numeric values associated with categories.

### Bases

For base values, you can choose to display **Unweighted** or **Weighted**. As a rule, contingency tables should contain the base in the direction of percentaging to aid interpretation.

You can also choose to display the base values **Above table** (row), **Below table** (row), or **Per cell**.

## Completing and downloading the export

Click **Export** to request the tab book. For large datasets, exporting can take some time. Once the Excel workbook is ready, a **Download** button will appear.

Click **Download** to download the Excel file.