Guessing Genders using Google Sheets

If you have a list of names and you want to guess their genders, here’s a nifty utility developed in Google Sheets that you will find handy.

Google Sheet Design

This Google Sheet contains two tabs:

Guessing Gender

The columns highlighted in yellow are input columns, and the ones highlighted in green are output columns.

Database

This Google Sheet contains a tab called ‘Database’ where all the gender information is stored. The Guessing Gender tab pulls information from the Database tab to guess the gender of the person based on their first name. It also comes in handy to add gender information for a new name or edit gender information to Unisex, as and when needed.

How to Use?

Execution

  • Paste the list of names, as values, in column B of tab: Guessing Gender.
  • If you have a unique identifier for each name, that could go into column A in tab: Guessing Gender.
  • Go to the Menu bar at the top, and from the top-level menu, Genius, click on Guess Gender – a Google Apps Script. (Check this post to learn how to automate your spreadsheets using Google Apps Scripts.)
  • The script will guess the gender for each name in column C: Guessed Gender.

Corrections

  • If the guessed gender is ‘Unisex‘, or appears to be opposite of what you thought, use column E, Manual Correction, to update it.
  • If column D, Guessed Gender, doesn’t guess anything, you can add those values in column C, First Name, at the end of the tab: Database in column A, First Name, and add Gender information in column B, Gender. The tab will automatically update the gender information for these names for which the value in the Gender column was previously missing.

Outputs

At the end of this exercise, columns A, B, F (Unique ID, Name, Gender) will be your output and you can download these columns to use in your subsequent work.

Hit the subscribe button below if you would like to be notified about such new posts.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s