I have a case open currently because I cannot import our IP ranges using the sample spreadsheet that is presented in the UI, has anyone done this successfully and if so can you share the column headers that are required? So far I am not impressed with the SW IPAM offering. No CRUD operations via API calls (REST or SOAP) and then the simple spreadsheet as supplied won't even import; what's the deal?
You can even import an excel sheet which has only the 'IP Address' column, provided you have the specific subnet already existing in IPAM.
In order to import the range of IP addresses, Very first create the corresponding subnet in IPAM.
You can even import the subnets (without IPs) via excel, download the sample excel available in the import screen.