APA table generator
Paste a group column and a value column. You get Table 1 — n, mean, standard deviation and range by group — formatted with rules top and bottom and no vertical lines, ready to download into Word.
What an APA table actually requires
Four things, and only the first is about the numbers:
- A number and an italic title above the table — "Table 1" on its own line, then what the table contains.
- Horizontal rules only, and only three: above the column headings, below them, and at the bottom. No vertical rules, no boxes, no shading.
- Columns aligned on the decimal point; the leftmost column left-aligned.
- A note below explaining every abbreviation and where the data came from.
The export produces exactly that, because the Word file is generated with the rule widths set explicitly rather than applied as a table style that Word might later reinterpret.
The table most papers need first
Before any test is reported, a paper usually needs a table describing the sample: how many in each group, the mean and standard deviation, and often the range. Every discipline does this and almost nobody enjoys doing it, because it means either hand-assembling a pivot table or reformatting an output window.
It is also the table where formatting errors are most visible to a reviewer, because every reader has seen thousands of them and the correct shape is immediately recognisable.
A worked example
Thirty observations in three groups of ten.
| Group | n | M | SD | Min | Max |
|---|---|---|---|---|---|
| Control | 10 | 50.12 | 2.11 | 46.70 | 53.10 |
| Low | 10 | 55.00 | 2.07 | 51.90 | 58.30 |
| High | 10 | 57.96 | 1.92 | 55.10 | 61.20 |
| Total | 30 | 54.36 | 3.83 | 46.70 | 61.20 |
Values are given to two decimal places, which is the usual convention for means and standard deviations in this range. The note that goes under the table is generated for you, because an unexplained abbreviation is the most common reason a table comes back from a copy editor.
What the Word file contains
A caption, the three-line table, the note, and a reporting sentence describing the spread of the group means. No page furniture, no logo, no header — it is meant to be pasted into your own document and inherit its styling.
Frequently asked
Can I paste directly from Excel?
Yes. Copy two columns and paste them here — the tab separators are recognised, and a header row is skipped automatically.
What if I only have one group?
Leave the label off and use one value per line. Everything goes into a single row labelled "All", which is what a one-sample descriptive table looks like.
Why is there no vertical rule?
Because APA style forbids it, and because a table that relies on vertical rules to be readable is usually carrying too many columns.
Does this run the statistics too?
Only descriptive statistics. For a test, use one of the calculators, or the app, which picks the procedure from your design and exports a table that includes the test result.
Is my data uploaded?
No. The table is computed and the Word file is built in your browser.
Beyond descriptives
This page formats the table you already know how to compute. The StatsToTable
app goes further: it reads a .sav, .xlsx or .csv,
works out which test your design calls for, checks the assumptions, and exports the results
table with the APA sentence already written. One report export a month is free.
Which test should I use? · t test calculator · chi-square calculator · ANOVA calculator · correlation calculator · p value calculator