tidyexcel
Messy spreadsheet in, tidy table out. Title rows, merged multi-row headers, totals and footnote rows — detected and removed, with every fix listed. Nothing is changed silently.
Try it — right here, in your browser.
…or drop in your own file:
Your file is parsed entirely on this device with SheetJS — nothing is uploaded anywhere, ever. This page runs the same deterministic detection as the Python package (title-row skip, header flattening, totals/footnote drop, merged-cell fill). CSV files are read as text grids; merged-cell handling applies to Excel files, which is where merges exist.
What was detected and fixed
The tidy table
Use it in Python
pip install tidyexcel
import tidy_sheet
df, report = tidy_sheet.read_excel("q3-report.xlsx") # or read_csv(...)
print(report) # every fix, listed
Source, issues and the full story: github.com/Yalakala-Naveen/tidysheet. MIT license. Deterministic heuristics only — no AI, no model calls, in this demo or in the package.