Most systems export the same way: one flat CSV, every row identical in weight, no structure. Turning that into something a person can read usually means a pivot table or a column of formulas you rebuild every month. Blockform does it in one pass - paste the export, choose the column to group by, and download a styled .xlsx with blocks, subtotals and a grand total already written in as values.
Lines: 0
Paste your rows above and the formatted sheet appears here, ready to download.
Blockform has no file picker on purpose. You copy the rows - from a spreadsheet, a text editor, a database client - and paste them straight in. That skips the encoding problems that make CSV files annoying: no BOM to strip, no choosing between UTF-8 and Latin-1, no wondering which delimiter the exporting system picked. What you copied is what gets parsed.
Tab, comma, semicolon and pipe separated text all parse without a setting to change. Copying from a spreadsheet gives you tab-separated text; copying from a raw .csv gives you commas; several European systems emit semicolons because the comma is a decimal separator there. Blockform looks at the first ten non-empty lines, counts how often each of those four characters appears, and uses whichever is most common - so you do not have to know in advance which one your export used.
Exports routinely wrap numbers in thousands separators and currency symbols, which is why a pasted column sometimes refuses to total anywhere else. Blockform strips commas, spaces, apostrophes and the $ € £ ¥ symbols before deciding whether a column is numeric, so values like 1,240.50 and $1,240.50 are both recognised and can be totalled. A value wrapped in brackets, (240.50), is read as negative. A value ending in a percent sign is deliberately NOT treated as a number, because summing percentages is meaningless - such a column stays text and is never offered as a total.
The downloaded file contains numbers, not SUM() calls. That is deliberate: a formula sheet breaks when rows are inserted, sorted or pasted into another workbook, and it recalculates differently across Excel, Sheets and Numbers. Values do not move. If you need the file to stay live as the data changes, that is a spreadsheet job rather than a formatting one, and Blockform is the wrong tool for it.
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.
Tab, comma, semicolon and pipe, detected automatically. Pasting straight out of a spreadsheet gives tab-separated text and works without any setting.
Blockform treats the first row as column headers, which is what almost every export produces. Those names are what you pick from when choosing the grouping column.
Yes. The download is a standard .xlsx, which Sheets, Numbers and LibreOffice all read, including the divider colours and bold totals.
Everything runs in the browser, so the practical limit is your machine rather than a server quota. Ordinary exports of a few thousand rows are comfortable.
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 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.