Home / Tools / csv-char-fix

CSV & data

csv-char-fix

Fix weird characters like é and ’ in CSV and text files.

Buy on Gumroad
csv-char-fix — Fix weird characters like é and ’ in CSV and text files.

Did an export turn José into José or it's into it’s? This small script puts the text back the way it should be and saves the file so Excel shows accents right.

What it does

  • Fixes garbled letters that were broken once, twice, or three times.
  • Leaves normal accented text alone.
  • Reads UTF-8, UTF-16, and Windows-1252 files, and never changes your original.

Before and after

Broken characters

name,city,note
José Núñez,São Paulo,"It’s done — thanks!"
Zoë Brontë,Zürich,Price: €25

Fixed file

name,city,note
José Núñez,São Paulo,"It’s done — thanks!"
Zoë Brontë,Zürich,Price: €25

From csv-char-fix/samples/contacts-broken.csv and contacts-fixed.csv.

Get it

For your computer · Gumroad · $1

One Python script. Needs Python 3.8+. CSV and text files only, not .xlsx.

Buy on Gumroad

FAQ

What does this tool do?

Fix weird characters like é and ’ in CSV and text files. Did an export turn José into José or it's into it’s? This small script puts the text back the way it should be and saves the file so Excel shows accents right.

What does it cost?

For your computer on Gumroad costs $1. One Python script. Needs Python 3.8+. CSV and text files only, not .xlsx.

Will you see my files?

The download tools run on your computer, so those files stay with you. The Apify tools run in your own Apify account. This website does not take uploads.