Online Tool Store
Cross Tab Builder
Build a two-way frequency (cross-tab) table from comma-, tab-, or semicolon-delimited data with row/column/total percentages, chi-square test, Cramér's V, and CSV export.
This works right here on your device — nothing gets sent out.
How the cross tab builder works
- Paste CSV data with at least two categorical columns — comma, tab, and semicolon-delimited data are all detected automatically, so data copied from Excel or Google Sheets works without reformatting.
- 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 — shown as raw counts, or switch to row, column, or total percentages.
- Optionally turn on the chi-square test to see whether the two variables are statistically associated, with the chi-square statistic, degrees of freedom, p-value, and Cramér's V effect size.
- Copy the table as CSV or download it as a file — both always export 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's the difference between row, column, and total percentages?
Row % shows what share of each row's total a cell represents, Column % shows what share of each column's total, and Total % shows what share of the entire table (the grand total) a cell represents. Row % is most useful for comparing proportions across rows with different totals; Column % is the mirror image for comparing across columns.
What does the chi-square test tell me?
It tests whether the two categorical variables are independent of each other. A p-value below 0.05 suggests the row and column variables are associated rather than independent — for example, that a preference really does differ by group rather than the pattern being due to chance. It needs enough data for reliable results: if any expected cell count is below 5, the tool flags the result as potentially unreliable.
What is Cramér's V and why is it shown alongside the chi-square result?
Cramér's V measures the strength of the association between the two variables, on a scale from 0 (no association) to 1 (perfect association) — unlike the chi-square p-value, which only tells you whether an association is statistically significant, not how strong it is. A large sample can produce a significant p-value even for a very weak association, so Cramér's V is the better number to look at for practical importance.
Does the tool support tab- or semicolon-delimited data?
Yes. The delimiter is detected automatically from the header row, so data copied from Excel or Google Sheets (tab-delimited) or exported with a semicolon delimiter (common in some regional Excel locales) pastes in and parses correctly without any manual reformatting.
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.
Can I export the cross-tab table?
Yes. Use "Copy table as CSV" to copy it to your clipboard, or "Download CSV" to save it as a file — both always export the raw counts, regardless of which percentage view you have selected on screen.
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, column, and total percentage views | ✓ | Manual formula setup per view | ✓ |
| Chi-square test of independence built in | ✓ | Needs a separate add-in or formula | ✓ |
| Cramér's V effect size alongside chi-square | ✓ | Manual formula setup | Available, but needs a separate command |
| Auto-detects comma, tab, or semicolon delimiters | ✓ | N/A — already tabular | Usually requires specifying the delimiter |
| One-click CSV copy/download of the result | ✓ | Already in a workbook | Requires export step |
| 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.