Export Crosstabs (Excel)
Create a formatted Excel workbook of crosstabs so you can share results or continue analysis outside AddMaple. The export respects your current filters and uses your project brand color.
Open the tool
- Click the More menu.
- Choose Export Crosstabs (Excel).
This opens a panel where you select question columns and banner columns, then download a ready-to-use XLSX file.
Step 1 — Select Questions
Choose the columns to use as questions (rows). We recommend categorical questions:
- Single choice categories
- Opinion scales (Likert)
AddMaple filters the list to exclude free-text, id/unique, and time-only columns.
Step 2 — Select Banners
Choose the columns to use as banners (columns across the top). Banners can be:
- Categorical and Multi‑tag
- Numeric (auto‑binned)
- Date (auto‑binned)
Tip: Pick banners you commonly use for cuts (e.g., segment, market, wave, device).
Download the workbook
Click Download Excel. The export includes:
- One or more worksheets with crosstabs for each selected question
- Counts and percentages by banner category
- Clean formatting and your project's primary brand color
Notes:
- Exports respect any filters currently applied. Clear filters to export the full dataset.
- Selecting multiple questions creates multiple worksheets in the same workbook.
Tips
- Start with 1–2 banners to keep tables readable, then expand.
- If a banner is numeric or a date, AddMaple auto‑bins it into useful ranges.
- Ensure question columns are categorical or scale‑based for clearer tables.
Availability: Export Crosstabs is limited to certain plans.