Use Humanform inside Microsoft Excel

Setup

1. Download Humanform-Excel-Manifest.xml below.
2. Open Excel desktop (Windows or Mac) and create or open a workbook.
3. Go to Insert → Add-ins → Upload My Add-in (on Mac: My Add-ins first, then upload).
4. Select the downloaded manifest file.
5. On the Home tab, open Humanform → Humanform to show the task pane.
6. Paste a key from the dashboard and click Save API key.

Your API key is stored in the add-in on your device. It is not written into workbook cells or embedded in the manifest.

manifest.xml

Download the Office add-in manifest, then upload it in Excel. The add-in loads from Humanform's hosted servers. No local install or developer setup required.

Formulas

Excel requires a namespace prefix for add-in custom functions. Use HUMANFORM.HUMANFORM, not bare HUMANFORM. The function takes six arguments: measurement, gender, age, percentile, country, and unit (mm, cm, or in). It returns the predicted numeric value. Browse supported names on the measurements page and country codes on the countries page.

=HUMANFORM.HUMANFORM("Stature", "Female", 34, 50, "US", "cm")

=HUMANFORM.HUMANFORM(A2, B2, C2, D2, E2, F2)

Each call maps to POST /v1/predict with the same request body as the REST API:

{
  "measurement": "Stature",
  "gender": "Female",
  "age": 34,
  "percentile": 50,
  "country": "US",
  "unit": "cm"
}

Credits and recalculation

Billing is unchanged from the REST API: one successful prediction costs one credit, or uses one free-tier call when you have no paid credits. There is no separate spreadsheet billing model.

Free tier: 10 successful predictions per rolling 24-hour window when you have zero paid credits. Purchase credits in the dashboard or wait for the window to reset.

Recalculation: HUMANFORM.HUMANFORM is not volatile. Excel recalculates it when its arguments change, not on every unrelated edit. Reopening a workbook can sometimes rerun custom functions; the built-in cache avoids duplicate API calls for identical inputs within about 6 hours.

Recommended workflow: build your table with formulas, then copy the result range and use Paste Special → Values when the table is finalized. This removes live formulas and prevents accidental extra calls later.

Use cases

• Sizing tables: fill percentile columns for multiple measurements in one sheet.
• Tolerance stacks: pull population dimensions alongside mechanical tolerances.
• Spec sheets: keep anthropometric targets next to product requirements your team already maintains in Excel.