Google Sheets IntegrationType a formula, get country, city, network, and threat data for any IP. Up to 50,000 IPs in a single lookup.
IP geolocation in Google Sheets works like any other formula. Point =IPGEO at a cell with an IP address, name the field you want, and the cell fills in country, city, timezone, currency, or the network behind that address.
No browser add-on and no coding. Paste a column of IPs, drag the formula down, and the data lands next to each row. The same ipgeolocation.io API runs behind every cell.
Every field is a formula. Each card shows what one returns.
Resolve an IP to its country, city, state, and coordinates to segment or map a list.
Return the AS number and the organization that owns an IP’s network.
Pull the timezone and local currency code for any address.
Flag VPN, proxy, Tor, bot, and cloud IPs and read a threat score per row. Security data is on paid plans via the IP Security API.
Most spreadsheet methods fall apart on long lists. On paid plans, =IPGEO_BULK takes a whole range, sends it in one request, and fills the column in a single pass, up to 50,000 IPs at a time. A 20,000-row export becomes one formula. Dragging a formula down thousands of rows is how you freeze a sheet. One bulk lookup is how you don't.
Setup takes about ten minutes and no coding.
Open Extensions, then Apps Script, paste the script, and save your key once.
In the sheet, type =IPGEO(A2, "location.country_name") and the cell fills in.
Open Extensions, then Apps Script, paste the script, and save your key once.
In the sheet, type =IPGEO(A2, "location.country_name") and the cell fills in.
Every formula and a troubleshooting guide live in the setup guide.
From fraud teams to data analysts, see how teams use IP geolocation inside Google Sheets.
Paste flagged order or login IPs and read VPN, proxy, and threat-score columns beside each and flag the accounts worth a closer look.
Paste flagged order or login IPs and read VPN, proxy, and threat-score columns beside each and flag the accounts worth a closer look.
Enrich an exported log with country, ASN, and VPN columns to spot the addresses that do not belong before escalating an incident.
Add country, city, and timezone columns to IPs from a CRM or ad export to segment audiences and check whether traffic matches the regions a campaign paid for.
Enrich a raw signup or lead list with location and network data, routing accounts by region and catching datacenter IPs that signal a low-intent signup.
Prototype an IP enrichment in Sheets first, confirming the fields and volume you need before committing to a pipeline or warehouse.
The location and security data in these formulas is the same IP intelligence teams at Atlassian, SpaceX, and Verizon build on through the IP Geolocation API. IPv4 and IPv6 are covered on every plan. The same data powers the Zapier, Make, and n8n integrations for workflow automation.
The integration is free to install, and the free plan includes 1,000 lookups a day with no credit card. Location, timezone, currency, and ASN data are included. Bulk lookups and security data like VPN, proxy, and threat score are on paid plans.
Single-cell formulas work on every plan, one IP per formula. On paid plans, =IPGEO_BULK looks up to 50,000 IPs in one formula, sending the whole range in a single request and filling the column at once.
Many spreadsheet geocoding tools are built for street addresses, not IP addresses. This integration is purpose-built for IP enrichment: location, ASN, timezone, and currency, with VPN, threat data, and bulk lookups up to 50,000 IPs on paid plans.
No. If you can copy and paste, you can set this up. You paste a short script into Apps Script once, save your key, then every lookup is a formula like =IPGEO(A2, "location.city"). The setup steps cover the rest.
Your key is stored in Google Apps Script's script properties, not in a spreadsheet cell, so it is not visible in the sheet's data. The sheet uses one script-level key, set from the IPGeolocation.io menu; you can update or clear it anytime.
Unlock the potential of seamless connectivity with our integrations. Discover how our platform effortlessly connects with your favorite tools, third-party platforms, and developer libraries. Simplify your workflow, boost productivity, and open doors to new innovations.
Get the latest in geolocation tech, straight to your inbox.
