IP Extractor
Upload a dataset to begin
Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv
Sign in for free for unlimited files, no payment required.
About IP Extractor
Scrape all IPv4 addresses found in a text file or CSV, across every column.
The tool scans every cell of your file with a regular expression tuned to the IPv4 address format, pulling out matches regardless of which column they appear in — including log lines, request headers, or free-text fields pasted into a spreadsheet. Every match is captured into a clean output list, ready to deduplicate or cross-reference against a geolocation or block list.
Category: Transformation & LogicCommon Use Cases
- Pulling every client IP out of a raw access-log export saved as CSV
- Extracting IP addresses from a support ticket or security incident export where they were logged in free text
- Recovering source IPs from a scraped or pasted report before cross-referencing them against a blocklist
Key Features
- Scans all columns and free text, not just dedicated IP fields
- Regex-based matching for standard dotted-decimal IPv4 addresses
- Outputs every match found into a clean, deduplicated list
The IP Extractor tool is compatible with: Server Access Logs, Security Incident Exports, Firewall Logs.
Run Uniqueness afterward on the extracted list to drop duplicate addresses before cross-referencing them elsewhere.
Frequently Asked Questions
No, the current pattern matches standard dotted-decimal IPv4 addresses only.
Yes, the pattern only matches groups of digits that form a valid 0-255 octet, so it won't match arbitrary dotted numbers outside that range.
No, it only extracts the addresses as text — cross-referencing them against a geolocation or ownership database is a separate step.
A fast way for support and security teams to pull a clean IP list out of messy log exports.
Read the related guide →