.png){kind=logo}
Exporting your Products to Excel
Exporting products to Excel is useful for managing large amounts of data quickly. While spreadsheets lack the advanced relations and data entry features of the EandoX app, they can sometimes be more efficient for basic edits and updates.
💡 Exporting as an empty spreadsheet template
Another common use of the Export feature is to generate an empty export spreadsheet template. A template makes it easy to bulk-import data into EandoX from external sources.
To generate an empty template you will be using the Add extra components and Add extra materials fields in the export sidepanel.
Read more about these fields in the "Exporting data" table further down in this article.
Read more about importing data here.
Exporting data
Navigate to the Products page in the left navigation menu and click the Export button in the top right corner.
This will open a sidepanel where you can select the entities you want to export.
It has the following options:
| Field name | Field description |
|---|---|
| Add extra components | Creates additional empty component fields in the export file, beyond the currently selected entities. |
| Add extra materials | Creates additional empty material fields in the export file, beyond those currently attached to your selected component entities. |
| Include transport | Whether or not to include the transport information in the export. |
| Include recycled content | Whether or not to include the recycled content information in the export. |
| Include CAS/EC | Whether or not to include the CAS/EC information in the export. |
| Include custom fields | Whether or not to include the custom fields in the export. |
Select the entities you want to export and click the Export button. This will start generating an export file.
💡 Dependencies
Selecting an entity that is linked to another entity will automatically include both of the entities in the exported file.
For example, if you select a Pillowcase that has the Cotton material linked to it, the item Cotton will automatically be selected (and cannot be deselected). The export will include data for both the Pillowcase product and the Cotton material.
When you select an entity, all its linked materials and components will be automatically included in the export.
For example, if you select a Pillowcase product that uses Cotton as a material, the item Cotton will automatically be selected. You cannot exclude the cotton data since it's required for the pillowcase. The export will include data for both the Pillowcase product and the Cotton material.
When the file is ready, the Export buttons label will change to Download xlsx. Click it to download the file. After the file has been downloaded, you can open it in a spreadsheet editor and start modifying the data.
Spreadsheet structure
Numbers file type (macOS) is not supported
Due to limitations in the macOS Numbers app, it is recommended to edit the file only with Microsoft Excel or Google Sheets.
The exported Excel file will contain three sheets:
- Instructions
- Products
- Components
— Products/components sheet
The Products and Components sheets include the same columns and data. The only difference is their entity type.
They have the following columns:
| Column name | Column description |
|---|---|
| Id | An internal id used by EandoX. This should never be modified. |
| Name | The name of the product. |
| Art nr | Your internal article number for the product. |
| Unit | The unit the product is measured in. Includes all units that are supported by EandoX. |
| Folder | The folder that the product is organized in in EandoX. |
| Factory [A-Z] | The factory that the product is made in. Populated by the factories that you have added to EandoX. |
| Share | How many percent of the product is manufactured in the factory [A-Z]. |
| Pack Comp [A-Z] | The packaging used for component [A-Z]. |
| Amount | How many units of the packaging [A-Z] are used for the product. |
| Component [A-Z] | The component that is used in the product. |
| Amount | How many units of the component [A-Z] are used in the product. |
| Transport |
The transport that is used for the component [A-Z]. The transport is defined as a comma separated string of three numbers, representing truck, boat and train in kilometers. The value |
| Material [A-Z] | The material that is used in the product. Populated with all materials that are available in EandoX |
| Weight | The weight of the material [A-Z] in KG. |
| Transport |
The transport that is used for the material [A-Z]. The transport is defined as a comma separated string of three numbers, representing truck, boat and train in kilometers. The value |