CSV CHECK
Find column, address, email, and phone issues before importing a ColorMe customer CSV.
🔒 Analysis runs in your browser. The CSV file itself is not uploaded to BlueprintLab.
| Severity | Row | Column | Issue | Value |
|---|
Checks the 19-column layout, 1,000-row / 15 MB limits, postal code, prefecture code, email, phone and other deterministic fields.
Check the 19-field ColorMe customer import, 1,000-row limit, postal/email/phone fields and coded values.
名前,フリガナ,法人名・会社名,部署名,郵便番号,都道府県,住所(市区町村番地),住所(その他建物名など),メールアドレス,電話番号,FAX番号,携帯番号,性別,誕生日,HPアドレス,メルマガ受信可否,フリー項目１,フリー項目２,フリー項目３ 山田太郎,ヤマダタロウ,,,1000001,13,千代田区千代田,1-1,taro@example.com,0312345678,,09012345678,0,1980/1/1,https://example.com,0,,,
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 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.
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.
The 59/60-column product rules do not apply to the 19-field customer import.
Use the ColorMe product CSV checker for product data.