Report Sheet Tidier
Unmerges cells, fills the gaps left behind, drops decoration rows and turns a report into a flat table.
A report sheet is not a table: it has a title above the data, merged cells that hold their value once, a two-row header, spacer rows and a note underneath. Every one of those breaks a pivot table or an import. This turns it into a flat table and tells you what it changed.
Drop the report sheet
Merged cells, spacer rows and stacked headers are what this is for.
How to use it
Drop the sheet and read the summary
It lists what it did — ranges unmerged, rows dropped, which row became the header — rather than silently producing a different table.
Compare before and after
The toggle switches the preview. If a row you needed has gone, turn off the rule that took it.
Export as .xlsx or .csv
Either way the output is one header row and the data, which is what a pivot table or a database import expects.
Common questions
Will it delete my subtotal rows?
No. This reads values, not formatting — a bold subtotal row looks like an ordinary row here, so it is kept as data rather than guessed at and deleted. Filter them out afterwards if you need to.
How does it find the header row?
By looking for the first row that is mostly text with few empty cells and is followed by rows that look like data. Everything above it — titles, dates, logos — is discarded, which is the point.
What is a two-row header?
A parent row of merged group names over a child row of column names — “Q1” spanning “Jan, Feb, Mar”. Joined, that becomes “Q1 — Jan”, which is one label per column and can actually be used as a key.
Feed it from
Excel to CSV
Exports each sheet of an .xlsx or .xls workbook to CSV with the encoding and delimiter you choose.
CSV to Excel
Writes one or many CSV files into an .xlsx workbook with typed columns, a header row and filters.
Workbook Merger
Combines many workbooks or sheets into one, stacking rows or adding each source as its own sheet.
Workbook Splitter
Splits a workbook into one file per sheet, or one file per distinct value of a chosen column.
Next
These accept what this tool produces, so the result can go straight in.
CSV Cleaner
Trims cells, normalises headers, fixes number and date formats and reports rows with the wrong column count.
Pivot Table
Groups rows by one or two columns and aggregates with count, sum, average, min, max or distinct.
CSV Viewer
Opens a large delimited file with type detection, column stats and sorting, without loading it all into memory.
Excel to CSV
Exports each sheet of an .xlsx or .xls workbook to CSV with the encoding and delimiter you choose.
CSV to Excel
Writes one or many CSV files into an .xlsx workbook with typed columns, a header row and filters.
Workbook Merger
Combines many workbooks or sheets into one, stacking rows or adding each source as its own sheet.