Free Shopify product CSV checker

Your file stays with you

Your file is checked on your device and never uploaded. This page isn’t allowed to send data: its security policy tells your browser to block every upload and data request.

Works offline: load the page, disconnect from the internet, and try it.

CSV files up to 100 MB. Shopify itself accepts up to 15 MB.

The checker needs JavaScript to read your file on your device. Everything else on this page works without it.

How to verify this
  1. 01Turn off Wi-Fi or switch to airplane mode, then check a file. It still works.
  2. 02Open your browser’s developer tools (F12), go to the Network tab and check a file. No request appears.
  3. 03This page is served with the policy below. connect-src 'none' tells the browser to refuse all uploads and data requests; form-action 'none' blocks form posts.

Security policy for this page

Content-Security-Policy: frame-ancestors 'none'; connect-src 'none'; form-action 'none'

Network requests while checking: none yet, no file checked · Blocked attempts: 0

How to use it

  1. 01

    Export your products from Shopify (Products → Export), or take the file you plan to import.

  2. 02

    Drop it above, or choose it. The check takes a few seconds.

  3. 03

    Read the results by area. Each issue lists the rows, why it matters and how to fix it.

  4. 04

    Fix the file and check it again, or download the report.

What it checks

111 automated checks, grouped into the five areas of my paid audit:

  1. 01Structure & headers: required columns, header spelling, encoding, quotes, empty rows.
  2. 02Handles, titles & SKUs: invalid or split handles, missing titles, duplicate SKUs, barcodes damaged by Excel.
  3. 03Variants: option names and values, duplicate combinations, exact duplicate rows.
  4. 04Prices, weights & booleans: number formats, currency symbols, decimal commas, units, status and TRUE/FALSE fields.
  5. 05Images & missing data: share links instead of images, http links, image positions, alt text, empty descriptions.

What it can’t check

  • Your store settings, apps and existing products.
  • Whether your data is correct. It sees that a price is missing, not whether CHF 24 is the right price.
  • Which of two duplicate variants is the right one.
  • Metafields, app columns, subscriptions, bundles and multi-location inventory.
  • Whether your images show what they should, or whether the links load.

Questions

Is my file uploaded?

No. The checks run on your device, and this page isn’t allowed to send data: its security policy tells your browser to block uploads. Test it: load the page, disconnect from the internet, and check a file.

How big can the file be?

The checker handles up to 100 MB. Shopify itself accepts product CSVs up to 15 MB, so the checker tells you when a file needs splitting. Large files can take a few seconds on older phones.

I have an Excel file. What now?

Save it as CSV first. In Excel: File → Save As → CSV UTF-8. In Google Sheets: File → Download → Comma-separated values. Then check that file.

Is this an official Shopify tool?

No. It’s an independent tool by Niclas Graf. It checks against Shopify’s published product CSV format.

Does it fix my file?

No. It shows you what to fix and where. If you’d rather not do it yourself, I can: that’s the paid audit.

Is it really free?

Yes. No account, no email address, no limit on how often you use it.

Why does it use the same words as your paid audit?

So you can read both the same way. The checker groups results into the audit’s five areas and uses its severity levels: Blocking, Will import wrong and Cleanup. The audit adds what a machine can’t do: judgement, recommendations, a list of decisions for you and, with Standard or Premium, a corrected file.

Can it be wrong?

Yes. It can miss things, or flag something that’s fine in your setup. It’s a fast first check, not a guarantee.