Spreadsheet templates
CSV templates for teams that maintain product data in a spreadsheet, and how a row becomes a record.
Not every brand has a PIM system. The spreadsheet templates let a team maintain records in Excel, Numbers or LibreOffice and turn them into records of version 0.2. The templates are a convenience: the normative form of a record is JSON, defined by the JSON Schemas.
| Template | Content | Columns |
|---|---|---|
| Strollers | All blocks and the stroller profile, filled with the stroller example. | 152 |
| Car seats | Core, compliance, media, compatibility and the car seat profile. | 108 |
| Other products (MUST fields only) | The fields every record needs, for categories without a profile yet. | 23 |
Each template contains one example row – the fictitious products from the examples. Overwrite it with your own product and add one row per product variant.
How a row becomes a record
- One row per record. Each row describes one product variant with its own GTIN.
- Column headers are field paths.
brand.nameis the fieldnameinsidebrand,title.enis the English title. - Lists of objects are numbered.
compliance.warnings[0].text.enis the English text of the first warning,media.images[1].urlthe address of the second image. Add columns for more items as needed. - Lists of plain values share one cell. Separate the values with
|, for exampleEU|CHincompliance.markets. - Empty cells are left out. Delete the columns you do not need or leave them empty.
- Numbers and yes/no values are converted using the schemas. A decimal comma is accepted (
6,9), and yes/no values can be written asyes,no,trueorfalse.
The templates use a semicolon as separator and UTF-8 encoding, so they open correctly in spreadsheet programs with European settings. Files saved with a comma or tab as separator work as well.
Checking a sheet
Paste the CSV text or open the file in the validator. It converts each row into a record and checks it against the schemas – in your browser, without uploading anything. Show as JSON turns the row into the record that you can pass on.
Dates and GTINs in spreadsheets
Spreadsheet programs like to change values. Format GTIN columns as text, so leading zeros and long numbers are kept, and write dates as YYYY-MM-DD.