Quick Summary · Updated November 2026
To convert a supplier spreadsheet into a valid Shopify product CSV, map vendor columns to Shopify’s exact case-sensitive headers (Handle, Title, Variant SKU, Variant Price, Option1 Name, Option1 Value, Status), strip currency symbols from prices, generate lowercase hyphenated handles, and leave repeated product-level fields blank on secondary variant rows.
01 / INTERACTIVE VENDOR TO SHOPIFY CSV CONVERTERUpload a vendor sheet, verify auto-mapped columns, and download Shopify CSV.
Or paste / edit vendor CSV or TSV text directly
Step 2 · Review & Adjust Column Mapping (Vendor Header → Shopify Header)
Step 3 · Preflight Validation & Shopify Export Preview
Preflight error & warning log
02 / SHOPIFY IMPORT RULES BUILT INWhat this converter handles automatically so Shopify accepts your file.
- Automatic URL Handle generation: Converts product names like
Merino Crew Sweaterinto compliant lowercase hyphenated handles (merino-crew-sweater). - Variant continuation formatting: When multiple consecutive rows share the same
Handle(e.g., Medium and Large sizes), product-level columns (Title,Body (HTML),Vendor,Status) stay blank on subsequent variant rows as Shopify requires. - Safe default Draft status: Exports new imports as
draft/Published = FALSEby default so you can verify photos and pricing inside Shopify Admin before going live. - Price & Compare-At sanity checks: Strips
$/€/£symbols and flags non-numeric text (likeTBD) or compare-at prices lower than the selling price.
Common questions.
Is this Shopify CSV converter free and private?
Yes. Conversion runs 100% inside your browser tab memory with zero server uploads, no account signup, and no Shopify Admin API permissions required.
Can I convert Excel (.xlsx) files here?
Export your Excel sheet as CSV UTF-8 (.csv) or Tab-Delimited (.tsv) first, then drop it into Step 1 above. The converter automatically detects comma, semicolon (;), and tab delimiters.
What happens if my supplier file has multiple sizes for the same product?
If rows share the same Handle (or share the same Title with auto-handle enabled), this converter groups them under one Handle and leaves product-level columns blank on continuation variant rows. For complex multi-option WooCommerce variable/grouped migrations, review our dedicated platform guides first.
Should I compare the output against my live store before importing?
Yes—if you are updating existing products rather than creating new drafts, drop your current Shopify export and your newly converted file into our Key-Based CSV Compare tool to verify zero accidental blank-cell overwrites.