Import > export to other netbox with csv files fails #7353

Closed
opened 2025-12-29 20:22:13 +01:00 by adam · 4 comments
Owner

Originally created by @deku-m on GitHub (Dec 14, 2022).

NetBox version

v3.3.9

Python version

3.8

Steps to Reproduce

  1. Using docker netbox, deploy and fill in information.
  2. Click on providers or anything
  3. Go to export > all data
  4. Download csv file
  5. Import on other netbox with csv file upload.
  6. Error "Unexpected column header ""Name" found.

Expected Behavior

The downloaded csv file should be uploaded. The format should be valid but doesnt look like it.

Observed Behavior

Error "Unexpected column header ""Name" found.
See attachments of csv files.
netbox_providers.csv
netbox_regions.csv
netbox_RIRs.csv

Originally created by @deku-m on GitHub (Dec 14, 2022). ### NetBox version v3.3.9 ### Python version 3.8 ### Steps to Reproduce 1. Using docker netbox, deploy and fill in information. 2. Click on providers or anything 3. Go to export > all data 4. Download csv file 5. Import on other netbox with csv file upload. 6. Error "Unexpected column header ""Name" found. ### Expected Behavior The downloaded csv file should be uploaded. The format should be valid but doesnt look like it. ### Observed Behavior Error "Unexpected column header ""Name" found. See attachments of csv files. [netbox_providers.csv](https://github.com/netbox-community/netbox/files/10226636/netbox_providers.csv) [netbox_regions.csv](https://github.com/netbox-community/netbox/files/10226637/netbox_regions.csv) [netbox_RIRs.csv](https://github.com/netbox-community/netbox/files/10226638/netbox_RIRs.csv)
adam closed this issue 2025-12-29 20:22:13 +01:00
Author
Owner

@czarnian commented on GitHub (Dec 14, 2022):

Export and Import features use very different data structure - column names and order, capitalization, etc., which can get very annoying. There are several reasons for that, some were explained in previous issues.

Currently the best approach for data migration is database dump. The process is described in documentation https://docs.netbox.dev/en/stable/administration/replicating-netbox/

@czarnian commented on GitHub (Dec 14, 2022): Export and Import features use very different data structure - column names and order, capitalization, etc., which can get very annoying. There are several reasons for that, some were explained in previous issues. Currently the best approach for data migration is database dump. The process is described in documentation https://docs.netbox.dev/en/stable/administration/replicating-netbox/
Author
Owner

@deku-m commented on GitHub (Dec 14, 2022):

Export and Import features use very different data structure - column names and order, capitalization, etc., which can get very annoying. There are several reasons for that, some were explained in previous issues.

Currently the best approach for data migration is database dump. The process is described in documentation https://docs.netbox.dev/en/stable/administration/replicating-netbox/

Ok thanks for the explaination but if i only want a couple things exported doesnt make sense to dump the entire database for only one or two specific parts

@deku-m commented on GitHub (Dec 14, 2022): > Export and Import features use very different data structure - column names and order, capitalization, etc., which can get very annoying. There are several reasons for that, some were explained in previous issues. > > Currently the best approach for data migration is database dump. The process is described in documentation https://docs.netbox.dev/en/stable/administration/replicating-netbox/ Ok thanks for the explaination but if i only want a couple things exported doesnt make sense to dump the entire database for only one or two specific parts
Author
Owner

@czarnian commented on GitHub (Dec 14, 2022):

Then you will have to manually edit the exported data to fit to the import format, as described on the respective Import pages. Keep in mind that there are dependencies between some item types, so you have to find a proper order of imports.

@czarnian commented on GitHub (Dec 14, 2022): Then you will have to manually edit the exported data to fit to the import format, as described on the respective Import pages. Keep in mind that there are dependencies between some item types, so you have to find a proper order of imports.
Author
Owner
@kkthxbye-code commented on GitHub (Dec 14, 2022): https://github.com/netbox-community/netbox/wiki/Frequently-Asked-Questions#why-cant-i-pass-exported-data-directly-into-the-import-form
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#7353