ASN Lookup in a Cell in Google Sheets & Excel — =VERVE("asnlookup", A2)

What this pulls

Resolve AS numbers by the row. =VERVE("asnlookup", A2) pulls the organization, handle and country for any ASN down a column — 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.

See it in a cell

A real example — these inputs, and the values they land in your sheet.

asnlookup.xlsxlive

B1fx=VERVE("asnlookup", "AS15169")

Asn

AS15169

Simple

15169

Handle

GOOGLE

Description

Google LLC

Country

Example resultpulled live from APIVerve1 credit / cell

Ways to use it

Turn IDs into detail

Fill =VERVE("asnlookup", A2) down a column of identifiers and expand each into full, structured detail — no manual lookups.

Enrich a table in place

Add ASN Lookup in a Cell beside your existing rows to append the fields you were missing, right where the data lives.

Keep it current

Let auto-refresh re-resolve the column on a schedule so the enriched data never goes stale.

Use it in your sheet

The same function works in both apps — install once, sign in with your key, and type it into any cell.

Google SheetsAdd-on

Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.

=VERVE("asnlookup", A2)

Microsoft ExcelAdd-in

Same function, same arguments, same key — in Excel on desktop, the web, or mobile. Drag to fill a whole column.

=VERVE("asnlookup", A2)

Fields you can pull

Add a field name as the last argument to land just that value in the cell.

Asn=VERVE("asnlookup", A2, "asn")
Simple=VERVE("asnlookup", A2, "simple")
Handle=VERVE("asnlookup", A2, "handle")
Description=VERVE("asnlookup", A2, "description")
Country=VERVE("asnlookup", A2, "country")

ASN Lookup in a Cell, answered

Everything you need to wire it into a sheet.

How do I pull ASN Lookup in a Cell into a spreadsheet?

Install the VerveSheets add-on, sign in with your key, and type =VERVE("asnlookup", A2) into any cell. The same function works in Google Sheets and Excel — no scripts, no API wiring.

How many credits does each ASN Lookup in a Cell cell cost?

Each resolved cell costs 1 credit. Filling a column of ten rows costs ten times that; a cell only re-bills when it actually refreshes, so a static sheet doesn't keep charging.

Can I fill a whole column at once?

Yes. Reference a range instead of a single cell — e.g. point ASN Lookup in a Cell at A2:A50 — and it returns a value for every row in one call, or just drag =VERVE("asnlookup", A2) down like any spreadsheet function.

Does ASN Lookup in a Cell work in Excel as well as Google Sheets?

Yes. It's the same =VERVE() function with the same arguments and the same key in both — build a sheet in one and it behaves identically in the other.

How current is the data?

ASN Lookup in a Cell is served live from APIVerve's production data engine, and cells recalculate on the refresh cadence you choose — every open, hourly, or every 30 minutes.

Where does the data come from, and what shows on my bill?

VerveSheets runs on APIVerve, our production data engine; ASN Lookup in a Cell is one of 300+ sources on the same key. Invoices and card statements show APIVERVE.

ASN Lookup in a Cell

Turn IDs into detail

Enrich a table in place

Keep it current

ASN Lookup in a Cell, answered

Put ASN Lookup in a Cell in your next spreadsheet. Add the extension, paste the formula, and the cell keeps itself current.

Scaling up?