Online Tool Store
Cross Tab Builder
Build a two-way frequency (cross-tab) table from CSV data, counting combinations of two categorical columns, with row totals and percentages.
🔒 This tool runs entirely in your browser. Your files are never uploaded to a server.
How the cross tab builder works
- Paste CSV data with at least two categorical columns.
- Choose which column becomes the row variable and which becomes the column variable.
- The tool counts how many rows fall into each row/column combination, with row and column totals — optionally shown as row percentages instead of raw counts.
FAQ
What's the difference between this and the Pivot Table Maker?
This tool specifically counts how often combinations of two categorical values occur together — a classic "two-way frequency table." The Pivot Table Maker is more general: it can sum or average a separate numeric column instead of just counting occurrences.
What do row percentages show?
With that option checked, each cell shows what percentage of that row's total it represents, rather than the raw count — useful for comparing proportions across rows that have very different total counts.
What is a cross-tab used for?
Comparing two categorical variables to see if there's a relationship between them — like whether a preference differs by group, or whether a survey response pattern differs by demographic.
Is my data sent anywhere?
No. The table is built entirely in your browser as you type or change settings — nothing is sent to Online Tool Store or stored.
How we compare
| Feature | Online Tool Store | Excel COUNTIFS + PivotTable | Statistical software (SPSS, R) |
|---|---|---|---|
| No spreadsheet or software needed | ✓ | Requires Excel | Requires specialized software |
| Row percentage toggle built in | ✓ | Manual formula setup | ✓ |
| Instant, no learning curve | ✓ | Formula knowledge needed | Steep learning curve |
For a quick two-way frequency table from pasted CSV data without formulas or specialized software, the Online Tool Store Cross Tab Builder gives you an instant answer.