Every few weeks someone sends me a spreadsheet that looks like a crime scene: merged cells everywhere, dates in five formats, numbers stored as text, one header row buried three rows down, and a "total" that nobody trusts. If you just need the file to work — not to become an Excel expert — here is the exact checklist I run through. Ten minutes, no formulas, no Power Query, nothing to install.
The 10-minute checklist
1. Snapshot first (30 seconds). Save a copy named original-backup. Every step below is reversible if you can go back.
2. Un-merge everything (1 minute). Select all (Ctrl+A), then Home → Merge & Center → Unmerge Cells. Merged cells break sorting, filtering, and most imports. Fill the gaps afterward if labels disappear: select the column, F5 → Special → Blanks → type = and press the cell above, then Ctrl+Enter.
3. Fix the header row (1 minute). Delete any junk rows above the real headers (right-click row number → Delete). Freeze the header: View → Freeze Panes → Freeze Top Row.
4. Trim hidden spaces (2 minutes). "John " and "John" are different values to Excel. Select your text columns → Data → Text to Columns → Finish (defaults only). That alone strips most trailing spaces without writing a formula.
5. Make dates actual dates (2 minutes). Mixed 01/02/2026 vs 2026-01-02 vs "Jan 2" is the #1 source of broken pivots. Select the column → Data → Text to Columns → Step 3 → choose Date → pick the format the text actually uses → Finish. If some cells stay right-aligned (text) while others go left-aligned (dates), you have a mixed column; re-run on the leftovers.
6. Un-text your numbers (2 minutes). Numbers stored as text sort wrong and break SUM. The tell: values sit left-aligned with a little green triangle. Select the column → use the warning dropdown → Convert to Number. Text to Columns with default settings also does this in bulk.
7. Kill duplicates (1 minute). Select your data → Data → Remove Duplicates → tick the columns that define "same row". Check "My data has headers". Note the count Excel reports — if it deletes far more than you expected, your key columns are wrong (undo and re-tick).
8. Sanity-check the totals (1 minute). Select each numeric column and glance at the status bar: Sum / Average / Count. If a column's Sum ignores some rows, those rows are still text — back to step 6. Then Ctrl+S and delete the backup a week later, not today.
When to stop DIY
The checklist scales fine to a few hundred rows. It stops being "ten minutes" when you hit any of these: multiple sheets that reference each other, exports with repeating subtotal rows, half-merged invoice layouts, or files where somebody pasted screenshots of tables (yes, that happens). That's the point where a script or a second pair of eyes pays for itself.
Or hand it off
I run a small done-for-you cleanup service for exactly this: you send the file, I return it clean — headers frozen, dates normalized, duplicates removed, a short note of what was changed. Flat $1, 24-hour turnaround, full refund if you're unhappy. The price is intentionally $1 while I collect my first real reviews, so if you try it, tell me honestly what sucked: https://datafixtools.sell.app/product/done-for-you-spreadsheet-cleanup
Top comments (0)