A flat export tells you what happened but not how it adds up. Blockform takes rows you paste in, sorts them into blocks by whichever column you choose, and writes a subtotal line under each block. You pick which numeric columns get totalled, whether the header row repeats above every block, and whether a grand total closes the sheet. The result downloads as a styled .xlsx. Nothing is uploaded anywhere - the whole thing runs inside this browser tab.
Lines: 0
Paste your rows above and the formatted sheet appears here, ready to download.
Sorting puts matching rows next to each other and stops there; you still have to work out where one group ends and the next begins. Grouping adds structure: Blockform inserts a divider row at every boundary and a labelled subtotal beneath each block, so the shape of the data is visible rather than something you reconstruct by eye. The underlying rows are untouched and stay in their original order within each group.
Blockform reads each column and decides whether it holds numbers or text. Numeric columns are offered as totals and every one of them is selected by default; text columns are not, because summing a list of names is meaningless. You can change any of it. A column of ID numbers or postcodes is technically numeric and almost never worth totalling, so clear those before downloading.
On a sheet longer than a screen, a single header row at the top stops helping after the first scroll. Turning on repeated headers writes the header above every group, so each block reads on its own - which matters most when the sheet is printed or sent to somebody who will read one section and ignore the rest. It is on by default and can be turned off for a more compact file.
A grand total closes the sheet with a sum across every group, using the same columns as the subtotals. It is right for a figure that genuinely aggregates - revenue, hours, units. It is wrong, and quietly misleading, for anything already averaged or rated per unit, because adding percentages or unit prices produces a number that looks authoritative and means nothing. Turn it off for those.
Five kinds of row, in this order, written as values rather than formulas. Nothing you pasted is dropped. Free and unverified downloads also carry the watermark - one extra footer row naming Blockform. Paid downloads do not.
Your column names, bold on a filled background. By default they are repeated after each divider rather than appearing once at the top, which is the whole reason the file stays readable on paper: scroll or print past the first page of a flat export and the columns become anonymous numbers. Turn the repeat off if you would rather have one header row.
Your rows, unchanged, sorted into their group. Text stays text and numbers are written as numbers, so the columns that were totalled can be re-totalled by whoever opens the file without first stripping a currency symbol out of them.
One bold row at the end of each group, totalling the numeric columns for that group only. Columns that are not numeric are left blank rather than filled with a zero, because a zero in a text column reads as a real figure that happens to be nothing.
A filled row in the accent colour separating one block from the next. It carries no data. It exists because a subtotal row and a data row look alike at a glance once a sheet is long, and the eye needs somewhere to stop.
A single bold row at the foot of the sheet totalling every numeric column across all blocks. It is computed from the data rows, not by adding the subtotals, so a rounding difference between the two cannot creep in.
No. Blockform gathers matching rows into groups itself, whatever order they arrive in.
Not at present - grouping uses a single column. If you need a combined grouping, add a column to your source data that joins the two values, then group by that.
They are gathered into their own block, so nothing is silently dropped from the totals.
No. Parsing, grouping, totalling and writing the .xlsx all happen in your browser. Nothing is transmitted.
Paste a CSV or TSV export and download a formatted .xlsx with grouped blocks, subtotals and repeated headers - no formulas, no pivot table, no sign-up.
Paste a sales export, group it by rep, territory or product, and download an .xlsx with a subtotal under each block and a grand total. Free, in your browser.
Paste a bank or card export, group it by category, and download an .xlsx with a subtotal per category and a grand total. Nothing leaves your browser.