Repair mojibake and character encoding corruption (e.g. é to é)
Repair character encoding glitches (mojibake) caused by Windows-1252 or ISO-8859-1 interpreted as UTF-8 (e.g. é -> é, ’ -> ').
Interactive Sample Data
| id | author | title_text | city |
|---|---|---|---|
| 1 | René Descartes | It’s a philosophical treatise | Montréal |
| 2 | François Hollande | Café culture in Paris | Zürich |
| 3 | MarÃa GarcÃa | The “Golden†Era of Art | São Paulo |
| 4 | Björn Borg | Champion’s mindset | Malmö |
How this tool works
Things that usually go wrong
- Triple-Encoded Characters: Files converted multiple times may have layered corruption (é). Running the repair twice resolves stacked encoding layers.
- Irreversible Replacement Characters (): If a legacy system replaced characters with black diamond question marks (), the original bytes were lost and cannot be recovered.
- Byte-Order Mark (BOM) Conflicts: Some Windows apps require a UTF-8 BOM. DataFix can export with or without BOM.
Edge cases we tested
Safely handled without schema corruption.
Sanitized prior to processing.
Streamed via client-side Web Worker without tab freezing.
Frequently Asked Questions
Why did my text turn into "é" and "’"?
This happens when UTF-8 text is opened as Windows-1252 and saved again, splitting multi-byte characters into two garbled symbols.
Can this repair accented names like René and Zürich?
Yes! It restores French, German, Spanish, Portuguese, and Scandinavian accented characters.
Does it fix corrupted smart quotes and apostrophes?
Yes. It converts ’ back to an apostrophe (') and “ / †back to quotation marks (").
Is my data private?
Completely. All repairs occur locally within your browser sandbox via Web Workers.
Related tools
Remove Special Characters
Strip invisible control characters, non-ASCII symbols, smart quotes, and unwanted punctuation from spreadsheet cells.
Open Tool →Remove Special Characters
Strip invisible control characters, non-ASCII symbols, smart quotes, and unwanted punctuation from spreadsheet cells.
Open Tool →Trim Whitespace
Clean up accidental leading, trailing, and duplicate spaces across all columns in your spreadsheet.
Open Tool →