Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > IP Address Manager (IPAM) > IPAM Getting Started Guide > Populate IPAM with IP addresses > Import IP addresses from an excel spreadsheet

Import IP addresses from an excel spreadsheet

Table of contents
No headers

Updated: June 1, 2017

Manually import IP4 and IP6 groups, supernets, and IPV6 global prefixes, including subnet tree hierarchy, from a spreadsheet and determine where the IP address information is imported.

Imported data maintains user delegation permissions.

Before you import your spreadsheet, know the following:

  • The import may overwrite existing subnets of the same address spaces.
  • Only a .csv, .xls, or .xlsx file can be imported.
  • If your .xls or .xlsx files has multiple worksheets, the header rows must be identical for each worksheet.

This example imports an .xls file to the EAST0100: NOC node.

  1. Click My Dashboards > Manage Subnets & IP Addresses.
  2. Select a subnet.
  3. Click Import > Import Spreadsheet.

    File:Success_Center/Reusable_content_-_InfoDev/IPAM_Getting_Started_Guide/IPAM_Getting_Started_Guide/0020-Populate_IPAM_with_IP_addresses/0030-Import_IP_addresses_from_an_excel_spreadsheet/Click_Import_Spreadsheet_GSG.png

  4. On the Preparing to import a spreadsheet page, click Next.

    To prevent import errors, SolarWinds strongly recommends that you download the example spreadsheet for adding IP Addresses and ensure your file columns match the example columns.

  5. Click Browse to select a file, and click Next.

    File:Success_Center/Reusable_content_-_InfoDev/IPAM_Getting_Started_Guide/IPAM_Getting_Started_Guide/0020-Populate_IPAM_with_IP_addresses/0030-Import_IP_addresses_from_an_excel_spreadsheet/Browse_to_spreadsheet_GSG.png

  6. On the IP Address column matching page, click Next.

    IPAM detects the columns in your spreadsheet and automatically populates the fields. This example only imports IP addresses.

    File:Success_Center/Reusable_content_-_InfoDev/IPAM_Getting_Started_Guide/IPAM_Getting_Started_Guide/0020-Populate_IPAM_with_IP_addresses/0030-Import_IP_addresses_from_an_excel_spreadsheet/Spreadsheet_column_detection_GSG.png

  7. On the Subnet Column matching page, select optional Subnet columns to import and select an option that tells IPAM how to handle the imported content. This example selects IPAM will automatically create subnet hierarchy based on information provided.

    File:Success_Center/Reusable_content_-_InfoDev/IPAM_Getting_Started_Guide/IPAM_Getting_Started_Guide/0020-Populate_IPAM_with_IP_addresses/0030-Import_IP_addresses_from_an_excel_spreadsheet/Select_optional_subnet_columns_GSG.png

  8. Click Next.
  9. Confirm your selections for import, and click Import.

    File:Success_Center/Reusable_content_-_InfoDev/IPAM_Getting_Started_Guide/IPAM_Getting_Started_Guide/0020-Populate_IPAM_with_IP_addresses/0030-Import_IP_addresses_from_an_excel_spreadsheet/Confirm_excel_import_selection_GSG.png

  10. Review the Import Summary and click Done.
Last modified

Tags

Classifications

Public