Sample error report
A fictional CSV Template V3 file (invented company “Example Toy Co”, invented labs and IDs) checked with the same code that runs on the checker.
5 data rows · 15 errors · 3 warnings · 1 note
| Level | Rule | Row | Column | What to fix |
|---|---|---|---|---|
| error | R07 | 3 | Last Test Date | "2026-08-14": expected MM/DD/CCYY (e.g. 06/20/2025). This looks like an ISO date: Excel probably reformatted the cell. Format the column as Text and retype. |
| error | R09 | 3 | Current Version ID | Product Update is Y, so "Current Version ID" is required. |
| error | R10 | 3 | Lab 1 Citation Codes | "1510 1303" looks like several codes: separate codes with ";". |
| note | A01 | 4 | Product Name (Model) | Contains non-English characters. Not a CPSC CSV rule; confirm with your importer. |
| error | R03 | 4 | Product/Model Description | Value contains a comma. Remove it (e.g. "Example Co, Ltd" -> "Example Co Ltd"). |
| warning | R06 | 4 | Certificate Type | "cpc" differs in letter case from the accepted value "CPC". |
| error | R07 | 4 | Manufacture Date | "13/2025": month must be 01-12. |
| error | R11 | 4 | Lab 1 Citation Codes | "1252.3(a)(1)" is a testing exclusion code: put it under a lab of type NOL. |
| error | R12 | 4 | Lab 1 Alternate ID | Lab 1 is LAB, so "Lab 1 Alternate ID" or "Lab 1 GLN" is required. |
| error | R15 | 4 | SKU | Primary Product ID Type is SKU, so leave the "SKU" column empty (the ID is already in Primary Product ID). |
| error | R04 | 5 | New Version ID | "New Version ID" is required and blank. |
| error | R08 | 5 | Primary Product ID | 23 characters; the limit is 19. |
| error | R11 | 5 | Lab 2 Citation Codes | "1303" is a citation code; a NOL lab takes testing exclusion codes only. |
| error | R14 | 5 | POC Alternate ID | Point of Contact is "Other": give "POC Alternate ID" or "POC GLN". |
| warning | R18 | 5 | Lab 1 Is Component? | "1": use True/False or Yes/No. |
| error | R07 | 6 | Production Start Date | "02/30/2026": not a real calendar date. |
| error | R11 | 6 | Lab 1 Citation Codes | "1999" is not on the CPSC citation code list. |
| warning | R13 | 6 | Manufacturer is new: Manufacturer State/Province, Manufacturer Zip/Postal Code, Manufacturer Phone, Manufacturer Email blank. CPSC asks for full address and contact information. | |
| error | R13 | 6 | Manufacturer Address Line 1 | Manufacturer is new: "Manufacturer Address Line 1" is required. |
Read it like this
- Row is the line number in the CSV file; line 1 is the header row.
- Rule links to the CPSC document section that sets the rule.
- Row 2 is clean: it shows what a passing row looks like.
Have many SKUs or test reports in Korean or Japanese? Request a quote for CSV data preparation.