So, I made this thing.

So, I made this thing. It’s a very basic random NPC generator built in Google Sheets. I don’t intend this as a character sheet generator, just as a name, description and basic personality generator. It shows three Quirks and Traits by default, but they can be contradictory so I recommend you just pick and choose whatever results work for you.

It’s got a bunch of first and last names — selected independently — personality traits, and quirks. It also generates hair and eye color in a (somewhat) accurate representation of real world percentages. I reduced the influence of South America, Asia and Africa (black hair, brown eyes) a little bit so you get a bit more variation.

I’ve tested it on my Android phone and my iPad through the Sheets app and it worked fine for me, but here’s the kicker — since both devices are accessing the same sheet, refreshing it from one device refreshes it on the other. They don’t get the same values, but the values on the Form tab do change. You can fix this for yourself by just copying it to your own Drive and using it from there (actually, please do this anyway — I’ve made the file view-only, though you should be able to save it for yourself).

Using and personalizing the sheet! This is the exciting and important stuff:

1) You need to get the data on the Form tab to refresh. You can do this most simply by just typing a character into an empty and hitting Enter and everything should change. Alternately you can refresh your browser page or reload the document.

2) You can change any and all of the data on the Data tab to suit your needs. The names I’ve used are Earth-modern. I pulled them from the crew of a major movie made outside of the US, so there’s a wide range of cultures represented, though it is primarily European.

You can change all the Quirks or Traits to anything you want, change the percentages of the eye and hair color to suit your world (pro tip: if you want 18% red hair put in 100 values for hair color and make 18 of them red). If you want to add another value… well, there are some generic columns already there, but you can email me and I can explain it if you’re having trouble figuring it out yourself.

I hope you enjoy it, and please let me know what you think!

https://docs.google.com/spreadsheets/d/1vuQ2c8hOiZexC4dXv5OJzXeI3TIzsMHTdvs_GxvvYVU/edit?usp=sharing