CSV CHECK

Check ColorMe Customer CSV Errors Before Import

Find column, address, email, and phone issues before importing a ColorMe customer CSV.

Check CSV

＋Choose a CSV fileTap or click to choose. Drag & drop also works on desktop.

🔒 Analysis runs in your browser. The CSV file itself is not uploaded to BlueprintLab.

Validation scope

Checks the 19-column layout, 1,000-row / 15 MB limits, postal code, prefecture code, email, phone and other deterministic fields.

How to use this tool

Check the 19-field ColorMe customer import, 1,000-row limit, postal/email/phone fields and coded values.

Use Try sample to inspect the included sample.
Set ＋ Choose a CSV file Tap or click to choose. Drag & drop also works on desktop..
Use Check CSV to process the input.
Compare the result with your source data and return to the input to make corrections.

＋ Choose a CSV file Tap or click to choose. Drag & drop also works on desktop.: .csv,text/csv

Input and settings example

名前,フリガナ,法人名・会社名,部署名,郵便番号,都道府県,住所(市区町村番地),住所(その他建物名など),メールアドレス,電話番号,FAX番号,携帯番号,性別,誕生日,HPアドレス,メルマガ受信可否,フリー項目１,フリー項目２,フリー項目３
山田太郎,ヤマダタロウ,,,1000001,13,千代田区千代田,1-1,[email protected],0312345678,,09012345678,0,1980/1/1,https://example.com,0,,,

ColorMe customer bulk registration uses 19 fields and up to 1,000 rows

The customer import is a fixed 19-field format with a 1,000-record limit. It is for bulk registration, not bulk customer updates.

This checker validates the shape and count first.

A correct 19-field shape still does not turn this into a customer-update tool. Some blank coded fields receive defaults, so blank does not always mean “leave unspecified.” Review those choices before upload.

Postal code, gender and newsletter preference use coded formats

Postal code is seven ASCII digits; gender uses 0/1/2; newsletter preference uses 0/1. Email and phone fields also have basic syntax rules.

The checker catches clear format mismatches before upload.

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.

Blank does not mean the same thing in every field

ColorMe documents defaults for some optional codes: blank gender becomes male, while blank newsletter preference becomes opt-out.

Those blanks are not treated as generic errors; confirm that the default is intentional.

Customer CSV is a different format from product CSV

The 59/60-column product rules do not apply to the 19-field customer import.

Use the ColorMe product CSV checker for product data.

Go one step deeper

Five checks before a bulk CSV import →