Convert a product spreadsheet to a Shopify import CSV — free.
Let your agent work across all your spreadsheets for you.
Upload your product list — a CSV or Excel file with whatever headers you already have — and get back a Shopify-ready products import file. We match your columns to Shopify's product fields, flag anything that needs your judgment (like variants or a live-store SKU lookup), and show you a plain-language list of exactly what we mapped and what we couldn't. Your original file is never changed.
What it does
Shopify's products import expects specific column headers and value formats — Handle, Title, variant option columns, price and inventory fields, and more. Your source list rarely matches them out of the box; the titles, descriptions, prices, and options live under headers of your own. This tool reads your file, maps each column to the right Shopify product field, and writes a clean import CSV you can upload in your Shopify admin.
The mapping ledger is the point
Nothing is mapped silently. Every column you gave us shows up under what we mapped — source header → Shopify field — and anything we couldn't place lands under what needs you, with the reason and how to resolve it. Variant grouping, image assignments, and columns that need a live store connection are flagged there rather than guessed at.
Reviewed file, not an automatic write
This hands you a reviewed import file to check and upload yourself — it never writes to your store directly. You stay in control of what actually lands in Shopify, and your uploaded file is read in memory and never stored.
Prefer to start from a blank template?
Download the blank Shopify product import template — every column header Shopify expects, ready to fill in and upload. It's generated from the same field list this tool maps to, so it always matches the current import format.
Want this inside your AI agent, on your own machine, with no upload at all? Install xlsx-for-ai and ask Claude or Cursor to “build a Shopify products import from this list.”
All Convert a product spreadsheet to a Shopify import CSV — free. guides
- "Excel keeps breaking my CSV file" — BOM corruption, semicolon delimiter, curly quotes
- "How do I add new products without messing up my existing ones?"
- "How do I import products with sizes AND colors (multiple options)?"
- "How do I include product images in my spreadsheet?"
- "How do I set products as active (not draft) when importing?"
- "I got: Daily variant creation limit reached"
- "I got: Handle can't be blank"
- "I got: Ignored line because it did not contain product data"
- "I got: Illegal quoting on line" — curly/smart quotes from Excel or Word
- "I got: Invalid CSV header: missing headers" — column name typo or wrong case
- "I got: Inventory policy is not included in the list"
- "I got: Inventory quantity is not a number" — commas, currency symbols, or text in quantity column
- "I got: Option does not exist" — variant row option name doesn't match product's defined options
- "I got: Validation failed: An error occurred while trying to download the image"
- "I got: Validation failed: options are not unique"
- "I got: Validation failed: price can't be blank"
- "I got: Validation failed: The uploaded image exceeds the 20 megapixel limit"
- Shopify said "Import Successful" — but your products never showed up
- Shopify says "Line is invalid" or "Line 1 is invalid (No details)" — and gives you nothing else
- "My file won't upload — wrong file format" — Excel saved as semicolon-delimited or non-UTF-8
- "My image URLs aren't working in the import" — Shopify requires publicly hosted URLs, not local files
- "My images are missing after import" — image URL failure (silent)
- "My inventory is showing as 0 after import / products say out of stock" — tracker vs. quantity mismatch
- "My prices are wrong or missing after import" — price formatting
- "My product CSV is too big to upload" — 15 MB file size limit
- "My product descriptions / vendor / tags got wiped after import" — blank columns in update CSV overwrite
- "My products aren't in any collections after import" — CSV doesn't assign collections
- "My variant SKUs didn't import" — SKU column dependency on option columns
- "My variants are showing as separate products instead of one product" — handle mismatch on variant rows
- "Only some of my products imported, the rest are missing" — partial import, rows silently dropped
- "Only the first image imported, extra images are missing" — multi-image row structure
- Your products imported — but they're invisible to customers because they all landed as drafts
- "Shopify is ignoring my inventory quantity column" — multi-location stores / wrong CSV file used
- "There was an error importing your CSV file" — here's what's actually wrong
- "Updating existing products isn't working — my changes didn't save" — handle-matched update not applying
- Variants, sizes, or colors didn't come through after import — or they each became a separate product