Validate / CPSC eFiling CSV Template V3: every column

CPSC eFiling CSV Template V3: every column

The bulk upload file for CPSC's Product Registry has 83 columns. Twelve must always be present.

The rules that break most files

CSV only. The template is an Excel file, but the Registry accepts only CSV. Save as CSV just before uploading.
No commas inside any value. Company names and addresses are the usual culprits.
Dates as text. Manufacture Date is MM/CCYY. Last Test Date and production dates are MM/DD/CCYY. Set the cells to Text so Excel leaves them alone.
Codes separated by semi-colons. 1215; 1216; 1217
Delete the three example rows that come inside the template.
Do not rename columns. The one allowed change is adding labs: Lab 3 Type, Lab 3 Citation Codes and so on.

Column reference

Required = the column must be present and filled on every row. Contingent = needed only in the situation described. Limit = maximum characters. Source: CPSC User Guide for CSV Upload V3 (December 2025) and the V3 template workbook (library date 2025-12-18).

Filter columns

#	Column header	Status	Accepted values	Limit	Notes
1	Product Update	Required	Y / N		Whether the row is new data (N) or an update to a certificate already in the Registry (Y).
2	Current Version ID	Contingent	Alphanumeric	19	Required if Product Update is Y.
3	New Version ID	Required	Alphanumeric	19	The version identifier you want for the new or updated certificate.
4	Primary Product ID	Required	Alphanumeric	19	The unique identifier for the product. Its type goes in the next column.
5	Primary Product ID Type	Required	GTIN / UPC / SKU / Model Number / Serial Number / Registered Number / Alternate Identifier		The type of the Primary Product ID.
6	GTIN	Optional	Alphanumeric	50	Extra identifier. Leave empty if this type is already the Primary Product ID Type.
7	UPC	Optional	Alphanumeric	50	Extra identifier. Leave empty if this type is already the Primary Product ID Type.
8	SKU	Optional	Alphanumeric	50	Extra identifier. Leave empty if this type is already the Primary Product ID Type.
9	Model Number	Optional	Alphanumeric	50	Extra identifier. Leave empty if this type is already the Primary Product ID Type.
10	Serial Number	Optional	Alphanumeric	50	Extra identifier. Leave empty if this type is already the Primary Product ID Type.
11	Registered Number	Optional	Alphanumeric	50	Extra identifier. Leave empty if this type is already the Primary Product ID Type.
12	Alternate Identifier	Optional	Alphanumeric	50	Extra identifier. Leave empty if this type is already the Primary Product ID Type.
13	Certificate Type	Required	GCC / CPC		GCC = General Certificate of Conformity. CPC = Children's Product Certificate.
14	Product Name (Model)	Required	Alphanumeric	250	The name of the product.
15	Trade/Brand Name	Optional	Free text	50
16	Product/Model Description	Optional	Free text	250
17	Product/Model Color	Optional	Free text	50
18	Product/Model Style	Optional	Free text	50
19	Manufacturer Is New?	Contingent	Y / N		Defaults to N. Y is required to add a manufacturer for the first time.
20	Manufacturer GLN	Required	Alphanumeric	50	Either this or Manufacturer Alternate ID is required on every row. GLN = Global Location Number, a GS1 business identifier.
21	Manufacturer Alternate ID	Required	Alphanumeric	50	Either this or Manufacturer GLN is required on every row. Any string you choose to name the manufacturer.
22	Manufacturer Name	Contingent	Free text	100	Required when Manufacturer Is New? is Y; ignored otherwise.
23	Small Batch Manufacturer CPSC ID	Optional	Alphanumeric		The Small Batch Manufacturer Registry ID, if you have one.
24	Manufacturer Address Line 1	Contingent	Free text	100	Required when Manufacturer Is New? is Y; ignored otherwise.
25	Manufacturer Address Line 2	Contingent	Free text	100	Required when Manufacturer Is New? is Y; ignored otherwise.
26	Manufacturer Apt/Suite Number	Contingent	Free text	10	Required when Manufacturer Is New? is Y; ignored otherwise.
27	Manufacturer City	Contingent	Free text	50	Required when Manufacturer Is New? is Y; ignored otherwise.
28	Manufacturer State/Province	Contingent	Free text	100	Required when Manufacturer Is New? is Y; ignored otherwise.
29	Manufacturer Country	Contingent	Free text	50	Required when Manufacturer Is New? is Y; ignored otherwise.
30	Manufacturer Zip/Postal Code	Contingent	Free text	10	Required when Manufacturer Is New? is Y; ignored otherwise.
31	Manufacturer Phone	Contingent	Free text	50	Required when Manufacturer Is New? is Y; ignored otherwise.
32	Manufacturer Email	Contingent	Free text	50	Required when Manufacturer Is New? is Y; ignored otherwise.
33	Manufacture Date	Required	MM/CCYY		Month and year of manufacture, for example 06/2026.
34	Production Start Date	Optional	MM/DD/CCYY
35	Production End Date	Optional	MM/DD/CCYY
36	Lot Number	Optional	Alphanumeric	20	If given, Lot Number Assigned By is needed too (API Specifications V4).
37	Lot Number Assigned By	Optional	Seller / Manufacturer
38	Lab 1 Type	Required	ITL / LAB / NOL		ITL = a CPSC-accepted laboratory. LAB = any other test lab. NOL = no lab: the Citation Codes column then holds testing exclusion codes.
39	Lab 1 Is New?	Contingent	Y / N		Y is required the first time a lab of type LAB is provided. Defaults to N.
40	Lab 1 CPSC-ID	Contingent	Alphanumeric		Required if the lab type is ITL. The 4-digit ID from CPSC's accepted-lab list.
41	Lab 1 Alternate ID	Contingent	Alphanumeric	50	Alternate ID or GLN is required if the lab type is LAB.
42	Lab 1 GLN	Contingent	Alphanumeric	50	Alternate ID or GLN is required if the lab type is LAB.
43	Lab 1 Name	Contingent	Free text	100	Required when Lab 1 Is New? is Y; ignored otherwise.
44	Lab 1 Address Line 1	Contingent	Free text	100	Required when Lab 1 Is New? is Y; ignored otherwise.
45	Lab 1 Address Line 2	Contingent	Free text	100	Required when Lab 1 Is New? is Y; ignored otherwise.
46	Lab 1 Apt/Suite Number	Contingent	Free text	10	Required when Lab 1 Is New? is Y; ignored otherwise.
47	Lab 1 City	Contingent	Free text	50	Required when Lab 1 Is New? is Y; ignored otherwise.
48	Lab 1 State/Province	Contingent	Free text	100	Required when Lab 1 Is New? is Y; ignored otherwise.
49	Lab 1 Country	Contingent	Free text	50	Required when Lab 1 Is New? is Y; ignored otherwise.
50	Lab 1 Zip/Postal Code	Contingent	Free text	10	Required when Lab 1 Is New? is Y; ignored otherwise.
51	Lab 1 Phone	Contingent	Free text	50	Required when Lab 1 Is New? is Y; ignored otherwise.
52	Lab 1 Email	Contingent	Free text	50	Required when Lab 1 Is New? is Y; ignored otherwise.
53	Lab 1 Citation Codes	Required	CPSC citation codes, separated by semi-colons		At least one citation or testing exclusion code per certificate.
54	Lab 1 Test Report ID	Optional	Alphanumeric	400	Separate several reports with a semi-colon.
55	Lab 1 Test URL	Optional	Free text	400	Separate several with a semi-colon.
56	Lab 1 Test Report Access Key	Optional	Alphanumeric	400	Separate several with a semi-colon.
57	Lab 1 Is Component?	Optional	True / False / Yes / No		Marks test data as covering a component part, not the finished product.
58	Lab 1 Component Description	Optional	Free text	250	What the component is.
59	Lab 2 Type	Contingent	ITL / LAB / NOL		ITL = a CPSC-accepted laboratory. LAB = any other test lab. NOL = no lab: the Citation Codes column then holds testing exclusion codes.
60	Lab 2 Is New?	Contingent	Y / N		Y is required the first time a lab of type LAB is provided. Defaults to N.
61	Lab 2 CPSC-ID	Contingent	Alphanumeric		Required if the lab type is ITL. The 4-digit ID from CPSC's accepted-lab list.
62	Lab 2 Alternate ID	Contingent	Alphanumeric	50	Alternate ID or GLN is required if the lab type is LAB.
63	Lab 2 Citation Codes	Contingent	CPSC citation codes, separated by semi-colons		At least one citation or testing exclusion code per certificate.
64	Lab 2 Test Report ID	Optional	Alphanumeric	400	Separate several reports with a semi-colon.
65	Lab 2 Test URL	Optional	Free text	400	Separate several with a semi-colon.
66	Lab 2 Test Report Access Key	Optional	Alphanumeric	400	Separate several with a semi-colon.
67	Lab 2 Is Component?	Optional	True / False / Yes / No		Marks test data as covering a component part, not the finished product.
68	Lab 2 Component Description	Optional	Free text	250	What the component is.
69	Last Test Date	Required	MM/DD/CCYY		The most recent date of testing for the product.
70	Point of Contact (POC) for Test Result Records	Required	Importer / Manufacturer / Laboratory / Broker / Other		Who keeps the test records. Name, address and contact details are only needed for Other.
71	POC Is New?	Contingent	Y / N		Defaults to N. Y is required to add an "Other" point of contact for the first time.
72	POC Alternate ID	Contingent	Alphanumeric	50	One of POC Alternate ID / POC GLN is required when the point of contact is Other.
73	POC GLN	Contingent	Alphanumeric	50	One of POC Alternate ID / POC GLN is required when the point of contact is Other.
74	POC Name	Contingent	Free text	100	Required when POC Is New? is Y and the point of contact is Other; ignored otherwise.
75	POC Address Line 1	Contingent	Free text	100	Required when POC Is New? is Y and the point of contact is Other; ignored otherwise.
76	POC Address Line 2	Contingent	Free text	100	Required when POC Is New? is Y and the point of contact is Other; ignored otherwise.
77	POC Apt/Suite Number	Contingent	Free text	10	Required when POC Is New? is Y and the point of contact is Other; ignored otherwise.
78	POC City	Contingent	Free text	50	Required when POC Is New? is Y and the point of contact is Other; ignored otherwise.
79	POC State/Province	Contingent	Free text	100	Required when POC Is New? is Y and the point of contact is Other; ignored otherwise.
80	POC Country	Contingent	Free text	50	Required when POC Is New? is Y and the point of contact is Other; ignored otherwise.
81	POC Zip/Postal Code	Contingent	Free text	10	Required when POC Is New? is Y and the point of contact is Other; ignored otherwise.
82	POC Phone	Contingent	Free text	50	Required when POC Is New? is Y and the point of contact is Other; ignored otherwise.
83	POC Email	Contingent	Free text	50	Required when POC Is New? is Y and the point of contact is Other; ignored otherwise.

The guide's own table spells one header "Manufacturer County"; the template file, which is what the Registry reads, says "Manufacturer Country". The template also gives Lab 2 fewer columns than Lab 1: add Lab 2 Name, Lab 2 Address Line 1 and the rest if a second new lab needs them.