Add Maple
← All help articles

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.

1
Data tables and Excel crosstabs

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