11 / 28 · Import from a spreadsheet
- 1Welcome to Transpareo1 min 12 s
- 2Your digital product passport0 min 44 s
- 3What your customers see1 min 10 s
- 4The signature check0 min 44 s
- 5The version history1 min 23 s
- 6Campaigns1 min 7 s
- 7Access to protected data1 min 12 s
- 8Access for suppliers1 min 35 s
- 9Opening the Application Manager0 min 39 s
- 10The Application Manager2 min 4 s
- 11Import from a spreadsheet2 min 2 s
- 12Asking suppliers1 min 56 s
- 13Components in one place0 min 36 s
- 14What the passport requires0 min 58 s
- 15One model, many variants0 min 54 s
- 16Documents and certificates0 min 47 s
- 17Tasks1 min 3 s
- 18History and restore0 min 31 s
- 19A batch keeps what was made1 min 57 s
- 20From draft to published0 min 48 s
- 21QR codes and RFID1 min 5 s
- 22Team and permissions1 min 13 s
- 23Lifecycle events1 min 18 s
- 24Scan data0 min 36 s
- 25The import from your systems2 min 40 s
- 26Automation with AI0 min 46 s
- 27Your branding1 min 7 s
- 28Try it for free0 min 31 s
Import products from Excel or CSV
Components and products come into the catalogue from a spreadsheet. Transpareo recognises language and columns, checks every row and links the components itself.
The components come first, so that the products can find them afterwards. The importer matches every column it knows to a property and creates new property types itself; you assign by hand the two columns whose names differ from those in the workspace.
A test run checks every row before anything changes, and if you wish, Transpareo backs up your components first, so the import can be undone. With Import straight away, the products go through in a single pass, and their images land in the media library. The DPP forces digitisation describes why moving on from scattered spreadsheets is the passport’s real opportunity.
But how do more products get into the system? Quickly and easily, from a spreadsheet. First the components, so that the products can find them afterwards.
This spreadsheet is in German. Transpareo recognises the language automatically. The importer matches every column it knows to a property.
Whatever it does not know, it creates. Two columns have different names in our spreadsheet than in the workspace. We assign them to the existing properties by hand.
A test run checks every row before anything changes. Then the import runs. You can have your components backed up automatically, so that the import can be undone.
With “Import straight away”, the products go through in a single pass. Transpareo links their components by itself.
The new products are in the catalogue, with their components.
Images were imported into the media library automatically. The importer created the new property types.
You can assign icons afterwards.
Try it yourself
Open our demo account without signing up and try every step yourself. In your own account the data is yours: try it free for eight days, no credit card.