Orihako Data

Fix a CSV that Excel garbles

An export shows é instead of é, or boxes instead of letters. The cause is an encoding mismatch (UTF-8 without the mark Excel wants, or another encoding).

Open the fix

Steps

  1. Drop the CSV on "Fix garbled CSV". The encoding is detected.
  2. Press the preset "Open in Excel" and save (UTF-8 with the byte-order mark).
  3. Double-click the saved file. No import wizard needed.
  4. Many files at once needs the Pass; one at a time stays free.

Questions

Do I have to fix it every time?
No. Once saved with "Open in Excel", it opens correctly from then on.
Is the original changed?
No. The fixed file is saved separately.

The CSV is never sent anywhere; everything runs in this browser.