IP GEOLOCATION LOOKUP SCRIPT (Node.js)

DESCRIPTION

This script reads a CSV file containing IP addresses and retrieves their geolocation information using the free ip-api.com batch API.

It processes IPs in batches for fast performance and saves the results into a new CSV file.

Works with 100s or 1000s of IP addresses efficiently.

REQUIREMENTS

You must have installed:

• Node.js (version 16 or higher)
Download: https://nodejs.org

Check installation:

node -v

PROJECT SETUP

Step 1 — Create project folder

mkdir ip-geo-lookup
cd ip-geo-lookup

Step 2 — Initialize Node project

npm init -y

Step 3 — Install required packages

npm install axios csv-parser json2csv

Step 4 — Edit package.json

Open package.json and add:

"type": "module"

Example:

{
"name": "ip-geo-lookup",
"version": "1.0.0",
"type": "module"
}

FILE STRUCTURE

ip-geo-lookup/
│
├── input.csv (your IP list)
├── lookup.js (main script)
├── package.json
├── node_modules/
└── output.csv (generated after running)

INPUT FILE FORMAT

Your input.csv must look like:

tracking_id,ip,referrer
tracking_123,8.8.8.8,facebook
tracking_456,1.1.1.1,google

IMPORTANT:
• File name must be: input.csv
• Column name must be: ip

HOW TO RUN SCRIPT

Run this command in terminal:

node lookup.js

OUTPUT

After running, a new file will be created:

output.csv

This file will contain:

• tracking_id
• ip
• referrer
• country
• region
• city
• isp
• latitude
• longitude

Example output:

tracking_id,ip,referrer,country,region,city,isp,lat,lon
tracking_123,8.8.8.8,facebook,United States,California,Mountain View,Google LLC,37.4056,-122.0775

PERFORMANCE

Approximate speed:

• 800 IPs → 1 to 2 minutes
• 2000 IPs → 3 to 5 minutes

API USED

This script uses the free API:

http://ip-api.com

No API key required.

NOTES

• Do not rename input.csv unless you update the script.
• Do not exceed very large batch sizes.
• Internet connection required.
• Output file will overwrite existing output.csv

AUTHOR

Created for batch IP geolocation lookup using Node.js

sahilbakoru/IP-GEOLOCATION-LOOKUP-SCRIPT