Add gender data to an Excel file
For a one-time list, upload the workbook and download the enriched result. For a refreshable model, connect Power Query to the API and keep your key outside shared formulas.
100 free credits every day. No card.
Use file upload for one-time enrichment
Upload an XLSX or CSV file in the dashboard, preview the detected columns, select the given-name column and optionally map a country column. The cost is shown before processing begins, so uploading and inspecting a file does not commit credits by surprise.
The result is returned in the same spreadsheet format with derived fields appended. Keep probability, confidence, total_names and source alongside gender. Those fields let you filter weak rows, audit a result and change your acceptance threshold without buying the same lookup again.
Repeated lookup keys are deduplicated during batch processing and joined back to their original rows. This matters in customer exports where a large row count often contains a much smaller set of unique first names.
Prepare the workbook without cleaning away evidence
Put field names in the first row and keep one person per row. A dedicated given-name column produces more reliable input than asking a spreadsheet formula to split every full name. If you have country data, use a separate column containing ISO two-letter codes.
Do not replace accented characters, Arabic text or Asian scripts with ASCII before upload. The matching pipeline performs its own script-aware normalisation, while manual conversion can merge distinct names or create a spelling that belongs to no source.
Empty cells, company names and ambiguous rows should remain in the file. They are part of the quality measurement. After processing, count unknown separately rather than deleting those rows and reporting accuracy only on the easy subset.
Use Power Query for repeatable refreshes
Power Query can call an HTTP JSON API and expand the response into columns. This is appropriate when the workbook is an internal model that refreshes on a controlled machine. It is less appropriate when the file will be broadly shared, because credentials embedded in a query can travel with the workbook.
Keep the API key in a managed parameter or credential store available only to the refresh owner. Send unique name-country pairs in bounded bulk requests, then merge the result table into the original query. Avoid a custom function that makes one web request for every worksheet row.
For scheduled production enrichment, move the same logic to a server-side job. Excel remains a good review and analysis surface, but it should not become the secret store or retry engine for a business-critical integration.
Questions
Which files can I upload?
The batch workflow accepts Excel workbooks and common delimited text formats including CSV.
Does uploading a file immediately spend credits?
No. You preview the file, map columns and see the estimated cost before starting the job.
Can I use an Excel formula?
Power Query is safer for repeatable HTTP work. A cell-by-cell formula can create excessive requests and expose credentials in a shared workbook.
Will the output preserve uncertainty?
Yes. Keep the appended probability, confidence, sample and source fields rather than retaining only the gender label.
Related pages
Enrich names in Google Sheets with the NameGender add-on or Apps Script. Use country hints, preserve confidence fields and protect the API key in shared files.
Upload a CSV or XLSX name list and get a gender column back, with confidence fields, automatic deduplication and the cost shown before charging.
Append a gender column to a customer list, CRM export or lead database, with a confidence field you can filter on and no monthly credit expiry.
A walkthrough for analysts: upload a name list, pick the right columns, read the confidence fields, and decide what to do with the rows that come back empty.
Reading the gender field alone discards everything that says whether to believe it. What each response field means and the thresholds behind confidence.
Check it against your own list
Every number on this page is reproducible with a free key. If your data breaks it, that is the more interesting result.