Tools to fix messy Excel files
Some spreadsheets are not just untidy, they are structurally broken: a report title sits above the header, the header spans two merged rows, page numbers and subtotals are mixed in with the records, or a PDF conversion pushed some rows one column to the right. Sorting, filtering and formulas all fail on files like these.
These tools detect the problem first and explain what they found. You approve each fix, preview the result with every affected row highlighted, and download the repaired file. Nothing is changed without your say-so.
9tools available
Fix messy columns
Repair shifted rows, misplaced headers, merged cells and junk rows.
Split column
Split one column into several by a delimiter or position.
Combine columns
Join several columns into one with the separator you choose.
Fix dates
Turn mixed or numeric dates into one consistent format.
Text to numbers
Convert numbers stored as text, including currency and percentages.
Keep leading zeros
Keep codes like 00123 intact by storing them as text.
Find and replace
Replace text across a whole sheet or in chosen columns.
Transpose
Swap rows and columns.
Extract emails and phones
Pull email addresses and phone numbers out of text into new columns.