How to replace real names with fake names in Excel
Realistic stand-ins for names, emails and phone numbers
Demos, training material, test systems and screenshots all look better with realistic data
than with xxxx. Fake names, emails and phone numbers keep a sheet readable
while removing the real people from it.
With formulas
Put a list of first names in one column and surnames in another, give them names such as
First and Last, and pick at random with
RANDARRAY (Excel 2021, 2024 and
Microsoft 365):
=INDEX(First, RANDARRAY(1, 1, 1, ROWS(First), TRUE)) & " " &
INDEX(Last, RANDARRAY(1, 1, 1, ROWS(Last), TRUE))
It works, with catches:
- RANDARRAY recalculates on every change, so copy the results and use Paste Special › Values, then delete the real names.
- The same person gets a different fake on every row. If Matti Virtanen has five orders, he becomes five different people, and totals per customer stop making sense.
- Emails, phone numbers and IDs need their own formulas, and fake IDs should still pass their checksum if a system validates them.
Consistent fakes
With Scrubsheet, choose Fake for a column. Names become realistic names, emails become emails at reserved example domains, and IBANs and national IDs keep their format and pass their checksums. Turn on consistent output with a project secret and the same input always gets the same fake, in every row, sheet and file, so joins, counts and pivot tables still work. Finnish and Norwegian personal identity numbers are drawn from the official test ranges, so a fake can never be a real person's number.
Fake values are free in the browser tool, and part of Pro in the Excel add-in. For test data from a production database, see test data from production data.
Try it on your own file. The Scrubsheet browser tool anonymizes Excel and CSV files in your browser, free and without uploading anything. In Excel, use the Scrubsheet add-in.
Anonymize a spreadsheet