GENDER.FROM_EMAIL Function

Description:

This custom function predicts gender based on an email address using GenderAPI.io. The function intelligently extracts names from email usernames and matches them against a global dataset.

Requirements

This function works with the GenderAPI for Microsoft Excel Add-in.
To use it, please make sure you have the add-in installed:
https://appsource.microsoft.com/en-us/product/office/WA200008555

Syntax

=GENDER.FROM_EMAIL(email, [enable_additional_info], [country])

Parameters

email: (Required) The email address to analyze (e.g., "emilyjohnson@example.com").
enable_additional_info: (Optional) Set to 1 to include extended information.
country: (Optional) ISO 2-letter country code (e.g., "US", "TR", "DE") to increase accuracy.

Returns

If enable_additional_info is 0 or omitted:
➤ Returns a single value: male, female, or null.

If enable_additional_info is 1:
➤ Returns a 1-row, 4-column array with:

Gender	Probability	Most Likely Country	Matched Name
female	94	US	emily

Examples

Example 1: Predict gender from email

=GENDER.FROM_EMAIL("alex.johnson@example.com")

Example 2: Include extended info

=GENDER.FROM_EMAIL("emily.j@example.com", 1)

Example 3: Add country filter for better results

=GENDER.FROM_EMAIL("andrea.rossi@domain.com", 1, "IT")

Notes

GenderAPI attempts to parse the name portion from the email before analysis.
Using a country code helps resolve ambiguous names more accurately.
This function uses live API calls and requires internet access.
Returned results will spill into adjacent cells when enable_additional_info is set to 1.