SpreadsheetFix vs Excel for cleaning CSV data
Excel can clean almost anything if you know the right functions and do the steps by hand. SpreadsheetFix does the common cleaning steps for a CSV in one pass, before the file is opened in Excel, so Excel's automatic type conversion never gets a chance to change it.
| Aspect | SpreadsheetFix | Excel |
|---|---|---|
| Where it runs | In your browser, nothing to install | Desktop app, or Excel for the web |
| Opening a CSV | Values kept as text until a rule changes them | Dates, long numbers and leading zeros converted on open, based on regional settings |
| Duplicates | Whitespace normalised before matching; preview of every removed row | Data › Remove Duplicates; ignores case, but spaces and formatting make values differ; no list of what was removed |
| Spaces | Trims and collapses spaces, including non-breaking spaces | TRIM removes regular spaces only, not non-breaking ones (CHAR(160)) |
| Mixed date formats | Detects day-first or month-first per column and converts to one format | Manual: Text to Columns, DATEVALUE, or Power Query |
| Garbled characters (é) | Repaired automatically | Re-import with the right file origin, or fix by hand |
| Proof totals didn't change | Totals check on amount columns | Manual SUM before and after |
| Size | 5,000 rows free, 500,000 on Pro | 1,048,576 rows per sheet |
| Formulas, pivots, charts | No | Yes |
Choose Excel when
- You need formulas, pivot tables or charts on the result.
- The cleaning is a one-off fix you already know how to do.
- You're already using Power Query to refresh the same report.
Choose SpreadsheetFix when
- You want to clean a CSV before Excel changes its dates and codes.
- You need several fixes on an export without writing formulas.
- You want to see every change, and a check that totals still match, before you use the file.
Excel changes a CSV the moment you open it
When you double-click a CSV, Excel guesses each column's type. 03/04/2026 becomes a date in whichever order your regional settings use, 00123 becomes 123, and a 16-digit card or account reference is shown in scientific notation, with every digit after the fifteenth turned into a zero. Recent Microsoft 365 versions let you turn some of these conversions off under File › Options › Data. Cleaning the CSV first, and normalising dates to YYYY-MM-DD, avoids the problem in every version.
Why Remove Duplicates misses duplicates
Excel ignores capitalisation but otherwise compares cells as they are displayed. “Acme Ltd” and “Acme Ltd ” (with a trailing space) are different to it, the same date in two formats counts twice, and TRIM won't remove the non-breaking spaces that come from web pages and PDFs. SpreadsheetFix trims and collapses whitespace before comparing, so rows that differ only by spacing are matched, and it shows each removed row so you can check the result.
Use both
The two tools do different jobs. Clean the export in SpreadsheetFix, then open the cleaned file in Excel for analysis. On Pro you can download a native .xlsx in which every value is stored as text, exactly as cleaned, so Excel has nothing to guess.
Questions
Is SpreadsheetFix a replacement for Excel?
No. It cleans files; it doesn't do formulas, pivot tables or charts. Most people use it to prepare a CSV before opening it in Excel.
How do I stop Excel changing dates in a CSV?
Convert the dates to YYYY-MM-DD before opening the file, or import it with Data › From Text/CSV and set the column type to Text. SpreadsheetFix's Normalize Dates rule does the first option for you.
Why doesn't Excel's TRIM remove all spaces?
TRIM removes the regular space character (code 32). Non-breaking spaces (code 160) are left, which is why cells copied from web pages still look padded. SpreadsheetFix removes both.