Fix garbled characters in a CSV file
150 contacts with José and ’ in them, repaired and saved so Excel shows them right.
A real run on 14 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan.
The short answer.
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.
Stella does this on Windows, Mac and Linux.
What happened.
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.
How Stella does it.
- Reads
Contacts export.csvin Documents: 150 contacts with names, companies, cities and notes - Reverses the mix-up cell by cell, so José becomes José and ’ an apostrophe, including entries garbled twice over
- Leaves entries that were already right untouched, such as a Portuguese company name whose à is a real letter
- Saves
Contacts export (clean).csvas UTF-8 with the marker Excel looks for, so a double-click shows the accents - 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.
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.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
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.
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).
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.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.
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 it 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 and 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.
Checked against these sources on 14 November 2026.