CSV Import & Export

Bulk import subnets and addresses from CSV files, or export your data for reporting and backup.

Exporting Data

IPCraft offers two separate exports: Export Subnets exports your network definitions (CIDRs, folders, VLANs, VRFs, locations, gateways, DNS settings), while Export Addresses exports the individual IP address assignments within those subnets (IPs, hostnames, MACs, statuses, owners). Think of subnets as the containers and addresses as the items inside them.

Export Subnets

Click the Export dropdown in the Subnets toolbar and select Export Subnets. A CSV file will download containing all your subnets with human-readable names for folders, VLANs, VRFs, and locations (not UUIDs).

If you have a folder filter active, only subnets in that folder will be exported.

Subnet export columns:

Column	Description
`network`	CIDR notation (e.g., 10.0.0.0/24)
`name`	Subnet name
`description`	Subnet description
`folder`	Folder name
`vlan`	VLAN number
`vrf`	VRF name
`location`	Location name
`gateway`	Default gateway IP
`dns_primary`	Primary DNS server
`dns_secondary`	Secondary DNS server
`is_pool`	Whether this is an IP pool
`scan_enabled`	Whether scanning is enabled

Export Addresses

You can export addresses in two ways:

Per-subnet: Click the Export button in the address list header when viewing a specific subnet
All addresses: Use the Export Addresses option from the Subnets toolbar dropdown

Address export columns:

Column	Description
`ip`	IP address
`subnet`	Parent subnet CIDR
`hostname`	Hostname or FQDN
`mac_address`	MAC address
`description`	Description
`status`	Status (assigned, reserved, d-dhcp, m-dhcp, gateway)
`owner`	Owner or team
`ptr_record`	PTR (reverse DNS) record

Tip: Exported CSVs use the exact format needed for re-import. You can export, edit in a spreadsheet, and re-import — duplicates will be automatically skipped.

Importing Subnets

Quick Start

Click Import in the Subnets toolbar
Select "Subnets" as the import type
Upload your CSV file (or download a template first)
Review the auto-detected column mapping and adjust if needed
Preview the validated data and fix any errors
Click Import to create the subnets

Required Columns

Only network is required. The network must be in CIDR notation (e.g., 10.0.0.0/24).

Alternatively, you can provide the network address in one column and the subnet mask or prefix length in a separate column. IPCraft will automatically combine them.

Supported CIDR Formats

10.0.0.0/24 — standard CIDR notation (preferred)
Network column 10.0.0.0 + Netmask column 255.255.255.0
Network column 10.0.0.0 + Prefix Length column 24

Optional Columns

Column	Notes
`name`	Subnet name/label
`description`	Free-text description
`folder`	Folder name — auto-created if it doesn't exist
`vlan`	VLAN number (1-4094) — auto-created if it doesn't exist
`vrf`	VRF name — auto-created if it doesn't exist
`location`	Location name — auto-created if it doesn't exist
`gateway`	Default gateway IP address
`dns_primary`	Primary DNS server
`dns_secondary`	Secondary DNS server
`is_pool`	true/false, yes/no, 1/0

Auto-creation: Folders, VLANs, VRFs, and locations referenced in your CSV will be automatically created if they don't already exist. This makes migration from other tools seamless.

Duplicate Handling

If a subnet with the same CIDR in the same VRF already exists, it will be skipped (not errored). This means you can safely re-import the same CSV without creating duplicates.

Importing Addresses

Required Columns

ip — the IP address to assign
subnet — the CIDR of the parent subnet (must already exist in IPCraft)

Important: Subnets must exist before importing addresses. Import your subnets first, then import addresses.

Status Values

IPCraft accepts many common status synonyms and normalizes them automatically:

Your CSV value	Maps to
`active`, `in use`, `used`, `static`, `assigned`	assigned
`reserved`	reserved
`dhcp`, `dynamic`	d-dhcp
`manual dhcp`	m-dhcp
`gateway`, `gw`, `router`	gateway
`free`, `available`, `unused`	Row skipped (don't import empty addresses)

MAC Address Formats

All common MAC address formats are accepted and automatically normalized:

00:11:22:33:44:55 (colon-delimited)
00-11-22-33-44-55 (hyphen-delimited)
0011.2233.4455 (Cisco format)
001122334455 (no delimiters)

Column Name Flexibility

IPCraft automatically detects common column name variations. You don't need to rename your CSV headers to match exactly. For example, all of these will be recognized as the IP address column:

ip, IP Address, ipaddress, ip_addr, host_ip

If auto-detection gets it wrong, you can manually adjust the column mapping in step 2 of the import wizard.

Tips & Troubleshooting

File Requirements

CSV, TSV, or TXT files up to 10MB
First row must be column headers
Maximum 1,000 rows per batch (larger files are automatically chunked)

Plan Limits

Import operations respect your plan's resource limits. If importing would exceed your subnet, address, or folder limit, those rows will show an error. Successfully imported rows are not rolled back — you'll get a partial import with a clear summary of what succeeded and what didn't.

Round-Trip Export/Import

The export format is designed to be directly re-importable. You can export your data, edit it in Excel or Google Sheets, and re-import it. Existing items will be skipped as duplicates, and new items will be created.

Download Templates

Click the "Download template" link in the import dialog to get a ready-made CSV with the correct headers and example data for subnets or addresses.