A simple Python script that can perform bulk IP-to-location lookups using an IP geolocation API

Here’s a simple Python script that can perform bulk IP-to-location lookups using an IP geolocation API. There are several free and paid APIs available, such as ipinfo.io, ipstack.com, or ip-api.com. For this example, I'll use ip-api.com, which offers a free tier for basic usage.

* ipaddr.txt

85.85.227.229
189.219.66.194
120.242.208.145
88.17.83.198
115.178.67.202
47.93.27.106
67.218.240.154
151.82.84.55

* bulk_ip_lookup.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
# E:\Programs\Python\Python312\python.exe -m pip install requests

import requests
import csv
import argparse
import logging
import sys

# Configure logging to output to stderr
logging.basicConfig(stream=sys.stderr, level=logging.ERROR, format='%(asctime)s %(levelname)s: %(message)s')

def get_location(ip):
    try:
        response = requests.get(f'http://ip-api.com/json/{ip}')
        response.raise_for_status()  # Raise an HTTPError for bad responses (4xx and 5xx)
        data = response.json()
        if data['status'] == 'success':
            return data['country'], data['regionName'], data['city'], data['isp']
        else:
            logging.error(f"Failed to get location for IP {ip}: {data['message']}")
            return 'N/A', 'N/A', 'N/A', 'N/A'
    except Exception as e:
        logging.exception(f"Exception occurred while getting location for IP {ip}")
        return 'N/A', 'N/A', 'N/A', 'N/A'

def bulk_lookup(ip_generator, output_file):
    with open(output_file, 'w', newline='') as csvfile:
        fieldnames = ['IP', 'Country', 'Region', 'City', 'ISP']
        writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
        
        writer.writeheader()
        for ip in ip_generator:
            country, region, city, isp = get_location(ip)
            writer.writerow({'IP': ip, 'Country': country, 'Region': region, 'City': city, 'ISP': isp})
            print(f'{ip}: {country}, {region}, {city}, {isp}')

def ip_generator(input_file):
    with open(input_file, 'r') as file:
        for line in file:
            ip = line.strip()
            if ip and not ip.startswith('#'):
                yield ip

if __name__ == '__main__':
    parser = argparse.ArgumentParser(description='Bulk IP to location lookup')
    parser.add_argument('input_file', type=str, help='File containing list of IP addresses')
    parser.add_argument('output_file', type=str, help='Output CSV file to store results')

    args = parser.parse_args()

    # Create a generator for IP addresses from the input file
    ips = ip_generator(args.input_file)

    bulk_lookup(ips, args.output_file)

E:\Projects>python bulk_ip_lookup.py ipaddr.txt output.csv
85.85.227.229: Spain, Basque Country, Bilbao, Euskaltel S.A.
189.219.66.194: Mexico, Nuevo León, Monterrey, Television Internacional, S.A. de C.V.
120.242.208.145: China, Guangdong, Guangzhou, China Mobile communications corporation
88.17.83.198: Spain, Valencia, Valencia, Telefonica de Espana SAU
115.178.67.202: South Korea, Seoul, Yongsan-gu, SK Broadband Co Ltd
47.93.27.106: China, Beijing, Beijing, Hangzhou Alibaba Advertising Co
67.218.240.154: Spain, Catalonia, Barcelona, Xtra Telecom S.A
151.82.84.55: Italy, Lombardy, Milan, INFOSTRADA