Remove accents from CSV: turn é, ñ and ü into plain letters in the columns you pick
In short: Upload a list, tick the columns, and every accented letter becomes its plain version, with the changed cells counted and examples shown. Limit: It changes spelling, so keep the original file when exact names matter.
Upload a CSV or .xlsx file, or paste it with a header row. The tool ticks the columns that hold accented letters. It replaces é with e, ñ with n, ü with u, and spells ß as ss and ø as o. Other columns, and the email column unless you tick it, stay as they were.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Three example rows change 5 cells: José to Jose, Café Müller to Cafe Muller, Zoë to Zoe, Åkesson & Søn to Akesson & Son and Łukasz to Lukasz.
- Cells changed
- 5
- Columns ticked
- 2
- Email column
- Untouched
What this means for you
Plain spelling does not show which addresses exist; a check does.
- é, ñ, ü, ø, ß
- Columns you pick
- Email column left out
- Examples shown
- Accents
- CSV
- Names
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Names fixed? Check the addresses before you send.
- Download the file, or use the check button under the result, which carries its addresses across.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I remove accents from a column in a CSV?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Check the ticked columns: those with accented letters are picked for you, and the email column is left out.
- Read the examples to see what changes, then check the new file.
- Download the CSV with the plain spellings.
Example
- You enter
- Three rows with first names José, Zoë and Łukasz, companies Café Müller, Åkesson & Søn and Plain Co, and an email column, with the first two columns ticked.
- You get
- 5 cells changed in 3 rows: José to Jose, Café Müller to Cafe Muller, Zoë to Zoe, Åkesson & Søn to Akesson & Son and Łukasz to Lukasz. The email column is untouched.
- Limits
- Runs in your browser; nothing is uploaded. It changes spelling, so keep the original file when exact names matter.
Why remove accents from a lead list?
Some mail merge tools, older CRMs and printing systems show accented letters as question marks or boxes. Names written with and without accents, such as Jose and José, also fail to match when you remove duplicates or compare two lists.
Plain spellings make those comparisons work. Keep the original file as well, because a person named José may prefer the accent in a greeting.
How are letters replaced?
Letters made of a base letter plus a mark, such as é, ñ, ç, å and ü, lose the mark. Letters that are not a base plus a mark use their usual plain spelling: ß becomes ss, æ becomes ae, œ becomes oe, ø becomes o, ł becomes l and đ becomes d.
German names are sometimes written ü as ue; this tool writes u. Letters from other writing systems, such as Cyrillic, Greek, Arabic or Chinese, are left alone.
What about the email column?
Addresses can contain accented letters in the part before the @ sign, and removing them can point the address at a different mailbox. The email column is left unticked for that reason. For a spelling fix on addresses themselves, use the email typo corrector; for hidden characters, use the invisible character remover.
Who uses this tool, and for what?
- Cold emailers
- Make first names safe for a mail merge tool that shows accents as question marks.
- Sales operations
- Match company names across two exports that spell the same firm with and without accents.
- Agencies
- Prepare a European lead list for a system that only accepts plain letters.
What can’t this tool tell you?
- It changes spelling, so keep the original file when exact names matter.
- German ü is written u, not ue.
- Letters from non-Latin alphabets are not transliterated.
- Only the first sheet of a workbook is read.
Common questions
- Which columns does it change?
- Only the ones you tick. Columns with accented letters are ticked for you, except the email column.
- Is ß always written ss?
- Yes. The tool writes ss for ß, ae for æ, oe for œ, o for ø, l for ł and d for đ.
- Does it touch Cyrillic, Greek or Arabic text?
- No. Only Latin letters with marks, and the special letters listed above, are changed.
- Can it break a name?
- It can change how a name is spelled, such as Müller to Muller. Keep the original file when the exact spelling matters.
- Why show examples?
- So you can see a few before and after pairs and catch anything you did not want changed before you download.
- Is my file uploaded?
- No. It is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.