Check a Shopify product CSV before you import it

Drop your product CSV here and see, line by line, what would make Shopify’s import stop or quietly get your products wrong: a missing Title, options that repeat, text saved in the wrong encoding, broken quotes, image links Shopify cannot fetch.

  • Checks the whole file at once. Errors and warnings by line and column.
  • Stays in your browser. The file is read on your device and never uploaded.

The checker reads your file with JavaScript in this tab. Turn JavaScript on to check a file; the guide below works without it.

What it checks, and what Shopify would do

Each check follows Shopify’s help on product CSV files. Errors stop the import or drop a product; warnings are likely to give you something you did not mean.

Checks on a product CSV
CheckWhat Shopify doesHow to fix it
ColumnsThe current template starts with Title and URL handle; the older one with Handle and Title. Title is the one column a new import needs.Keep the header row as Shopify’s template has it. Do not mix columns from both templates.
Title on the first rowA product’s first row without a Title is not imported (“did not contain product data”).Put the Title on the first row of each product. Variant rows below it may leave it empty.
URL handleRows with the same handle form one product. A handle has letters, numbers and dashes, no spaces.Replace spaces with dashes, and keep each product’s rows together.
Unique optionsTwo variants with the same option values stop the import (“options are not unique”).Give every variant its own combination. Shopify allows up to 3 options.
EncodingShopify reads CSV files as UTF-8 with commas. Other encodings turn accented letters into wrong characters.Save as CSV UTF-8 in Excel, or export from Google Sheets.
QuotesA stray or unclosed quote shifts every value after it (“Illegal quoting”).Values with commas or line breaks go inside straight double quotes; a quote inside a value is written twice.
Image URLsShopify fetches each image from its URL. It must be public and https, and the help asks for file names without _thumb, _small or _medium.Use the full-size image’s https link. Add videos and 3D models in the admin after the import.
File sizeShopify takes product CSV files up to 15 MB.Split a larger file into several imports.

Sources

What it cannot see

The checker reads the file, not your store. It does not know which handles already exist, so it cannot tell whether a row adds a product or overwrites one, and it does not open image links to see if they load. Import a few rows first when you are unsure.

A safe way to import products

Four habits that keep a bad file from changing hundreds of products.

  1. Start from Shopify’s template or your own export. The column names then match what the import expects.
  2. Export your products before importing. When a file overwrites products by mistake, the export is your way back.
  3. Check the file here, then fix it in the sheet. Work through the errors first; each one names the line and column.
  4. Import a small part first. Five products tell you whether images, options and prices come through as you meant.

Questions about the CSV checker

Something else? Write to hello@reply.getstorefleet.com.

Is the CSV checker free to use?

Yes. There is no sign-up and no limit on how many files you check.

Is my product file uploaded?

No. The browser reads the file on your device and the checks run in this tab. Nothing is sent to a server or stored, and closing the tab clears it.

Does a clean result mean the import will work?

It means the file passed these checks. Shopify also checks things only your store knows, such as existing handles, so import a few rows first when you are unsure.

Why does it warn about my image links?

Shopify downloads each image from its URL during the import. Links must be public and https, and Shopify asks for file names without the _thumb, _small or _medium suffixes that point to small copies.

What does “options are not unique” mean?

Two rows of one product have the same option values, for example Size M and Color White twice. Each variant needs its own combination; the checker names both lines.

My file comes from a supplier in another format. Can I check it?

The checker reads files in Shopify’s product CSV format. Map the supplier’s columns to the template first, then check the result here.

Beyond this tool

Columna: Product Import & Sync imports a supplier’s catalog into Shopify with variants, images, SKUs and barcodes, without a CSV. It is being rebuilt, and new installs reopen soon. See Columna: Product Import & Sync

For a job no ready-made app covers. Need it to do more? We build custom Shopify apps