Turn IP addresses into hostnames by the row. =VERVE("fullyqualifieddomain", A2) returns the FQDN for each IP — 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.
Put your domains in a column and fill =VERVE("fullyqualifieddomain", A2) to pull each one's records or health into the grid — a whole portfolio checked at once.
Add domain intelligence beside your leads so sales or security can sort and prioritize without leaving the sheet.
Let auto-refresh re-check every domain periodically so a monitoring sheet flags changes on its own.
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("fullyqualifieddomain", A2)Same function, same arguments, same key — in Excel on desktop, the web, or mobile. Drag to fill a whole column.
=VERVE("fullyqualifieddomain", A2)Add a field name as the last argument to land just that value in the cell.
=VERVE("fullyqualifieddomain", A2, "ip")=VERVE("fullyqualifieddomain", A2, "baseDomain")=VERVE("fullyqualifieddomain", A2, "fqdn")=VERVE("fullyqualifieddomain", A2, "tld")=VERVE("fullyqualifieddomain", A2, "subdomain")=VERVE("fullyqualifieddomain", A2, "domainLevels")=VERVE("fullyqualifieddomain", A2, "detected")Everything you need to wire it into a sheet.
