PREFLIGHT CHECK

Mercari Shops half-width space CSV checker

Find half-width spaces outside product name and description fields, a documented Mercari Shops import error cause.

Check file

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

What this tool checks

  • Find half-width spaces outside product name and description fields, a documented Mercari Shops import error cause.

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

Find half-width ASCII spaces outside product-name and description/detail fields, with row and column context.

  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

商品名,商品説明,商品の状態,配送方法
テスト商品,説明,新品,らくらく便

Some Mercari Shops fields allow spaces while many others do not

Mercari Shops lists half-width spaces outside the product-name and product-detail fields as a common bulk-import error.

This checker skips the name and description/detail fields and reports ASCII spaces in other cells with row and column context.

Leading and trailing spaces are especially easy to miss

Values such as `1 ` or ` SKU001` can look normal in a wide spreadsheet cell even though the underlying text is different.

When an error appears, confirm that the field truly should contain no spaces before editing it.

Putting a field in CSV quotes does not remove the ASCII space inside the field. Quoting protects CSV structure; it does not make a prohibited space acceptable as data.

This checker is specifically about the ASCII space character

It looks for U+0020 half-width spaces. It is not a universal detector for full-width spaces, tabs or every Unicode whitespace character.

Use a broader text inspection when those characters are also a concern.

Code fields have even stricter character rules

Management codes and JAN/GTIN fields accept a restricted character set, so removing spaces is only one part of the validation.

Run the management-code / JAN checker for those fields.