PREFLIGHT CHECK

ColorMe CSV 59/60-column count checker

Count columns per row and flag ColorMe CSV rows that do not match the documented 59-column registration or 60-column update formats.

Check file

Analysis stays in your browser; the file itself is not sent to BlueprintLab.

What this tool checks

  • Count columns per row and flag ColorMe CSV rows that do not match the documented 59-column registration or 60-column update formats.

What it cannot verify

Live service-side state, account-specific settings, remote server reachability and current master data are not asserted. Always prefer the latest official service information.

How to use this tool

Check every ColorMe product CSV row against the 59-column registration and 60-column update formats.

  1. Use Try sample to inspect the included sample.
  2. Set + Choose CSV file Tap/click to choose. Drag and drop also works on desktop..
  3. Use Check CSV to process the input.
  4. Compare the result with your source data and return to the input to make corrections.
+ Choose CSV file Tap/click to choose. Drag and drop also works on desktop.
.csv,text/csv

Input and settings example

項目1,項目2,項目3,項目4,項目5,項目6,項目7,項目8,項目9,項目10,項目11,項目12,項目13,項目14,項目15,項目16,項目17,項目18,項目19,項目20,項目21,項目22,項目23,項目24,項目25,項目26,項目27,項目28,項目29,項目30,項目31,項目32,項目33,項目34,項目35,項目36,項目37,項目38,項目39,項目40,項目41,項目42,項目43,項目44,項目45,項目46,項目47,項目48,項目49,項目50,項目51,項目52,項目53,項目54,項目55,項目56,項目57,項目58,項目59
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

ColorMe uses 59 fields for bulk registration and 60 for bulk update

Current ColorMe guidance documents 59 fields for new-product bulk registration and 60 for bulk product updates.

This checker counts the header and every data row and reports rows matching neither shape.

When an error appears, look at the first row where the width changes. If every following row shifts, malformed quoting is likely; if only one row differs, a comma or line break in that row is a more likely cause.

A one-column shift can be a quoting problem rather than a missing field

A row with 58 or 61 columns does not always mean someone manually added or removed a column. A comma, line break or quote inside text can split the CSV structure.

Use the comma / line-break / quote checker to inspect that layer.

Treat the result as a preflight check, not a guarantee that the platform will accept the upload. Account state and current admin settings can add conditions that a browser-only checker cannot prove.

Matching 59 or 60 columns does not prove the CSV purpose

Column count alone cannot prove whether the file is the intended registration or update template, nor whether field values are correct.

Compare against the latest template downloaded from the ColorMe admin.

Recheck the actual CSV after saving from a spreadsheet

A sheet can look aligned while CSV serialization changes quoting around commas and embedded line breaks.

Run the checker on the final file you plan to upload.