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.
Drop your product CSV here
or
No file at hand?
| Line | Level | Column | Problem |
|---|
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.
| Check | What Shopify does | How to fix it |
|---|---|---|
| Columns | The 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 row | A 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 handle | Rows 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 options | Two 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. |
| Encoding | Shopify 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. |
| Quotes | A 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 URLs | Shopify 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 size | Shopify 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.
- Start from Shopify’s template or your own export. The column names then match what the import expects.
- Export your products before importing. When a file overwrites products by mistake, the export is your way back.
- Check the file here, then fix it in the sheet. Work through the errors first; each one names the line and column.
- 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.