Clean

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. é -> é, ’ -> ').

🛡️ Your rows never leave your browser.
Why Onfyt: Processes fix garbled characters (encoding) entirely in-browser with dedicated Web Workers so your rows never leave your machine.

Interactive Sample Data

idauthortitle_textcity
1René DescartesIt’s a philosophical treatiseMontréal
2François HollandeCafé culture in ParisZürich
3María GarcíaThe “Golden” Era of ArtSão Paulo
4Björn BorgChampion’s mindsetMalmö

How this tool works

When datasets containing international accented letters (é, ü, ñ, ç) or typographic quotes (' " —) are opened or exported using conflicting character encodings, the text becomes garbled into nonsensical strings known as mojibake. Common examples include: - "René" turning into "René" - "It's" turning into "It’s" - "Zürich" turning into "Zürich" - "São Paulo" turning into "São Paulo" - "“Quote”" turning into "“Quote”" Mojibake occurs when text originally encoded in UTF-8 is misread as Windows-1252 (or ISO-8859-1) and subsequently re-saved as UTF-8. The multi-byte sequences that represent a single accented letter in UTF-8 get interpreted as two separate European legacy characters. This tool automatically detects and reverses common double-encoding patterns: - Translates corrupted two-byte sequences back to their original UTF-8 characters (é -> é, ñ -> ñ, ü -> ü, ç -> ç). - Restores corrupted typographic punctuation (’ -> ', “ -> ", — -> —). - Normalizes text into clean, standard UTF-8. All repairs run client-side in your browser via local Web Workers. Your data remains strictly confidential on your local device. From an internationalization perspective, mojibake encoding corruption (such as "é" for "é" or "’" for "'") occurs when UTF-8 text is misread as Windows-1252 and re-saved. DataFix detects double-encoded character patterns and reverses the corruption, restoring proper accented letters, typographic quotes, and currency symbols into clean, standard UTF-8 text. From an enterprise security standpoint, customer names, international correspondence, and legal contracts contain sensitive information that must be handled privately. Uploading garbled files to external online utilities creates significant compliance risks. DataFix repairs all character encoding glitches locally in-browser via Web Workers, ensuring that zero data leaves your local machine. In cross-border business communications, legal document processing, and customer support databases, mojibake encoding errors severely damage document readability. When customer names like "René" or addresses like "Montréal" become garbled into "René" and "Montréal", client records become unsearchable and formal communications look unprofessional. By reversing double-encoding corruption, administrative teams restore international text to crisp, professional UTF-8 standards. In addition, our engine detects and repairs triple-nested encoding corruption (é) and UTF-8 Byte-Order Mark (BOM) conflicts, restoring pristine typographic quality across international publications, multilingual books, and foreign language databases.

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

🧪 Empty cells or missing values

Safely handled without schema corruption.

🧪 Leading or trailing cell whitespace

Sanitized prior to processing.

🧪 Large files with 25,000+ rows

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

Clean

Remove Special Characters

Strip invisible control characters, non-ASCII symbols, smart quotes, and unwanted punctuation from spreadsheet cells.

Open Tool →
Clean

Remove Special Characters

Strip invisible control characters, non-ASCII symbols, smart quotes, and unwanted punctuation from spreadsheet cells.

Open Tool →
Clean

Trim Whitespace

Clean up accidental leading, trailing, and duplicate spaces across all columns in your spreadsheet.

Open Tool →