Add Products (P) via Excel Import
With the Excel template we provide, many products can be imported into the system at the same time.
1. Click on "Products" in the sidebar if it has already been added to your favorites, or on the "Products" tile visible in the Content Management on the Dashboard. You can learn how to add favorites here.
![](https://dytab.github.io/user-manual/add-products-via-excel-import/navigate-to-product-collection-en.png)
2. Click on "Import".
![](https://dytab.github.io/user-manual/add-products-via-excel-import/click-import-in-product-table-en.png)
3. Select the file you want to import.
![](https://dytab.github.io/user-manual/add-products-via-excel-import/click-file-upload-button-en.png)
4. After you have selected the file press the button "Upload file".
![](https://dytab.github.io/user-manual/add-products-via-excel-import/click-on-upload-confirmation-en.png)
5. meddevo now shows all Excel column names and automatically assigns the fields of the same name from meddevo. Correct the assignment if necessary. Fields/information that should not be imported can be ignored by clicking on the "x" in the dropdown or selection.
Finally, we define the "Unique identifier" and select Name here. This means that a product that already exists with the same name will not be imported if the name already exists in the "Products" collection. If the name exists, the entry is updated when new information is added.
When everything is done, click on "Import". If something does not fit or the "Unique identifier" is not set, an error message will appear as a hint.
![](https://dytab.github.io/user-manual/add-products-via-excel-import/add-unique-identifier-en.png)
6. All imported products appear in the "Products" collection.
![](https://dytab.github.io/user-manual/add-products-via-excel-import/imported-products-in-table-en.png)
7. Of course you can import all other information iteratively in this way.