๐Ÿ“ฅ Data Import & Export

Supported File Formats

Updated 2026-04Essential reading

CSV

Requirements:

  • Row 1 must be column headers
  • Delimiter: comma (not semicolon)
  • Encoding: UTF-8 (save as "CSV UTF-8" in Excel, not "CSV Windows")
  • Maximum file size: 5 MB

If your column names don't match DPP Cloud field names, use the field mapper to translate them automatically.

XLSX (Excel)

Requirements:

  • Sheet 1 is used โ€” additional sheets are ignored
  • Row 1 must be column headers
  • Data starts from row 2
  • Maximum file size: 5 MB
  • Supported: .xlsx only (not .xls)

JSON

Must be a valid JSON array of objects, or a single object. Nested objects are automatically flattened using dot notation:

JSON flattening example

{ "battery": { "weight": 450 } } โ†’ field name: battery.weight
{ "carbon": { "total": 5200 } } โ†’ field name: carbon.total

XML

Valid XML with repeating child elements representing individual passports. DPP Cloud uses fast-xml-parser to extract element names. Nested elements are flattened with dot notation.

GS1 EPCIS XML

GS1 EPCIS 2.0 format is supported for inbound import. DPP Cloud extracts ObjectEvent elements and reads the ilmd section. Auto-mapped fields include: EPC identifiers โ†’ Passport Number, eventTime โ†’ Manufacturing Date.

โ„น๏ธEPCIS is a supply chain event format, not a passport format

Not all Annex XIII fields will be present in a typical EPCIS document. Use it for partial imports and supplement with manual data entry or the field mapper.

Start building your Digital Product Passports

EU Battery Regulation compliance โ€” 18 February 2027 deadline.

Request demo account โ†’