GENDER.FROM_USERNAME Function

Description:

This custom Excel function uses GenderAPI.io to determine gender based on a person's online username. It is most accurate when usernames include real first names or full names.

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_USERNAME(username, [enable_additional_info], [country])

Parameters

username: (Required) A username that includes a real name (e.g., "johnsmith_1985").
enable_additional_info: (Optional) 1 to return detailed metadata.
country: (Optional) ISO 2-letter country code (e.g., "US", "DE", "TR") to improve precision.

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
male	98	US	john

Examples

Example 1: Predict gender from a full name in username

=GENDER.FROM_USERNAME("maria.garcia1990")

Example 2: Detailed result from a professional username

=GENDER.FROM_USERNAME("thomas.jensen", 1)

Example 3: Country-specific result for common names

=GENDER.FROM_USERNAME("ahmet.karaca", 1, "TR")

Notes

This function works best with usernames that include real names (e.g., "john.smith", not "coolguy123").
GenderAPI uses AI and name matching algorithms to analyze input.
Country filtering improves accuracy for ambiguous names.
An internet connection is required to retrieve results.
When enable_additional_info is 1, the result spills across adjacent columns.