Batch IP lookup

Look up many IP locations at once

Paste a pile of IPs from a log, a spreadsheet or a chat. Commas, spaces and line breaks can be mixed. We pick out every address and show where each one is and which network it belongs to.

What bulk IP location lookup does

Turn a list of IPs into a table of country, city, time zone and network in one go. Handy for checking logs, verifying where traffic comes from, or tidying lists of addresses to allow or block.

Paste anything, it finds the IPs
No need to clean up the text: commas, spaces, tabs and line breaks can be mixed. The page picks out the IPv4 and IPv6 addresses, removes duplicates and shows how many it found. You can also click "Fill in an example" to try it.
One row per IP
The table lists country, region, city, time zone, ASN and AS name. ZIP code and coordinates are hidden by default and appear when you tick them under "Columns shown", so a phone screen isn't crowded. Rows that fail say why. Copy the whole table into a spreadsheet or export it as CSV.
Why only 50 IPs at a time
Location data uses a provider allowance shared by all visitors, so the limits are deliberate: 50 IPs per lookup, 3 submissions a minute, and 300 new IPs not yet in our database per visitor each day. Existing database results do not count. For thousands of rows, use a local IP database file.
What it's good for
See which countries and cities a batch of log entries comes from. Check where the exit IPs of a set of servers, proxies or nodes really are. Tidy a list of addresses to allow or block and get each one's ASN and ISP at the same time.

How to look up IP locations in bulk

Paste the IPs straight from your logs, spreadsheet or chat into the text box. Commas, spaces, tabs and line breaks can be mixed. To try it first, click "Fill in an example".
Under the box you'll see "IPs recognized: N". IPv4 and IPv6 are both detected and duplicates count once. Over 50, click "Keep the first 50" and submit the rest in batches.
Click “Look up all.” Each IP is checked against our database first and an existing result is reused. Private and reserved addresses are never sent to the data service, and their rows explain why.
Use "Columns shown" above the table to pick the columns you want. ZIP code and coordinates are off by default. If the table is wider than the screen, scroll sideways.
Click "Copy table" to paste into Excel or another spreadsheet, or "Export CSV". Both include every column, and failed rows have the reason in the last column.

Result columns explained

A column only appears when the data service returned something for it; if none of the IPs in your batch has a value, the column is left out.

IP: The recognized, de-duplicated address, in the order it first appeared in your text. IPv4 and IPv6 can be mixed.
Country / region: The country name in the page language, with its flag. In the CSV this is two columns: country_code (two-letter ISO 3166-1 code such as US) and country (the name).
Region: The first-level administrative area. The data service only provides English names, so they aren't translated.
City: An estimated city. For mobile networks, VPNs and data centers the result may stop at country level or be off by a lot.
ZIP / postal code: Hidden by default; tick it to show. It shows what the data service gives, which can be a rough area. A dash means there is none.
Coordinates: Hidden by default. An estimated city-level point, not a street address, so it can't be used to find a person. In the CSV it's two columns: latitude and longitude.
Time zone: The IANA time zone name when available (for example America/Los_Angeles), otherwise a UTC offset such as UTC-07:00.
ASN and AS name: The autonomous system number (for example AS15169) and name of the network the IP belongs to. For the exact routed prefix, use the IP to ASN tool.
ISP: Only shown when the data service returns it. When there is none, the column is left out, and the isp column in the CSV is empty.
error (CSV only): If an IP is already in our database, its existing result is reused and does not count toward the daily new-IP allowance. A data provider is called only on a database miss.
CSV column order: ip, country_code, country, region, city, zip, latitude, longitude, timezone, asn, as_name, isp, error. The order is fixed, so you can feed it straight into your own scripts.

Bulk IP location FAQ

How do I look up the location of many IPs at once?

Paste the whole text that contains the IPs (IPv4 and IPv6, no cleanup needed), check "IPs recognized" under the box, and click "Look up all". Results appear row by row in a table that you can copy or export as CSV. The limit is 50 per lookup; submit more in batches.

How many IPs can I look up at once, and why not more?

Up to 50 per lookup, 3 submissions a minute, and 300 new IPs not yet in our database per visitor each day. Existing database results do not count. The limits protect the shared data-provider allowance. For thousands of IPs, use a local IP database file.

How accurate are the locations, and what if one looks wrong?

Locations are estimates. Country level is usually reliable; city level can be off, and mobile networks, VPNs, data centers and recently reassigned IPs are off more often, so treat coordinates as a rough area. If a result looks wrong, check which network the IP belongs to with the IP to ASN tool, or cross-check against your own logs. Don't treat it as an exact position.

Why do some rows fail?

Common reasons: the text is not a valid IP; it is a private or reserved address with no public location; today’s allowance for new data-provider lookups has been used; or the data service did not respond. Successful rows are unaffected, and failed rows can be retried later.

Are the IPs I submit stored? Is it safe?

We do not store the query initiator, query count, or per-request history, and results are not linked to your account. Each IP and normalized result is stored once per IP in our database; the IP is sent to IP2Location.io and ipapi.is only on a database miss. Your pasted text is parsed for IPs in your browser, and the rest is not uploaded.

How is this different from the IP lookup and IP to ASN tools?

IP lookup checks one IP at a time and shows the most fields (network, usage type, security status). This tool checks a batch and lists location, time zone, ASN and ISP so you can export it. IP to ASN uses public routing data to say who announces an address, takes up to 100 IPs, and has its own separate allowance.