Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > IP Address Manager (IPAM) > IPAM - Knowledgebase Articles > Import subnets in IPAM

Import subnets in IPAM

Table of contents
Created by Daniel Phillipps, last modified by Nigel on Jun 21, 2018

Views: 2,138 Votes: 2 Revisions: 12

Updated: June 22, 2018


This article provides steps on how to  import subnet structure (including subnets, groups, supernets, IPv6 Subnets, IPv6 sites and global prefixes) into IPAM. 


IPAM version 4.x


  1. Create a .csv, .xls, or .xlsx spreadsheet. This needs a column showing the Type (i.e. subnets, groups, supernets, IPv6 Subnets, IPv6 sites and global prefixes) of each entity being imported. This is the only required field. You can also add the following:
    • Address/CIDR
    • Address
    • Mask
    • CIDR
    • Display Name
    • Group Description
    • Scan Interval
    • Node Expunge Interval
    • Retain User Data (Y/N)
    • Transient Period
    • Disable Auto Scanning (Y/N)
    • Disable Neighbor Scanning (Y/N)
    • Neighbor Scan Address
    • Neighbor Scan Interval
    • VLAN
    • Location

    Additional columns can be created and then imported by creating custom fields in step 11.

  2. Go to My Dashboards > IP Addresses > Manage Subnets and IP Addresses.
  3. Click Import > Import spreadsheet.
  4. If you have not selected to hide it, the Preparing to import a spreadsheet is displayed.
    This screen gives links to example spreadsheets for importing IP addresses and Subnets. You can also find these sample import spreadsheets located on your primary poller within the directory: inetpub\SolarWinds\Orion\IPAM\res\samples. Click Next to continue.
  5. Select the spreadsheet you want to import.
  6. Select Group/Supernets/Subnets, and click Next.
  7. Match the IPAM column names to the column names within the spreadsheet using the dropdown buttons.
    Select "[Do not import]" if you do not want to import a field.


  8. Select whether you want IPAM to create the subnet hierarchy from the information provided or to import into a single folder called Subnet/Supernet/Group which you can organize later. Click Next.
  9. The information is now validated and any problems displayed.
  10. If there are problems, the columns or portions are displayed in red. If you need help in determining the problem, export the results to spreadsheet to check. Adjust as needed and re-import.

    A common error is caused by trying to import a blank field when IPAM is expecting Y or N, such as Retain User Data. In this case, select "[Do not import]" from the field dropdown.

    If errors involve IP addresses and CIDRs, you can use a subnet calculator such as that provided by MXToolBox (external link, checked 6/21/18) to verify addresses and CIDRs.

  11. If your spreadsheet has additional columns that you want to add to IPAM, a Custom Fields page is displayed. Here you can click Add Custom Field to add this column as a custom field.

    For more information on custom fields, see Creating and configuring custom fields.

  12. Click Next.
  13. Confirm the fields to import, and click Import.
  14. Go to the Manage Subnets and IP Addresses page to see the result of this import.


Last modified