Measure between two coordinate pairs by the row. =VERVE("distancecalculator", A2, B2, C2, D2) returns miles and kilometers — Google Sheets or Excel.
It's one of 300+ live sources you reach with a single =VERVE()function — served from APIVerve's production data engine, billed at 1 credit per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — these inputs, and the values they land in your sheet.
Have a column of places? Fill =VERVE("distancecalculator", A2, B2, C2, D2) down it to resolve each into structured location data — coordinates, timezone, or region — right in the grid.
Normalize messy, hand-entered locations into consistent values without exporting to another tool and importing the result back.
Feed Calculate Distance's output straight into distance, timezone, or cost math with the spreadsheet functions you already use.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("distancecalculator", A2, B2, C2, D2)Same function, same arguments, same key — in Excel on desktop, the web, or mobile. Drag to fill a whole column.
=VERVE("distancecalculator", A2, B2, C2, D2)Add a field name as the last argument to land just that value in the cell.
=VERVE("distancecalculator", A2, B2, C2, D2, "distanceMiles")=VERVE("distancecalculator", A2, B2, C2, D2, "distanceKm")=VERVE("distancecalculator", A2, B2, C2, D2, "location1")=VERVE("distancecalculator", A2, B2, C2, D2, "location2")=VERVE("distancecalculator", A2, B2, C2, D2, "bearing")=VERVE("distancecalculator", A2, B2, C2, D2, "direction")=VERVE("distancecalculator", A2, B2, C2, D2, "estimatedDriveTime")Everything you need to wire it into a sheet.
