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 OpenOffice.org Spreadsheet 2.4.