How to Import Etsy Listings to Shopify

Moving from Etsy to Shopify? Etsy lets you download your shop data, but the EtsyListingsDownload.csv it produces is built for Etsy's own structure — not Shopify's. The column names differ, variations live in combined cells, and there's no Handle anywhere. Import it straight into Shopify and you'll get rejected rows and broken variants.

Why Etsy exports don't work in Shopify

Shopify's importer demands exact column names and one row per variant under a shared Handle. Etsy's export uses names like "TITLE", "DESCRIPTION", and "VARIATION 1" and combines option values in ways Shopify can't parse — so listings either fail or import without their variations.

Beyond column names, there are the structural problems Shopify cares about:

• No Handle column — Shopify needs a unique slug per product
• Variations are stored as VARIATION 1 / VARIATION 2 combined cells, not Shopify Option rows
• Tags are space- or comma-separated in one cell and need normalising
• Prices are plain but quantity/availability must map to Shopify inventory + Published
• Multiple listing images are referenced separately and need one-image-per-row structure

Etsy vs Shopify: column name differences

Every column in a Etsy export needs to be renamed before Shopify will recognise it.

Manual fix: step by step

If you want to fix the CSV yourself, here's the full process in Google Sheets or Excel:

1. Download your Etsy data (Shop Manager → Settings → Options → Download Data → Download CSV). Open in Google Sheets as UTF-8.
2. Rename headers from Etsy's ALL-CAPS names to Shopify's exact casing using the table above.
3. Generate Handles with =LOWER(REGEXREPLACE(B2,"[^a-zA-Z0-9]+","-")) and de-duplicate.
4. Split variations into Shopify Option columns: one row per variant repeating the Handle, with Option1 Name (e.g. Size) and Option1 Value filled in.
5. Move images to rows. Each IMAGE column becomes a separate row that repeats the Handle in the Image Src column.
6. Add Published. Set Published to TRUE for active listings; normalise tags to comma-separated values.
7. Add required variant columns (Variant Inventory Policy = deny, Variant Requires Shipping = TRUE).
8. Export as CSV UTF-8 and import 5–10 listings as a test first.

A typical Etsy shop with 100–300 listings and per-listing variations takes 1.5–3 hours to convert manually — splitting variations and images by hand is where most of the time goes.

Automatic fix: upload to EcomCSVFix

EcomCSVFix handles all of the above automatically in a single pass. Upload your raw Etsy export and the tool will:

• ✓Rename all column headers to Shopify's exact format
• ✓Generate a unique Handle for every product
• ✓Convert 1/0 and Yes/No to TRUE/FALSE across all boolean columns
• ✓Strip currency symbols and normalise prices to 2 decimal places
• ✓Fix encoding issues if the file was saved from Excel
• ✓Flag any rows it couldn't fix automatically with a warning

You get a full cleaning report showing every change made, then a download link for the fixed file. The whole process takes under 30 seconds.

Frequently asked questions