Shopify product CSV checker

Find out why Shopify will reject your product CSV before you import it. Shopify imports have no undo.

Free. The check runs in your browser, so your file never leaves your computer. Works with Shopify's current columns and older exports (Handle, Variant Price…).

What it checks

• "Illegal quoting on line X": a stray " in a description that never closes, which swallows the rest of the file.
• Encoding: Excel's default CSV isn't UTF-8, so ®, ™ and accents arrive garbled. In Excel, use Save As → "CSV UTF-8".
• Handles and titles: every row needs a handle, each product's rows must sit together, and the first row of each product needs a Title.
• Variants: option values without option names, Option2 used before Option1, and two variants with identical options.
• Numbers: $24.00 or 1,049.00 in a price column, and quantities that aren't whole numbers.
• Excel damage: barcodes turned into 8.12345E+11, and 12-digit UPCs that lost their leading zero.
• Everything else: image links that aren't web addresses, Status values, TRUE/FALSE columns, repeated SKUs, the 15 MB limit and the 2,048-variant limit.