Generating Random Names as Test Data

Generating Random Names as Test Data

Ever need to generate thousands of names to use as test data?

I just created an Excel sheet that uses the 1990 US census data to generate random male and female names.


A: Male First Name

B: Female First Name

C: Last Name

E: Male Full Name (Proper Case)

F: Female Full (Proper Case)

Columns A,B,C are ordered by descending popularity. It’s limited to 65,536 names (an Excel limitation), but this should work for seeding names in just about any database you’ll need.

I’ve also verified this to work in Spreadsheet 2.4.



AWS migration and transformation programs reduce cost, risk, and complexity for rapid business innovation and agility at scale. I offer a number of AWS consulting services, including an AWS migration service to quickly get you up and running. Please contact me for details on how I can help your organization.