Frequency Table and Crosstab Maker: Counts, Percentages and Chi-Square
Paste your raw data (one row per respondent, farmer or sample) and get frequency tables for every categorical variable, or pick two variables for a cross-tab with counts, row %, column % and total %. The chi-square test, Fisher’s exact test (2 × 2), Cramér’s V, a stacked bar chart and an APA-style table for Word are included. Results match R’s table() and chisq.test().
- PriceFree, no login or sign-up needed
- Your dataProcessed in your browser, never uploaded
- Works onPhone, tablet or computer, any modern browser
- Made byDr. Muhammad Aammar Tufail, Codanics
- Published17 November 2026
- Last updated16 November 2026
📚 How to cite this tool
This tool is free. If it helped your thesis, paper, report or assignment, please cite it. It keeps the tools free and helps other students find them.
Tufail, M. A. (2026). Frequency table and crosstab maker: counts, percentages and chi-square [Online tool]. Codanics. Retrieved 16 November 2026, from https://codanics.com/tools/crosstab-calculator/
In-text citation: (Tufail, 2026) · Narrative: Tufail (2026)
The access date is today’s date, filled in automatically. Author: Muhammad Aammar Tufail. Published 17 November 2026.
How to use the frequency table and crosstab maker
- Paste your raw data (one row per respondent or sample, variable names in the first row) or use Paste from Excel / Upload CSV / Excel. ID columns are detected and skipped.
- On the Cross-tab tab, choose the row and column variables and tick what each cell should show: counts, row %, column %, total % or expected counts. If each row is already a count, choose it as the weight column.
- Click Make cross-tab to get the table, chi-square test, Cramér’s V, the expected-count check and a stacked bar chart.
- On the Frequency tables tab, tick the variables you want for n, %, valid % and cumulative % tables. Copy any table into Word or download a CSV.
Row %, column % or total %?
Put the explanatory variable (education, treatment, region) in the rows and the outcome (adopted yes/no, infected, satisfied) in the columns, and show row percentages. Then each row answers “of the farmers with this level of education, what percentage adopted?” Column percentages answer the reverse question, and total percentages show each cell as a share of everyone.
Formulas
As a rough guide, Cramér’s V of about 0.1 is a small association, 0.3 medium and 0.5 large (for df* = 1; smaller thresholds apply to bigger tables). The chi-square test needs expected counts of at least 5 in most cells (no more than 20% below 5, none below 1).
Worked example
The example is a simulated survey of 120 farmers. Cross-tabulating education by adoption of improved seed gives adoption rates of 34% (no schooling), 47% (primary), 70% (secondary) and 92% (tertiary). The association is significant, χ²(3, N = 120) = 16.77, p < .001, Cramér’s V = .37, identical to chisq.test(table(Education, AdoptedImprovedSeed)) in R. Choose Gender as the row variable to see a 2 × 2 table with Yates’ correction and Fisher’s exact test.
How to report a cross-tab
“Adoption of improved seed increased with education, from 34% of farmers with no schooling to 92% of those with tertiary education, χ²(3, N = 120) = 16.77, p < .001, Cramér’s V = .37.” Put the full table with n (row %) in your results. For a table you already have as counts, use the chi-square calculator directly.
Frequently asked questions
How do I make a crosstab from raw survey data?
Paste or upload the data with one row per respondent and one column per question. Choose the two questions for rows and columns and click Make cross-tab. The tool counts the combinations for you and adds percentages and a chi-square test.
What is the difference between percent and valid percent?
Percent uses all cases including missing answers as the denominator. Valid percent leaves out missing answers, which is usually what you report. Cumulative percent adds up valid percentages from the first category down.
When should I use Fisher's exact test instead of chi-square?
Use Fisher’s exact test for 2 × 2 tables where any expected count is below 5. For larger sparse tables, combine categories or use an exact test.
Can I use data that are already counted?
Yes. Put one row per combination with a count column, and choose that column as the weight / count column.
Which variable goes in the rows?
Usually the explanatory or grouping variable goes in the rows and the outcome in the columns, with row percentages, so readers compare outcome rates between groups.
Is my data uploaded?
No. Everything is calculated in your browser; nothing is uploaded or stored.
Do I need to log in or create an account to use the frequency table and crosstab maker?
No. There is no login, no sign-up and no email required. Open the page and start using it straight away, for free, on any device.
How do I cite this tool in my thesis or paper?
Use the citation box on this page. In APA 7th edition: Tufail, M. A. (2026). Frequency table and crosstab maker: counts, percentages and chi-square [Online tool]. Codanics. Retrieved [date you used it], from https://codanics.com/tools/crosstab-calculator/. BibTeX, RIS (EndNote, Mendeley, Zotero), MLA, Harvard, Chicago and Vancouver formats are also available.
Free guides and courses from Codanics
More free tools
See all free Codanics tools → · Codanics on YouTube · WhatsApp channel