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:

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

More guides