--- title: How to import and export Products using Excel description: "In Configuration->Product: To export the existing Products, click the "Export to Excel" button:  (This is also useful to get the Excel template used here to import Products) Now you have an Excel fi" --- [Skip to content](https://kb.dataintel.dk/how-to-import-and-export-products-using-excel#main-content) English Show submenu for translations [Submit a request](https://kb.dataintel.dk/kb-tickets/new?hsLang=en) ![DIAP-1.png\]](https://kb.dataintel.dk/hs-fs/hubfs/DIAP-1.png?height=41&name=DIAP-1.png) - [Default HubSpot Blog](https://diap-6547305.hs-sites.com/blog) Open main navigation Close main navigation - [Default HubSpot Blog](https://diap-6547305.hs-sites.com/blog) - English Show submenu for translations - [Submit a request](https://kb.dataintel.dk/kb-tickets/new) - Go to Data Intelligence A/S Go to Data Intelligence A/S Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://kb.dataintel.dk/?hsLang=en) 2. [OEE site](https://kb.dataintel.dk/oee-site?hsLang=en) 3. [Guides](https://kb.dataintel.dk/oee-site?hsLang=en#guides) # How to import and export Products using Excel ### Introduction - This guide describes how to import and export Products using Excel In Configuration-\>Product: ![](https://kb.dataintel.dk/hubfs/image-png-Jun-02-2021-11-15-01-06-AM.png) ### Export Products to Excel To export the existing Products, click the "Export to Excel" button:  (This is also useful to get the Excel template used here to import Products) ![](https://kb.dataintel.dk/hubfs/image-png-Mar-30-2022-08-28-50-15-AM.png) Now you have an Excel file with the Products: ![](https://kb.dataintel.dk/hubfs/image-png-Jun-11-2021-11-13-37-17-AM.png) ### Import Products from Excel If you wish to import new Products, first export Products and then just remove all the rows below the first row with the headers from the file: ![](https://kb.dataintel.dk/hubfs/image-png-Jun-11-2021-11-14-48-10-AM.png) And provide the new Product information in the file: ![](https://kb.dataintel.dk/hubfs/image-png-Jun-11-2021-11-22-25-97-AM.png) Use the "Import from Excel" button to import your new Products, and select the Excel file in the file selector: ![](https://kb.dataintel.dk/hubfs/image-png-Mar-30-2022-08-29-37-66-AM.png) ![](https://kb.dataintel.dk/hubfs/image-png-Jun-11-2021-11-24-09-85-AM.png) ![](https://kb.dataintel.dk/hubfs/image-png-Jun-11-2021-11-25-34-14-AM.png) And the Products has now been created: ![](https://kb.dataintel.dk/hubfs/image-png-Mar-30-2022-08-50-32-05-AM.png)     - [DIAP Gateway](https://kb.dataintel.dk/diap-gateway?hsLang=en#main-content) - [Getting Started](https://kb.dataintel.dk/diap-gateway?hsLang=en#getting-started) - [Troubleshooting](https://kb.dataintel.dk/diap-gateway?hsLang=en#troubleshooting) - [Known issues/limitations](https://kb.dataintel.dk/diap-gateway?hsLang=en#known-issues-limitations) - [General](https://kb.dataintel.dk/general?hsLang=en#main-content) - [FAQ](https://kb.dataintel.dk/general?hsLang=en#faq) - [Configuration](https://kb.dataintel.dk/configuration?hsLang=en#main-content) - [FAQ](https://kb.dataintel.dk/configuration?hsLang=en#faq) - [Troubleshooting](https://kb.dataintel.dk/configuration?hsLang=en#troubleshooting) - [Guides](https://kb.dataintel.dk/configuration?hsLang=en#guides) - [Protocols](https://kb.dataintel.dk/configuration?hsLang=en#protocols) - [Live/Real time site](https://kb.dataintel.dk/live-real-time-site?hsLang=en#main-content) - [Getting Started](https://kb.dataintel.dk/live-real-time-site?hsLang=en#getting-started) - [FAQ](https://kb.dataintel.dk/live-real-time-site?hsLang=en#faq) - [Guide](https://kb.dataintel.dk/live-real-time-site?hsLang=en#guide) - [Features](https://kb.dataintel.dk/live-real-time-site?hsLang=en#features) - [OEE site](https://kb.dataintel.dk/oee-site?hsLang=en#main-content) - [Getting Started](https://kb.dataintel.dk/oee-site?hsLang=en#getting-started) - [FAQ](https://kb.dataintel.dk/oee-site?hsLang=en#faq) - [Guides](https://kb.dataintel.dk/oee-site?hsLang=en#guides) - [Configuration](https://kb.dataintel.dk/oee-site?hsLang=en#configuration) - [Remote Access](https://kb.dataintel.dk/remote-access?hsLang=en#main-content) - [Getting Started](https://kb.dataintel.dk/remote-access?hsLang=en#getting-started) - [FAQ](https://kb.dataintel.dk/remote-access?hsLang=en#faq) - [Guides](https://kb.dataintel.dk/remote-access?hsLang=en#guides) - [API](https://kb.dataintel.dk/api?hsLang=en#main-content) - [API](https://kb.dataintel.dk/api?hsLang=en#api) - [Release information](https://kb.dataintel.dk/release-information?hsLang=en#main-content) - [DIAP Release Notes](https://kb.dataintel.dk/release-information?hsLang=en#diap-release-notes) - [Live/Real time site](https://kb.dataintel.dk/release-information?hsLang=en#live-real-time-site) - [OEE site](https://kb.dataintel.dk/release-information?hsLang=en#oee-site) - [Management site](https://kb.dataintel.dk/release-information?hsLang=en#management-site) - [DIAP Gateway](https://kb.dataintel.dk/release-information?hsLang=en#diap-gateway) - [Default HubSpot Blog](https://diap-6547305.hs-sites.com/blog) [![Chill listening crop-3](https://kb.dataintel.dk/hs-fs/hubfs/Sk%C3%A6rmbillede%202021-05-04%20kl.%2017.46.04.png?width=221&height=26&name=Sk%C3%A6rmbillede%202021-05-04%20kl.%2017.46.04.png "Chill listening crop-3")](https://diap.hubspotpagebuilder.com/-temporary-slug-5b226bcb-69c8-45c1-82ff-e060e2d4037d?hsLang=en) Copyright © 2026, Data Intelligence A/S