Data preparation

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().

✅ No login needed100% freeRuns in your browserYour data stays on your device
Frequency Table and Crosstab Maker✅ Free · no login📚 Cite this tool
Your data never leaves your PC. Your data is analysed on your own computer or phone, even when you upload a CSV or Excel file. Nothing is uploaded, stored or seen by Codanics, and no login is needed.
  • 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.

Citation · APA 7th edition

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.

🚀 Follow Codanics channel on WhatsApp for more updatesNew free tools, scholarships, PhD positions and research tips, straight to your phone. Free lessons on YouTube too.

How to use the frequency table and crosstab maker

  1. 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.
  2. 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.
  3. Click Make cross-tab to get the table, chi-square test, Cramér’s V, the expected-count check and a stacked bar chart.
  4. 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

Expected count Eᵢⱼ = (row total × column total) / N Chi-square χ² = Σ (Oᵢⱼ − Eᵢⱼ)² / Eᵢⱼ, df = (r − 1)(c − 1) Yates (2 × 2) χ² = N (|ad − bc| − N/2)² / [(a + b)(c + d)(a + c)(b + d)] Cramér’s V V = √( χ² / (N · min(r − 1, c − 1)) ) Fisher (2 × 2) sum of hypergeometric probabilities ≤ that of the observed table

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.

Learn the statistics behind these numbers. Codanics has free statistics, R and Python lessons on YouTube and full courses for researchers.

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

Made by Dr. Muhammad Aammar Tufail, Codanics. First published 17 November 2026, last updated 16 November 2026. Found a bug or have an idea for a new tool? Tell us on the WhatsApp channel or in the comments on YouTube. Results are for learning and planning; check important analyses with a statistician or your supervisor.