Shopify → Excel / CSV
Turns your Shopify product export into a Excel / CSV bulk-upload file, column for column.
Excel (.xlsx, .xls) or CSV
Tips
- Shopify Admin › Products › Export, then pick "Plain CSV file"
- Leave no barcode or stock-code cell empty; rows that miss one land in the warning list.
- Category names are not mapped automatically — check the category column in the file you download.
How to use it
- 1 In Shopify Admin open the Products page and click Export at the top right.
- 2 Choose "All products" and "Plain CSV file", then click Export products; with more than 50 products the file is emailed to the store owner instead of downloading.
- 3 Drop the file on this page; the source format is detected and a mapping preview appears.
- 4 Check the warning list: missing barcodes, empty prices and duplicated variants are collected there.
- 5 Download the XLSX file for Excel / CSV.
- 6 Open the downloaded .xlsx in Excel, Google Sheets or LibreOffice.
- 7 The columns are clean and plainly named, so you can paste them into accounting software, an ERP or another panel.
What you should know
Reshaping a Shopify product list into the Excel / CSV format by hand costs hours: column names differ, prices switch between tax-inclusive and tax-exclusive, variants are grouped by a different rule, and a barcode’s leading zero disappears the moment a spreadsheet opens the file. This converter reads the file you exported from Shopify, maps every field onto the Excel / CSV template, and reports the rows you should check before uploading.
The file never leaves your computer: reading, mapping and writing the new file all happen in the browser tab, with no account and no upload. The result downloads as Excel (.xlsx) and can be handed straight to the Excel / CSV import screen.
What to know about a Shopify export: Every variant is its own row; Handle ties the rows of one product together. Extra images arrive on rows with an empty title through Image Src; the tool attaches them to the right product. Body (HTML) carries markup, which is stripped when the target expects plain text.
Worked example: a Shopify file turned into a Excel / CSV file
Our Shopify sample file (shopify.csv) holds 4 rows and 36 columns. The tool recognized 17 of those columns on its own. The other 19 are not product fields the tool carries, so they were left out: "Type", "Published", "Option1 Name", "Option2 Name", "Option3 Name", "Variant Inventory Tracker", "Variant Inventory Policy", "Variant Fulfillment Service" …. The rows were grouped into 2 products with 3 variants, and 4 image URLs were carried over. The Excel / CSV file that downloads has 3 rows and 15 columns; 14 of those columns arrive filled and the rest stay empty because the sample has no data for them. Going from 4 rows to 3 is not an error: Shopify and Excel / CSV write a product with variants using a different number of rows.
First row of the output (under Excel / CSV column names)
| Excel / CSV column | Value written |
|---|---|
| Product Name | Linen Shirt |
| Barcode | 8680004000011 |
| Stock Code | LIN-BEJ-M |
| Price | 49.9 |
| List Price | 59.9 |
| Stock | 7 |
| Brand | Nuve |
| Category | Shirts |
| Description | <p>Summer linen, <b>relaxed</b> fit</p> |
| Image 1 | https://cdn.example.com/img/linen-1.jpg |
| Image 2 | https://cdn.example.com/img/linen-2.jpg |
| Image 3 | https://cdn.example.com/img/linen-3.jpg |
| Option 1 | Beige |
| Option 2 | M |
Notes the tool gave for this file
- A clean product table with canonical columns; it is not a specific marketplace template.
- Each row is one variant; variants of the same product are written consecutively.
- "Price" is the sale price and "List Price" the pre-discount price; it stays empty when there is no discount.
- Option columns were written in the source order (e.g. Option 1 = Color).
Field mapping: Shopify → Excel / CSV
Which target column each source column is written to. You can fix unmatched fields in the preview before downloading.
| Field | Source column | Target column |
|---|---|---|
| Product name | Title | Product Name |
| Model / group code | Handle | — No counterpart in the target; skipped |
| SKU | Variant SKU | Stock Code |
| Barcode | Variant Barcode | Barcode |
| Sale price | Variant Price | Price |
| List / compare-at price | Variant Compare At Price | List Price |
| Stock | Variant Inventory Qty | Stock |
| Tax rate | — | VAT Missing in the source; left empty |
| Weight (grams) | Variant Grams | — No counterpart in the target; skipped |
| Image columns | Image Src + Image Position | Image 1..n |
| Option 1 | Option1 Name / Value | Option 1 |
| Option 2 | Option2 Name / Value | Option 2 |
| Description | Body (HTML) | Description |
| Brand | Vendor | Brand |
| Category | Type | Category |
Frequently asked questions
Can’t I just open the Shopify export in Excel?
You can open it, but it is hard to work with: variants and extra images arrive on rows with an empty title, tied to the product only by the Handle column, and Shopify itself warns that sorting the file in a spreadsheet can separate variants and image URLs from their product. This tool gives you a clean .xlsx with one row per variant, the product name on every row and each image in its own column, so sorting and filtering never break a product apart.
Which fields does Excel / CSV require?
Product name, Barcode, Stock code, Price, Stock. When one of them is empty the row lands in the warning list; fill it in the source file before uploading.
Are category and brand mapped automatically?
The brand is carried over untouched. Category names never match one to one across platforms, so you still have to fit them into the Excel / CSV category tree yourself; the tool writes the source category into the "Category" column.
Are prices carried over with or without tax?
The price in the Shopify file is carried over exactly as it is; the spreadsheet keeps the tax rate in its own column.
Are images transferred too?
Image URLs are carried over, each in its own column (Image 1, Image 2…). The spreadsheet holds links to the images, not the image files themselves; a public link opens the image when you click it.
How many products can I convert at once?
There is no cap. The conversion runs on a background thread, so the page stays responsive even with files of 10,000 to 20,000 rows; the time it takes depends on your machine.
Guides
Articles and format references related to this tool.
Related tools
- Excel / CSV → Shopify Converts your Excel / CSV product export into the Shopify import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- Trendyol → Excel / CSV Converts your Trendyol product export into the Excel / CSV import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- Hepsiburada → Excel / CSV Converts your Hepsiburada product export into the Excel / CSV import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- CSV and Excel Merger Merge multiple CSV and Excel spreadsheets into one table by aligning matching column headers. Export clean data to XLSX or CSV directly in your browser.
- Excel to CSV Converter Convert Excel sheets to UTF-8 CSV files instantly. Choose custom delimiters, add BOM for spreadsheet software, and export directly in your browser with privacy.
An independent tool. Not affiliated with Shopify or Excel / CSV, and not an official product of either.