Submit a ticketCall us

ebook60.pngHow to be a Cisco® ASA ace

Our eBook, Thou Shalt Not Pass…I Think?! can help you overcome the challenges of monitoring and managing Cisco ASA firewalls. This eBook is a great read if you’ve been frustrated with monitoring firewalls, managing ACL configs, and troubleshooting VPN connections.

Get your free eBook.

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

Import subnets in IPAM

Table of contents
Created by Daniel Phillipps, last modified by Steven Bansil_ret on Aug 02, 2016

Views: 1,356 Votes: 2 Revisions: 10


This article provides steps on how to format your spreadsheet and how to technically calculate the subnet values that should be used.


IPAM version 4.x


  1. Go to the Manage Subnets and IP Addresses page.
  2. Click Import a spreadsheet.
  3. If you have not selected to hide it, you will be shown the help screen for Preparing to import a spreadsheet. This screen will provide basic information on what types of spreadsheet are supported (.csv, .xls or .xlsx only) as well as provide you sample sheets you can use to import. You can find the sample import spreadsheets located on your primary poller within this directory: inetpub\SolarWinds\Orion\IPAM\res\samples.
  4. Select the spreadsheet you wish to import from.
  5. Select whether this is a list of IP addresses to import or whether it is a group, supernet or subnet to import, then click Next. Note that importing a spreadsheet with a list of IP addresses will import all the IP information specifically. Importing a group, supernet and subnet will import everything specifically to those only.
  6. Match the columns from IPAM to the columns within the spreadsheet via dropdown button.
  7. Determine whether you wish for IPAM to make the hierarchy or choose to do so at a later date.
  8. Match any Custom fields in IPAM to columns within the spreadsheet.
  9. At this point, it should determine whether the information is clear enough in the spreadsheet to accurately import into IPAM. If in the event that it fails, it will indicate which columns or portions are incorrect. To determine the cause of failure, export the results to spreadsheet to check. The results will be placed in a separate spreadsheet that you will be tasked to save to a location. When you open the spreadsheet, it will have added a Comment inserted into the affected column cells that will indicate why it failed. Make adjustments as needed and re-import.
  10. Import the results into IPAM.

    You can use the subnet calculator to verify if they are correct. If any of them are incorrect, then the entire import will fail. See the link below to use the subnet calculator:


Last modified