Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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
14:19, 26 May 2017

Tags

Classifications

Public