Paste rows, pick a column to group by, and download a formatted spreadsheet with per-group totals, divider rows, and repeated headers.
Lines: 0
Paste your rows above and the formatted sheet appears here, ready to download.
Copy table-like text from a spreadsheet, CSV, or anywhere—Blockform detects the layout automatically.
Pick the column you want to group by. Totals are calculated for every numeric column you select.
Preview the result, adjust the divider color or total labels, then download the finished spreadsheet.
Five kinds of row, in this order, written as values rather than formulas. Nothing else is added and nothing you pasted is dropped.
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.
Values rather than formulas is the decision most worth knowing about before you download. A sheet of SUM() calls breaks when rows are inserted, sorted, or pasted into another workbook, and it recalculates differently across Excel, Sheets and Numbers. These totals cannot move. The trade is that the file does not stay live as the data changes - if you need that, you need a spreadsheet, not a formatter.
Paste rows, pick the column to group by, and get an Excel file with a subtotal after every group, repeated headers and a grand total. Free, in your browser.
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.