Import IP address spreadsheet view

You can import IP Addresses & Subnets from an external source, such as an Excel spreadsheet. The import of existing IP Addresses and their details can be performed by uploading a spreadsheet in Excel, CSV, and Tab-delimited text files. Column Headers are not required; however, if present, they must be on the first row. You can import IP Addresses before creating subnets. Any existing IP Addresses will be updated.

IPAM includes an import wizard that guides you through the process of importing IP Addresses and Subnets.

1. Click IP Address Manager in the menu bar.
2. Click Import > Import Spreadsheet.
3. Click Next.
4. Click Browse.
5. Select the content of file included in the import.

   

6. For each Database Column from the import file, select a corresponding Spreadsheet Column name to use in the IPAM table of your database.
7. Click Next.
8. Select which optional columns you want to import.

   

9. Select the option which tells IPAM how to handle the imported content and click Next.

   

10. If the imported spreadsheet columns contain custom fields, determine which fields you would like to import by clicking Add custom field.

    

11. Click Save to add the custom field.
12. Click Next.
13. Confirm the selections for import, and click Confirm.

    

14. Click Done.