Clean a software export
"Printed" exports from ERPs, banks and payroll software repeat the header on every page, slip subtotals between the data and write a group label only once. We turn them into a table you can filter and sort.
What this tool does
- Headers repeated through the file, removed.
- Subtotal and total rows ("Subtotal", "Grand total", "Carried forward"), removed and shown.
- Fully blank rows, removed.
- A header spread over two or three rows, flattened into one.
- Group labels filled down in the columns you tick.
What it does not do: A subtotal is recognised by its label: a total row without a label stays, and shows in the preview. Merged cells in a workbook are handled by the unmerge tool.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Fix a CSV file : Broken accents, everything in one column, lost zeros: a file Excel opens right the first time.
- Remove duplicates : On the columns you choose, optionally ignoring case, spaces and accents.
- Near-duplicates : "Smith Ltd" and "SMITH LTD.": the almost-identical duplicates, reviewed one by one.
- Clean text : Extra spaces, non-breaking spaces, line breaks, invisible characters, case.
- Convert text to numbers : "1,234.56 $", "(45.00)", "12.5-": real numbers that add up.