📖 Field Reference

CSV Import Column Reference

Updated 2026-04Essential reading

Every column in the DPP Cloud CSV import template. This reference shows the column name, the DPP Cloud field it maps to, the expected data type, accepted values, an example, and what error you will see if the value is missing or invalid.

How to use this reference

When preparing a CSV for import, match your data to these exact column names. If you cannot rename columns in your spreadsheet, use the data mapper to create a mapping profile instead.

Column names are case-sensitive. battery_category works; Battery_Category does not.

Required columns

These columns must be present and populated in every row, or the row will fail validation.

Column name	Maps to	Data type	Accepted values	Example	Error if missing/invalid
battery_category	Battery category	Text	"EV" or "Industrial" (case-sensitive)	EV	INVALID_CATEGORY: Must be 'EV' or 'Industrial'
product_name	Product name	Text	Any text, max 200 characters	PowerCell EV 100kWh Series 3	REQUIRED_FIELD_MISSING: product_name is required
gtin	GS1 GTIN	Text	Exactly 14 digits, no spaces/hyphens	09501234500003	GTIN_FORMAT_ERROR: Must be 14 digits
passport_level	Passport level	Text	"model", "batch", or "item" (lowercase)	model	INVALID_LEVEL: Must be 'model', 'batch', or 'item'
manufacturer_name	Manufacturer name	Text	Legal entity name, max 200 chars	PowerCell Technologies Ltd	REQUIRED_FIELD_MISSING: manufacturer_name is required
manufacturing_place	Manufacturing place	Text	City, Country format	Shenzhen, China	REQUIRED_FIELD_MISSING: manufacturing_place is required
manufacturing_date	Manufacturing date	Date	YYYY-MM-DD	2026-01-15	INVALID_DATE: Use YYYY-MM-DD format
battery_chemistry	Battery chemistry	Text	NMC, NCA, LFP, LMO, LTO, Other	NMC	INVALID_CHEMISTRY: Must be NMC, NCA, LFP, LMO, LTO, or Other

Identity & origin columns (optional)

Column name	Maps to	Data type	Accepted values	Example
manufacturer_address	Manufacturer address	Text	Free text, max 500 chars	12 Innovation Park, Shenzhen 518057, China
battery_model_number	Battery model number	Text	Alphanumeric, max 100 chars	PC-EV-100-S3
battery_weight_kg	Battery weight (kg)	Number	Positive decimal	450.0
nominal_voltage_v	Nominal voltage (V)	Number	Positive decimal	400.0
rated_capacity_ah	Rated capacity (Ah)	Number	Positive decimal	250.0
rated_capacity_kwh	Rated capacity (kWh)	Number	Positive decimal	100.0

Performance columns (optional)

Column name	Maps to	Data type	Accepted values	Example
energy_density_wh_kg	Energy density gravimetric (Wh/kg)	Number	Positive decimal	222.2
energy_density_wh_l	Energy density volumetric (Wh/L)	Number	Positive decimal	480.0
internal_resistance_mohm	Internal resistance (mΩ)	Number	Positive decimal	1.2
cycle_life	Cycle life (cycles)	Number	Positive integer	1500
expected_lifetime_years	Expected lifetime (years)	Number	Positive integer	8
temp_range_lower_c	Temperature range lower (°C)	Number	Integer (can be negative)	-20
temp_range_upper_c	Temperature range upper (°C)	Number	Integer	45
round_trip_efficiency_pct	Round-trip efficiency (%)	Number	0–100, decimal	95.5

Sustainability columns (optional)

Column name	Maps to	Data type	Accepted values	Example
carbon_footprint_kgco2e	Carbon footprint (kg CO₂e/kWh)	Number	Positive decimal	61.3
carbon_footprint_class	Carbon footprint performance class	Text	A, B, C, D, E	B
lca_methodology	LCA methodology reference	Text	Free text	JRC PEFCR Batteries v1.0
recycled_cobalt_pct	Recycled content — cobalt (%)	Number	0–100, decimal	16.0
recycled_lithium_pct	Recycled content — lithium (%)	Number	0–100, decimal	6.0
recycled_nickel_pct	Recycled content — nickel (%)	Number	0–100, decimal	6.0
recycled_lead_pct	Recycled content — lead (%)	Number	0–100, decimal	85.0
hazardous_substances	Hazardous substances	Text	Substance name(s), semicolon-separated	Cobalt (CAS 7440-48-4)
reach_svhc	REACH SVHC declaration	Text	Yes, No, Not applicable	Yes

Supply chain columns (optional)

Column name	Maps to	Data type	Accepted values	Example
actor_1_name	Supply chain actor 1 name	Text	Legal entity name	Shenzhen Cell Materials Co
actor_1_role	Supply chain actor 1 role	Text	Raw material supplier, Cell manufacturer, Assembler, Recycler	Raw material supplier
actor_1_country	Supply chain actor 1 country	Text	Country name or ISO 3166-1 alpha-2	CN
actor_2_name	Supply chain actor 2 name	Text	Legal entity name	Guangzhou Battery Assembly
actor_2_role	Supply chain actor 2 role	Text	Same as actor_1_role	Assembler
actor_2_country	Supply chain actor 2 country	Text	Country name or ISO code	CN
actor_3_name	Supply chain actor 3 name	Text	Legal entity name	Li-Cycle Holdings Corp
actor_3_role	Supply chain actor 3 role	Text	Same as actor_1_role	Recycler
actor_3_country	Supply chain actor 3 country	Text	Country name or ISO code	CA
due_diligence_url	Due diligence policy URL	URL	Valid URL	https://powercell.com/due-diligence
audit_body	Third-party audit body	Text	Free text	Bureau Veritas
audit_date	Third-party audit date	Date	YYYY-MM-DD	2025-09-10

Notes on CSV formatting

Encoding: UTF-8. If your file contains special characters (é, ü, ñ), ensure your spreadsheet exports as UTF-8 CSV.
Delimiter: Comma. Not semicolon, not tab.
Quoting: If a value contains a comma, wrap it in double quotes.
Empty values: Leave the cell empty. Do not enter "N/A", "null", or "—" — these will cause validation errors on typed fields.
Header row: The first row must contain the column names exactly as listed above. Do not include a title row above the headers.

Annex XIII EV Battery Field Reference

Need more help?

Contact support →

On this page

Share on LinkedIn

Ready to get started?

Request a demo account at dppcloud.co.uk/demo/request

Request demo account

📥 Data Import & Export

Importing Passports from a CSV File

Updated 2026-04

📖 Field Reference