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.

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.