# Fix garbled characters in a CSV file

> Markdown version of https://stella.sh/how/pdf-excel/fix-garbled-characters-in-csv for agents and LLMs.
> Repair names like JosÃ© and â€™ in a CSV, cell by cell, without breaking real accents, and save a copy Excel opens right by double-click. Excel, or Stella (stella.sh).

First check whether the file is really broken: if it reads fine in a text editor, Excel just opened it with the wrong encoding, and Data, From Text/CSV with File origin UTF-8 fixes the view. If the garble is saved in the file, it has to be reversed cell by cell, and a find-and-replace list can break names where the Ã is real. Stella (stella.sh) repairs each cell on your computer, leaves correct ones alone and saves a copy Excel opens right by double-click.

- Checked: 14 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: About half a minute. Checked afterwards against an answer key written before the run: all 150 contacts kept, every cell reading exactly as it should (José, Zoë Brontë-Hale, O’Connor’s, Łódź, €45), rows that were already right untouched, and a CSV saved with the UTF-8 marker so Excel opens it correctly. The contacts are made up, garbled for this run the way a UTF-8 file gets when it's opened as Windows text and saved again. The run was checked in the file; Excel itself wasn't opened. Shown at normal speed.

Video (45 s): https://stella.sh/media/proofs/pdf-excel/fix-garbled-characters-in-csv/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A contacts CSV with garbled names is in Documents.
- 0:02 The prompt: fix the garbled characters and save a clean copy that opens properly in Excel.
- 0:04 Stella works on it straight away in the chat, at normal speed.
- 0:30 Done: every garbled entry fixed, correct ones left alone, saved so Excel keeps the accents.

What Stella does:

1. Reads `Contacts export.csv` in Documents: 150 contacts with names, companies, cities and notes
2. Reverses the mix-up cell by cell, so JosÃ© becomes José and â€™ an apostrophe, including entries garbled twice over
3. Leaves entries that were already right untouched, such as a Portuguese company name whose Ã is a real letter
4. Saves `Contacts export (clean).csv` as UTF-8 with the marker Excel looks for, so a double-click shows the accents
5. Checks the whole file for leftover garble, keeps the original, and points out email addresses that are missing accented letters rather than garbled

## The prompt to paste

```text
The names in the contacts CSV in my Documents have gone weird, like 'JosÃ©' instead of 'José' and 'â€™' where apostrophes should be. Fix all the garbled characters and save a clean copy that opens properly in Excel.
```

## Fix it yourself

1. **Check whether the file or the view is wrong.** Open the CSV in Notepad or TextEdit. If names read right there, the file is fine and only Excel misread it: skip to the import step. If you see JosÃ© there too, the garble is saved in the file.
2. **Import with the right encoding.** Windows Excel: Data, From Text/CSV, set File origin to 65001: Unicode (UTF-8), Load. Excel for Mac: File, Import, CSV file, File origin Unicode (UTF-8).
3. **Replace the garbled patterns.** For text saved garbled, use Find and Replace (Ctrl+H) per pattern: `Ã©` to é, `Ã¨` to è, `Ã¶` to ö, `â€™` to ’, `â€œ` and `â€` to quotes, `â‚¬` to €. Search for `Ã` alone afterwards to find what's left.
4. **Watch the real Ã.** Portuguese and some other names use Ã as a real letter (SÃO JOÃO). Don't run a blanket replace on Ã; fix those cells by eye.
5. **Save so Excel reads it next time.** File, Save As, CSV UTF-8 (Comma delimited). That version starts with a marker (a BOM) that tells Excel the encoding, so a double-click opens it correctly.

## Where Stella stops

- Characters already turned into `?` or `�` are gone from the file. Stella can only guess them from context and should say which ones it guessed; none came up in this run.
- It saved a clean copy and kept the original; ask if you want the file fixed in place.
- Email addresses that simply lack accented letters aren't garbled, so Stella left them and flagged them to check.
- The file's contents go to the AI model you use in Stella while it checks them.
- Recorded on Linux, where Stella used Python, built in on Mac and Linux. On Windows it may install Python first, which wasn't recorded.

## Questions

**Why does Excel show Ã© instead of é?**
The file is UTF-8 but Excel opened it as older Windows text, so each accented letter's two bytes show as two characters. Importing with UTF-8 fixes the view; if someone saved it in that state, the garble is now in the file.

**What does â€™ mean?**
It's a curly apostrophe (’) read with the wrong encoding. `â€œ` and `â€` are curly double quotes, `â€“` a dash and `â‚¬` the euro sign.

**How do I save a CSV that Excel opens with accents?**
Save it as CSV UTF-8 (Comma delimited). The BOM at the start tells Excel to read it as UTF-8 on double-click.

**Can it tidy the contacts too?**
Yes: see [merge duplicate contacts](https://stella.sh/how/contacts-calendar-email/merge-duplicate-contacts) and [convert CSV to VCF](https://stella.sh/how/contacts-calendar-email/convert-csv-to-vcf) for a phone.

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [Microsoft Support: Opening CSV UTF-8 files correctly in Excel](https://support.microsoft.com/en-us/office/opening-csv-utf-8-files-correctly-in-excel-8a935af5-3416-4edd-ba7e-3dfd2bc4a032).

## Related problems

- [Change dates in Excel from US to UK when they come out wrong](https://stella.sh/how/pdf-excel/fix-dates-in-excel.md)
- [Merge duplicate contacts from two lists](https://stella.sh/how/contacts-calendar-email/merge-duplicate-contacts.md)
- [Convert a contacts CSV to a VCF file for your phone](https://stella.sh/how/contacts-calendar-email/convert-csv-to-vcf.md)
- [Convert bank statement PDFs to Excel](https://stella.sh/how/pdf-excel/bank-statement-pdf-to-excel.md)
- [Reduce PDF file size when it's too large to email](https://stella.sh/how/pdf-excel/compress-pdf-too-large-to-email.md)
- [Combine multiple Excel files into one sheet](https://stella.sh/how/pdf-excel/combine-excel-files-into-one-sheet.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
