IP Plan Importer
Load existing address allocation records.
IP Plan Importer: inputs and results
Enter an IP address, CIDR prefix, or range. Then check its first and last address below.
Calculated Boundaries & ParametersReady
Key Capabilities
- •100% Client-Side: Zero telemetry or server latency.
- •RFC Compliant: Exact 32-bit and 128-bit integer precision.
- •Quick Copy: Instant access to CIDR, mask, and range bounds.
- •Cross-Platform: Works on desktop, tablet, and mobile browsers.
Related Diagnostics, Generators & UtilitiesAll Tools
IPv4 Reverse DNS Name Generator
Generate address-level reverse lookup names.
Reverse DNS Zone Planner
Identify applicable reverse delegation boundaries.
Bounded IP Address List Generator
Enumerate a selected, limited address range.
Random Address Sampler
Sample addresses within supplied ranges.
Batch Subnet Calculator
Calculate details for multiple prefixes.
IP List Deduplicator
Remove repeated addresses.
How IP Plan Importer Works?
The IP Plan Importer works by reading an existing allocation file, mapping its columns to standard fields, and validating every record before loading it.
Upload or paste the file
Supported inputs include CSV, TSV, JSON, and text pasted from a spreadsheet.
Map the columns
The importer guesses column roles from headers such as "Subnet", "CIDR", "Mask", or "VLAN", and each mapping can be changed.
Validate the records
Every row is checked for valid syntax, alignment, and overlap with other rows.
Load the plan
Valid rows load into the workspace. Invalid rows appear in a separate list with the reason for rejection.
IP Plan Importer Formula
The IP Plan Importer formula is Loaded = Rows that parse AND pass validation, and Import Rate = Loaded ÷ Total Rows × 100 %.
Address and mask columns
CIDR = Address + "/" + popcount(Mask)Joins 2 columns into 1 prefix.
Range columns
CIDR list = rangeToCidr(Start, End)Converts start and end columns.
Validation
syntax ∧ alignment ∧ no overlapPer row.
Import rate
Loaded ÷ Total × 100 %Data quality score.
Worked example: CSV row with separate mask column
Name,Network,Mask,VLAN Finance,10.20.4.0,255.255.254.0,40 → Finance 10.20.4.0/23 VLAN 40 ✓ aligned, no overlap
IP Plan Importer Conversion Table
The IP Plan Importer conversion table maps 9 common source column headers to standard plan fields, with an example value for each.
| Source Header | Mapped Field | Example Input | Stored Value |
|---|---|---|---|
| Subnet / CIDR / Prefix | Prefix | 10.20.4.0/23 | 10.20.4.0/23 |
| Network + Mask | Prefix | 10.20.4.0 + 255.255.254.0 | 10.20.4.0/23 |
| Start IP + End IP | Prefix list | 10.20.6.0 – 10.20.6.127 | 10.20.6.0/25 |
| Gateway / GW | Gateway | 10.20.4.1 | 10.20.4.1 |
| VLAN / VLAN ID | VLAN | 40 | 40 |
| Name / Description | Name | Finance | Finance |
| Site / Location | Site | Karachi HQ | Karachi HQ |
| Owner / Team | Owner | Network team | Network team |
| Status | Status | in use | Active |
What is IP Plan Importer?
The IP Plan Importer is a tool that loads existing address allocation records from spreadsheets and exports into a structured, validated plan.
Most address plans start life in Excel or Google Sheets. Column names, mask formats, and range styles differ from file to file. The importer maps all of them to 1 standard structure and rejects broken rows with clear reasons.
Validation during import catches problems that a spreadsheet never flags: unaligned prefixes, typos in masks, and overlapping allocations.
What are the uses of IP Plan Importer?
There are 4 main uses of the IP Plan Importer, including spreadsheet migration, IPAM onboarding, and data quality checks.
Migrating from spreadsheets
Legacy Excel plans load into a structured format in 1 step.
Onboarding IPAM tools
Imported and validated data feeds tools such as NetBox or phpIPAM.
Checking data quality
The rejected-row list measures how clean a plan really is.
Combining multiple sources
Files from several teams load into 1 plan with overlap checks.