{"id":4395,"date":"2020-01-15T11:29:38","date_gmt":"2020-01-15T19:29:38","guid":{"rendered":"https:\/\/blogs.infoblox.com\/?p=4395"},"modified":"2025-04-01T12:56:19","modified_gmt":"2025-04-01T19:56:19","slug":"importing-ipam-data-via-csv","status":"publish","type":"post","link":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/","title":{"rendered":"Importing IPAM data via CSV"},"content":{"rendered":"

IPAM DHCP<\/strong><\/a> data can help identify the role or location of a given subnet in the network.\u00a0The data can also be used to organize navigation according to familiar data rather than just a network tree.<\/p>\n

Meta Data is imported as Extensible Attributes. Before importing Comma Separated Value (CSV) data make sure that the Extensible Attributes you want to use are defined.\u00a0 The built-in attributes are all defined as strings.\u00a0 If you wish to create a list from an existing attribute that already is defined you will have to delete it, recreate it and give it new properties.\u00a0 Lists have the benefit of being consistent and the disadvantage of rejecting any deviation.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

This is the format for importing EA data CSV files.\u00a0 Note the \u201cEA-Building\u201d denoting an extensible attribute header called Building.<\/p>\n

The * is required at the end of the second and third columns which are the column headers for address\/netmask.<\/p>\n

The format shown here imports several different networks (rows) with associated Extensible Attributes.<\/p>\n

\"\"<\/p>\n

A CSV file can be created in Excel saving the file as CSV.\u00a0 The format above is required to make import work properly.\u00a0 Note that many networks can be imported at the same time and multiple extensible attributes can be attached to those networks.<\/p>\n

Good practice for uploading files is to make a backup copy of your grid before uploading a massive file so you can always restore from your working backup if you need to.<\/p>\n

To import your own similar file go to Data Management\/IPAM\/(toolbar on the right) CSV Import.<\/p>\n

The wizard gives options on how to import the data into a Universal DDI<\/strong><\/a> platform, such as Add, Overwrite, and Merge.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

In the Wizard select your File.<\/p>\n

Upload the file and import.<\/p>\n

You hit start to begin then save and close if your import has no errors.<\/p>\n

If errors occur you will download an error file, which will tell you what lines failed.\u00a0 This may take a few tries if your CSV is not correctly formatted.<\/p>\n

\"\"<\/p>\n

You can edit Extensible Attributes in the GUI.\u00a0 Double click in the bottom right corner of the white box containing a network such as this 10.0.4.0\/24.\u00a0For organizations using BloxOne DDI<\/strong><\/a>, these configurations provide scalable and efficient IP address management.<\/p>\n

Multi-select edit to add attributes to multiple networks in the GUI. Select several networks by clicking the white box to the left of the network.\u00a0 Extensible Attributes shows up on the tool bar to the right.\u00a0 You can give any number of networks the same City, Building etc. with this selection.<\/p>\n

\"\"<\/p>\n

Smart Folders are a navigation tool.\u00a0 Notice the Smart Folder navigation on the left.\u00a0 The Buildings Folder is open showing how it works. IPAM IP Address Management<\/strong><\/a> smart folders make it possible to navigate by extensible attributes rather than the network tree, which is the default.<\/p>\n

Global Smart folders can be made available to other users of the GUI, an essential feature for managing complex DDI<\/strong><\/a> environments.<\/p>\n

\"\"<\/p>\n

On the right is the edit for this Smart Folder showing how it was built.<\/p>\n

It looks for IPv4 networks with EA US then sorts them by State, City and Building.<\/p>\n","protected":false},"excerpt":{"rendered":"

IPAM DHCP data can help identify the role or location of a given subnet in the network.\u00a0The data can also be used to organize navigation according to familiar data rather than just a network tree. Meta Data is imported as Extensible Attributes. Before importing Comma Separated Value (CSV) data make sure that the Extensible Attributes […]<\/p>\n","protected":false},"author":330,"featured_media":2617,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[3],"tags":[51],"class_list":{"0":"post-4395","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-community","8":"tag-ipam","9":"entry"},"acf":[],"yoast_head":"\nImporting IPAM data via CSV<\/title>\n<meta name=\"description\" content=\"Users are able to import data from IPAM through Comma Separated Value (CSV) data. Learn how this data can be used to organize navigation within your network.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing IPAM data via CSV\" \/>\n<meta property=\"og:description\" content=\"Users are able to import data from IPAM through Comma Separated Value (CSV) data. Learn how this data can be used to organize navigation within your network.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/\" \/>\n<meta property=\"og:site_name\" content=\"Infoblox Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-15T19:29:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-01T19:56:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.infoblox.com\/blog\/wp-content\/uploads\/for-company-blogs_edited-1-3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"660\" \/>\n\t<meta property=\"og:image:height\" content=\"454\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Robert Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Robert Davis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/\"},\"author\":{\"name\":\"Robert Davis\",\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/#\\\/schema\\\/person\\\/f26581b0d119aa470a310023da6971f3\"},\"headline\":\"Importing IPAM data via CSV\",\"datePublished\":\"2020-01-15T19:29:38+00:00\",\"dateModified\":\"2025-04-01T19:56:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/\"},\"wordCount\":528,\"publisher\":{\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/wp-content\\\/uploads\\\/for-company-blogs_edited-1-3.jpg\",\"keywords\":[\"IPAM\"],\"articleSection\":[\"Community\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/\",\"url\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/\",\"name\":\"Importing IPAM data via CSV\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/wp-content\\\/uploads\\\/for-company-blogs_edited-1-3.jpg\",\"datePublished\":\"2020-01-15T19:29:38+00:00\",\"dateModified\":\"2025-04-01T19:56:19+00:00\",\"description\":\"Users are able to import data from IPAM through Comma Separated Value (CSV) data. Learn how this data can be used to organize navigation within your network.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/wp-content\\\/uploads\\\/for-company-blogs_edited-1-3.jpg\",\"contentUrl\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/wp-content\\\/uploads\\\/for-company-blogs_edited-1-3.jpg\",\"width\":660,\"height\":454,\"caption\":\"Network Automation? We\u00e4\u00f3\u00bbve Got an App for That\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/community\\\/importing-ipam-data-via-csv\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Community\",\"item\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/category\\\/community\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Importing IPAM data via CSV\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/\",\"name\":\"infoblox.com\\\/blog\\\/\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/#organization\",\"name\":\"Infoblox\",\"url\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/wp-content\\\/uploads\\\/infoblox-logo-2.svg\",\"contentUrl\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/wp-content\\\/uploads\\\/infoblox-logo-2.svg\",\"width\":137,\"height\":30,\"caption\":\"Infoblox\"},\"image\":{\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/#\\\/schema\\\/person\\\/f26581b0d119aa470a310023da6971f3\",\"name\":\"Robert Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/blogs.infoblox.com\\\/wp-content\\\/uploads\\\/avatar_user_330_1578334371-96x96.jpg\",\"url\":\"https:\\\/\\\/blogs.infoblox.com\\\/wp-content\\\/uploads\\\/avatar_user_330_1578334371-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/blogs.infoblox.com\\\/wp-content\\\/uploads\\\/avatar_user_330_1578334371-96x96.jpg\",\"caption\":\"Robert Davis\"},\"description\":\"Robert has been with Infoblox as an Engineer for the past twelve years. He is currently a Principal Systems Engineer. He lives in Denver, CO and supports the Rocky Mountain States.\",\"url\":\"https:\\\/\\\/www.infoblox.com\\\/blog\\\/author\\\/robert-davis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Importing IPAM data via CSV","description":"Users are able to import data from IPAM through Comma Separated Value (CSV) data. Learn how this data can be used to organize navigation within your network.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/","og_locale":"en_US","og_type":"article","og_title":"Importing IPAM data via CSV","og_description":"Users are able to import data from IPAM through Comma Separated Value (CSV) data. Learn how this data can be used to organize navigation within your network.","og_url":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/","og_site_name":"Infoblox Blog","article_published_time":"2020-01-15T19:29:38+00:00","article_modified_time":"2025-04-01T19:56:19+00:00","og_image":[{"width":660,"height":454,"url":"https:\/\/www.infoblox.com\/blog\/wp-content\/uploads\/for-company-blogs_edited-1-3.jpg","type":"image\/jpeg"}],"author":"Robert Davis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Robert Davis","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/#article","isPartOf":{"@id":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/"},"author":{"name":"Robert Davis","@id":"https:\/\/www.infoblox.com\/blog\/#\/schema\/person\/f26581b0d119aa470a310023da6971f3"},"headline":"Importing IPAM data via CSV","datePublished":"2020-01-15T19:29:38+00:00","dateModified":"2025-04-01T19:56:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/"},"wordCount":528,"publisher":{"@id":"https:\/\/www.infoblox.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/#primaryimage"},"thumbnailUrl":"https:\/\/www.infoblox.com\/blog\/wp-content\/uploads\/for-company-blogs_edited-1-3.jpg","keywords":["IPAM"],"articleSection":["Community"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/","url":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/","name":"Importing IPAM data via CSV","isPartOf":{"@id":"https:\/\/www.infoblox.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/#primaryimage"},"image":{"@id":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/#primaryimage"},"thumbnailUrl":"https:\/\/www.infoblox.com\/blog\/wp-content\/uploads\/for-company-blogs_edited-1-3.jpg","datePublished":"2020-01-15T19:29:38+00:00","dateModified":"2025-04-01T19:56:19+00:00","description":"Users are able to import data from IPAM through Comma Separated Value (CSV) data. Learn how this data can be used to organize navigation within your network.","breadcrumb":{"@id":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/#primaryimage","url":"https:\/\/www.infoblox.com\/blog\/wp-content\/uploads\/for-company-blogs_edited-1-3.jpg","contentUrl":"https:\/\/www.infoblox.com\/blog\/wp-content\/uploads\/for-company-blogs_edited-1-3.jpg","width":660,"height":454,"caption":"Network Automation? We\u00e4\u00f3\u00bbve Got an App for That"},{"@type":"BreadcrumbList","@id":"https:\/\/www.infoblox.com\/blog\/community\/importing-ipam-data-via-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.infoblox.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Community","item":"https:\/\/www.infoblox.com\/blog\/category\/community\/"},{"@type":"ListItem","position":3,"name":"Importing IPAM data via CSV"}]},{"@type":"WebSite","@id":"https:\/\/www.infoblox.com\/blog\/#website","url":"https:\/\/www.infoblox.com\/blog\/","name":"infoblox.com\/blog\/","description":"","publisher":{"@id":"https:\/\/www.infoblox.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.infoblox.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.infoblox.com\/blog\/#organization","name":"Infoblox","url":"https:\/\/www.infoblox.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.infoblox.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.infoblox.com\/blog\/wp-content\/uploads\/infoblox-logo-2.svg","contentUrl":"https:\/\/www.infoblox.com\/blog\/wp-content\/uploads\/infoblox-logo-2.svg","width":137,"height":30,"caption":"Infoblox"},"image":{"@id":"https:\/\/www.infoblox.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.infoblox.com\/blog\/#\/schema\/person\/f26581b0d119aa470a310023da6971f3","name":"Robert Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogs.infoblox.com\/wp-content\/uploads\/avatar_user_330_1578334371-96x96.jpg","url":"https:\/\/blogs.infoblox.com\/wp-content\/uploads\/avatar_user_330_1578334371-96x96.jpg","contentUrl":"https:\/\/blogs.infoblox.com\/wp-content\/uploads\/avatar_user_330_1578334371-96x96.jpg","caption":"Robert Davis"},"description":"Robert has been with Infoblox as an Engineer for the past twelve years. He is currently a Principal Systems Engineer. He lives in Denver, CO and supports the Rocky Mountain States.","url":"https:\/\/www.infoblox.com\/blog\/author\/robert-davis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/posts\/4395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/users\/330"}],"replies":[{"embeddable":true,"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/comments?post=4395"}],"version-history":[{"count":8,"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/posts\/4395\/revisions"}],"predecessor-version":[{"id":11323,"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/posts\/4395\/revisions\/11323"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/media\/2617"}],"wp:attachment":[{"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/media?parent=4395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/categories?post=4395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.infoblox.com\/blog\/wp-json\/wp\/v2\/tags?post=4395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}