Genderize Names In A Google Spreadsheet

Enable Our Add-on With A Single Click In The Google Sheets Add-on Store

You can add our add-on through the Google Sheets Add-on Store.

After the plugin is installed you can find it in the menu under Add-ons -> Genderize Names.

Add-On Not Working?

Google Sheets is currently experiencing a bug that prevents add-ons from functioning properly when you are logged in with multiple Google accounts simultaneously.

As a result of this bug, you may experience the following issues:
  • Login failures
  • Non-responsive buttons
  • Broken functionality

Currently, Google has not released a fix for this issue. However, there are two workarounds available to address it:

  1. Log out of all your Google accounts by clicking on the user icon in the top right corner of the Sheets document and selecting the "Log Out From All Accounts" button. Then, log back in with the one account that has access to the document.
  2. Alternatively, open an "Incognito Window" in your preferred browser and access the sheet in this window. Ensure that you are also only logged in with a single account here.
Genderize Google Sheets
Genderize Google Sheets

Select The Cells To Genderize

Select the cells with the names you want to genderize. The cell can either contain a first name, a full name or an email address.

After you've selected the cells to genderize, start our wizard in the menu under Add-ons -> Gender-API.com genderize names and select the row where we should write the result to.

Google Sheets

Hurray, Your Sheet Was Enriched With Lightning Speed

Depending on the number of rows in your file, it usually only takes a couple of seconds until you get your results.

If we weren't able to determine the gender of any of your records, we simply leave the row empty.

Google Sheets

View The Result

We've automatically filled the gender column with the appropriate gender.

Google Sheets Result
Chat