---
title: Data tables and Excel crosstabs
category: Sharing and Exporting
slug: data-tables
blurb: Use interactive pivot tables in AddMaple, then export Excel crosstabs or formatted data-table workbooks with banners, layouts, and brand colors.
order: 2
---

# Data tables and Excel crosstabs

This guide covers **interactive tables in AddMaple** and **Excel exports**: the standard **Export Crosstabs (Excel)** flow plus **formatted data-table** workbooks (layouts, highlight colors, table of contents). Exports respect your filters and use your project styling where applicable.

![Data tables and Excel crosstabs](https://player.mux.com/y02igDPVKdpM4XZ9E98IfQPLa500o2ypeP02iN4m8kUxY00)

---

## Interactive tables in AddMaple

1. Open a question (for example, internet/email use over time in a tracker).
2. Switch the view to a **pivot table** and add **banner** columns (such as **country**).
3. Turn on **significance testing** when you want to highlight reliable differences.
4. Toggle **counts** vs **percentages**, adjust the **percentage base** where needed, and **hover** cells for more detail.

These tables work **out of the box**—no export required for internal review or live exploration.

---

## Export Crosstabs (Excel)

Use this when you need a **clean XLSX** of crosstabs (counts and percentages by banner).

### Open the tool

1. Click the **More** menu.
2. Choose **Export Crosstabs (Excel)**.

A panel opens to select question columns and banner columns, then download the file.

### Step 1 — Select questions

Choose columns to use as **questions** (rows). Best suited to:

- Single-choice categories  
- Opinion scales (Likert)

AddMaple hides free-text, id/unique, and time-only columns from the list.

### Step 2 — Select banners

Choose columns to use as **banners** (columns across the top). Banners can be:

- Categorical and multi-tag  
- Numeric (auto-binned)  
- Date (auto-binned)

Tip: Use banners you often cut by (segment, market, wave, device, etc.).

### Download

Click **Download Excel**. The workbook includes:

- One or more worksheets with crosstabs per selected question  
- Counts and percentages by banner category  
- Formatting and your project’s **primary brand color**

**Notes**

- The export respects **filters** currently applied. Clear filters to export the full dataset.  
- Multiple questions produce **multiple sheets** in one workbook.

---

## Data tables export (formatted workbooks)

For a **client-ready** Excel layout with more control over structure and visuals, use the **data table** export from **More** (wording may appear as data table / Excel in the product).

1. **Select questions** (rows)—for example a set of key tracker items.  
2. **Select banners**—for example country, age group, gender.  
3. Choose **counts**, **percentages**, or **both**.  
4. Pick a **layout**:
   - **One sheet per banner** — each banner is its own worksheet; questions are grouped inside.  
   - **One sheet per question** — each question is its own sheet; banners appear as columns on that sheet.  
5. Optional: adjust **highlight colors** (e.g. positive vs negative significance shading) and add a **table of contents**.  
6. **Download** and open in Excel.

**Tips**

- Start with a small banner set; add more once the layout is clear.  
- **Per-question sheets** suit deep dives on one item; **per-banner sheets** suit scanning one break at a time.  
- If a banner is numeric or a date, AddMaple **auto-bins** it into useful ranges (same idea as crosstab export).

---

## Availability

**Export Crosstabs (Excel)** and advanced data-table exports may be limited to certain plans.

---

## Team customizations

If you need **organization-specific formatting or defaults** for Excel tables, contact your AddMaple team—**customizations can be set at the team level** where available.

---

## See also

- [Significance testing](../stats/significance-testing)  
- [Add pivot (sentence builder)](../sentence-builder/addpivot)  
- [Percentage types](../pivot-chart-and-table/percentage-types)  
- [Download](download)