Excel / CSV → WooCommerce
Turns your Excel / CSV product export into a WooCommerce bulk-upload file, column for column.
Excel (.xlsx, .xls) or CSV
Tips
- Any product spreadsheet you already have (.xlsx or .csv) works
- 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 Prepare your product table as .xlsx or .csv with the column headers on the first row.
- 2 Include at least product name, price and stock; barcode and SKU are strongly recommended.
- 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 CSV file for WooCommerce.
- 6 Open WooCommerce › Products › Import and pick the CSV.
- 7 Columns map themselves because the tool writes standard WooCommerce headers.
- 8 Tick "Update existing products" when you want rows matched by SKU.
What you should know
Reshaping a a plain Excel or CSV spreadsheet product list into the WooCommerce 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 Excel / CSV, maps every field onto the WooCommerce 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 UTF-8 CSV and can be handed straight to the WooCommerce import screen.
What to know about a Excel / CSV export: Common English and Turkish header names are recognised automatically (Product Name, Price, Barcode, SKU, Stock). Columns that are not recognised can be mapped by hand in the preview. When a shared model or group code column exists, its rows are collected under one product.
Worked example: a Excel / CSV file turned into a WooCommerce file
Our Excel / CSV sample file (urunler.xlsx) holds 4 rows and 12 columns. The tool recognized 11 of those columns on its own. The other 1 are not product fields the tool carries, so they were left out: "Raf No". The rows were grouped into 3 products with 4 variants, and 3 image URLs were carried over. The WooCommerce file that downloads has 5 rows and 34 columns; 20 of those columns arrive filled and the rest stay empty because the sample has no data for them. Going from 4 rows to 5 is not an error: Excel / CSV and WooCommerce write a product with variants using a different number of rows.
First row of the output (under WooCommerce column names)
| WooCommerce column | Value written |
|---|---|
| Type | variable |
| SKU | KT-100 |
| Name | Seramik Kupa 330 ml |
| Published | 1 |
| Is featured? | 0 |
| Visibility in catalog | visible |
| Tax status | taxable |
| In stock? | 1 |
| Categories | Mutfak > Kupa |
| Images | https://example.com/img/kupa-beyaz.jpg, https://example.com/img/kup… |
| Brands | Atölye Kil |
| Attribute 1 name | Color |
| Attribute 1 value(s) | Beyaz, Mavi |
| Attribute 1 visible | 1 |
Notes the tool gave for this file
- Some variants have no barcode (Trendyol and Hepsiburada require one)
- Some products have no image
- In your WooCommerce admin, upload it from Products > Import; the columns map automatically.
- Variations are linked through the parent SKU in the "Parent" column; where the parent SKU was empty it was generated from the model code or the product name.
- WooCommerce downloads the image URLs during import, so make sure they are publicly reachable.
Field mapping: Excel / CSV → WooCommerce
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 | Product name (detected automatically) | Name |
| Model / group code | Model / group code (detected automatically) | Parent |
| SKU | SKU (detected automatically) | SKU |
| Barcode | Barcode (detected automatically) | GTIN, UPC, EAN, or ISBN |
| Sale price | Sale price (detected automatically) | Sale price |
| List / compare-at price | List / compare-at price (detected automatically) | Regular price |
| Stock | Stock (detected automatically) | Stock |
| Tax rate | Tax rate (detected automatically) | — No counterpart in the target; skipped |
| Volumetric weight (desi) | Volumetric weight (desi) (detected automatically) | Weight (kg) |
| Weight (grams) | Weight (grams) (detected automatically) | Weight (kg) |
| Image columns | Image columns (detected automatically) | Images |
| Option 1 | Option 1 (detected automatically) | Attribute 1 name / value(s) |
| Option 2 | Option 2 (detected automatically) | Attribute 2 name / value(s) |
| Description | Description (detected automatically) | Description |
| Brand | Brand (detected automatically) | Brands |
| Category | Category (detected automatically) | Categories |
Frequently asked questions
Which fields does WooCommerce require?
Name, Type (simple/variable/variation), SKU, Regular price, Published. 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 WooCommerce category tree yourself; the tool writes the source category into the "Categories" column.
Are prices carried over with or without tax?
The price in the Excel / CSV file is carried over exactly as it is; WooCommerce then reads it as tax-inclusive or tax-exclusive according to your store tax settings, so check them.
Are images transferred too?
Image URLs are carried over and WooCommerce downloads the files from those addresses during import, so every URL has to stay publicly reachable.
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
- WooCommerce → Excel / CSV Converts your WooCommerce product export into the Excel / CSV import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- Hepsiburada → WooCommerce Converts your Hepsiburada product export into the WooCommerce import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- Ikas → WooCommerce Converts your Ikas product export into the WooCommerce import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
- ROAS Calculator Calculate ROAS, ACOS, break-even targets, and net profit from ad spend and revenue. Compare campaign returns privately inside your browser without data uploads.
- Remove Duplicate Rows Remove duplicate rows from Excel or CSV files by SKU, barcode, or email. Choose which row to keep, normalize whitespace, and export securely in your browser.
- Trendyol → WooCommerce Converts your Trendyol product export into the WooCommerce import template: columns are mapped, barcodes and variants stay intact. Free, no signup.
An independent tool. Not affiliated with Excel / CSV or WooCommerce, and not an official product of either.