Private by design: files stay on your device
Fix my Excel file
Open a messy Excel or CSV file to see every problem in it: duplicates, stray spaces, blank rows, misplaced headers and more. Then fix each one in a click.
- 1Upload
- 2Review
Drop your Excel or CSV file here
XLSX, XLSM, XLS, ODS, CSV, TSV or JSON
Your file never leaves your device
One tool for each spreadsheet problem
Each tool does one job well, with sensible defaults and a preview before you download. More tools are on the way.
Clean
All clean toolsRemove duplicates, stray spaces, blank rows and unwanted characters.
Remove duplicates
Find and remove repeated rows, by whole row or chosen columns.
Remove extra spaces
Trim leading, trailing, double and invisible spaces from cells.
Remove blank rows
Delete empty rows and columns in one step.
Change case
Switch text to UPPER, lower, Proper or Sentence case.
Remove special characters
Strip symbols and punctuation while keeping letters in any language.
Fill blank cells
Fill empty cells with the value from the row above.
Repair shifted columns, broken dates, numbers stored as text and more.
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.
Merge & split
All merge & split toolsCombine files, split sheets, compare versions and join tables.
Merge files
Stack several files or sheets into one, matching columns by name.
Split file
Split a sheet into separate files by column value or row count.
Compare files
See added, removed and changed rows between two versions.
Join sheets by column
Bring columns from one sheet into another using a shared key.
Convert
All convert toolsSwitch between CSV, XLSX, XLS and JSON without losing data.
CSV to Excel
Convert CSV files to XLSX with correct characters and leading zeros.
Excel to CSV
Save any sheet as a UTF-8 CSV that opens cleanly everywhere.
XLS to XLSX
Upgrade old .xls workbooks to the modern .xlsx format.
Excel to JSON
Turn a sheet into a JSON array of objects keyed by header.
JSON to Excel
Turn a JSON array of flat objects into a spreadsheet.
How it works
- 1
Open your file
Drop in an Excel or CSV file. Your browser reads it on your own device; nothing is uploaded.
- 2
Choose a fix and preview it
Pick what to clean. Every change is highlighted in a preview before you download anything.
- 3
Download the clean file
Save the result as XLSX or CSV, with a plain-language report of exactly what changed.
Your spreadsheet never leaves your device
- Your file is opened and processed by your own browser, never sent to a server.
- Nothing is stored: close the tab and the data is gone.
- No account, no sign-up and no email address needed.
Frequently asked questions
Is SheetTidy really free?
Yes. Every tool is free to use with no account, no watermark and no limit on how many files you clean. The only limit is the memory of your own device.
Are my files uploaded anywhere?
No. Once the page has loaded, your file is read and processed by JavaScript running in your browser tab. It is never sent to a server, stored or logged, which is why SheetTidy is safe to use with customer lists, payroll and bank exports.
Which file types can I open?
Excel workbooks (.xlsx, .xlsm and the older .xls), OpenDocument spreadsheets (.ods), and CSV or TSV text files. Macros in .xlsm files are never run. Results download as .xlsx or as UTF-8 CSV.
What does the file check on this page look for?
Duplicate rows, extra or invisible spaces, blank rows and empty columns, a header that is not in row 1, merged cells, rows shifted into the wrong columns, repeated headers and total rows inside the data, dates or numbers stored as text, and names in inconsistent capitals. Each problem links to the tool that fixes it.
How large a file can I clean?
Files up to 200 MB can be opened. Most files of 100,000 rows are cleaned in a few seconds on a typical laptop; very large Excel workbooks take longer to read and write than CSV files.
Will my formatting and formulas be kept?
Your data is kept exactly: text, numbers, dates and leading zeros. Formatting such as colours, fonts and column widths is not carried over, and formulas are saved as their calculated values. Keep your original file if you need those.