GENDER.FROM_NAME Function

Description:

This custom Excel function uses GenderAPI.io to predict the gender of a person based on their first name or full name.

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

=GENDER.FROM_NAME(name, [enable_additional_info], [country])

name: (Required) First name or full name (e.g., "Emily" or "Emily Johnson").
enable_additional_info: (Optional) Set to 1 to return extended metadata.
country: (Optional) ISO 2-letter country code (e.g., "US", "DE", "TR") to improve accuracy.

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:

Gender	Probability	Most Likely Country	Matched Name
female	96	US	emily

Example 1: Basic gender prediction

=GENDER.FROM_NAME("Alex")

Example 2: Use additional info for detailed output

=GENDER.FROM_NAME("Emily Johnson", 1)

Example 3: Improve accuracy with country filter

=GENDER.FROM_NAME("Andrea", 1, "IT")

Function is case-insensitive ("EMILY" = "emily").
If the name contains multiple words, GenderAPI attempts to extract the most likely first name.
Requires internet access to contact GenderAPI.io service.
Results are returned as dynamic arrays – make sure adjacent cells are empty.