Will you be altering the punctuation and capitalization of names after the survey has concluded? I personally don't capitalize my personal name but use my every day name with proper capitalization and filled out the survey as such
I will lowercase everything for easy counting, but depending on how many entries there are, there might not be much more I can reasonably do.
It's a tricky decision because I do get that some people's names are capitalised and some aren't, and some are correct either way. As with all surveys that I fling at an entire subset of the population, I often have to accept that nuance will be lost when gathering broad statistical data.
=lower(trim()) is a really convenient way to count all the names spelled the same way. If a small proportion of people going by a particular name prefer not to capitalise it, their names would otherwise be counted separately and they'd be further down the list. I don't know if they'd feel it was more representative to keep [Name] and [name] separate, or roll them all together. If only one person entered a name uncapitalised and it was counted separately, it would be omitted from the results altogether, even if it was an otherwise fairly popular name. Dilemma!
Having said that, it's fairly easy to leave capitalisation as it is, so I might try it both ways and see if it radically changes much.
Also, I should do a poll to find out how important capitalising or decapitalising a name is to people generally. (On it.)
[ Click here to participate in the nonbinary name survey before 19th July 2026 ]