You’ve got a spreadsheet full of real customer names, and someone outside the team needs a copy. It might be a contractor, a client demo or a published survey — either way, the names sitting in column A can’t go out as they are. This anonymize names in Excel tool swaps every name, email and phone number in a pasted column for a consistent code or mask, so the same person always maps to the same replacement and nothing traceable leaves your computer.
Paste a column of names, emails or phone numbers (one per line). Get an anonymised column in the same order, plus a private key showing which replacement belongs to which name. Nothing is uploaded; it all happens in your browser.
The key table contains real names. Keep it private and do not share it with the anonymised data.
Why find-and-replace is a risky way to anonymise names
Find-and-replace feels quick — until it misses one. A name typed as “Jon Smith” in one row and “Jonathan Smith” in another slips straight through, and a single leftover real name in a shared file ruins the whole exercise.
Doing it by hand is just as shaky, because it’s never consistent. “Priya Patel” becomes “Person 1” on Monday’s sheet and “Client A” on Tuesday’s, and suddenly nobody can join the two files together. Coverage matters, but consistency matters just as much.
The tool below fixes both problems at once. It scans the whole column, normalises each entry, and gives every unique person one stable replacement, so duplicates and capitalisation differences collapse onto the same code automatically.
How to use the Anonymize Names tool
Paste your column of names into the input box, one entry per line. Emails and phone numbers are handled too — those get masked character by character rather than swapped for a code.
Then choose how names are replaced. Pseudonym codes give each unique person a sequential identifier built from your code word, start number and zero-padding; a fixed label stamps every row with the same tag, such as [REDACTED]; and masking hides characters while keeping the entry’s shape.
There is also a fake-names mode: pick “Replace with fake names” and every person gets a realistic invented name instead of a code, so the column still reads like real names when you share it. The same person always gets the same fake name, and different people always get different ones, so your counts and lookups still line up.
Keep the “Treat “John Smith” and “john smith” as the same person” option ticked, so capitalisation differences map to one code. Generate the output, then copy the anonymised column straight back into your spreadsheet.
Use “Load example” first if you’d like to see the tool in action before pasting real data. Nothing is uploaded at any point — everything happens in your browser.
Anonymize names in Excel, without a formula
Paste the column into the tool, pick codes or fake names, and copy the result back into your sheet. No formula is needed, and the same name always gets the same code or the same fake name, so the rows still match up.
Worked example: anonymising a small staff list
Say your column holds five rows: Alice Baker, Bob Carter, alice baker, Dave Evans and bob carter. Paste them in with the default code settings (code word “Person”, start number 1, zero-padded to three digits).
The tool recognises that “alice baker” is the same person as “Alice Baker” and assigns Person 001 to both, Person 002 to both spellings of Bob Carter, and Person 003 to Dave Evans. Copy the result column and the names are gone, while every duplicate still lines up.
Below the output you’ll find the key table, which records which code stands for which name. Keep it somewhere private and never share it alongside the anonymised column.
Codes, labels or masks: which should you pick?
Sequential codes are the best default for analysis, because they preserve the structure of your data. Counts, pivots and lookups keep working when every mention of one person shares one identifier.
A fixed label is blunt but honest: it tells the reader that something was removed without pretending the rows are distinguishable. Use it when individual rows don’t need to be told apart.
Masking suits emails and phone numbers, where keeping the general shape (the @ sign, the digit count) keeps the sheet readable while the actual contact details disappear.
If your source column mixes names with numbers on the same line, a tool that splits numbers from text can separate the parts before you anonymise.
Your private key table: handle with care
The key table is the one place where real names and their replacements sit side by side, which makes it the most sensitive output of the whole process. Store it separately from the anonymised file, ideally somewhere access-controlled.
If you no longer need to reverse the anonymisation, delete the key table. An anonymised column with no surviving key is far safer than one whose decoder sits in the next worksheet.
Anonymize names FAQs
Will the same person always get the same fake name?
Yes. The fake name is worked out from the name itself, so John Smith gets the same fake name every time you run the tool, and john smith in lower case maps to the same one too. Different people always get different fake names, so your counts and lookups still line up after anonymising.
Can I get the original names back from the anonymised column?
Only with the key table. The tool shows a table that records which replacement belongs to which original name, and that table is the only way back. Keep it somewhere private and never share it alongside the anonymised column, or the anonymising is undone.
Does the tool upload my names anywhere?
No. Everything happens in your browser and nothing is uploaded, so the names you paste never leave your computer.
What happens to emails and phone numbers in the column?
They are masked character by character rather than swapped for a code or a fake name, so an email still looks like an email and a phone number keeps its digit count while the actual contact details disappear.
Can I mix fake names with codes in one column?
No, one run uses one replacement style, so pick fake names, codes, a fixed label or masking before you generate. If you need two versions of the same list, run the column twice with a different style each time and keep the two key tables apart.
Can I anonymize names in Excel with this tool?
Yes. Paste the column from Excel, choose codes or fake names, and copy the anonymised column back into your sheet. The tool works on a pasted list, so there is no formula to write and no find-and-replace to run name by name.
Can I anonymize student names for a class list?
Yes. A class list has the same shape as the staff list in the worked example, so paste the student names in and pick codes or fake names. The same student always gets the same code or fake name, so attendance and marks still line up after anonymising.
Related tools: if your column mixes names with numbers, split numbers from units in the same column first. You can also combine multiple tabs and count entries by week once the names are anonymised.