WooCommerce Product CSV Generator
Fill in an editable table of products and generate an import-ready WooCommerce CSV with the correct headers and quoting. Copy it or download a .csv. Everything runs in your browser.
WooCommerce > Products > Import. Nothing is uploaded or logged.About the WooCommerce Product CSV Generator
The WooCommerce Product CSV Generator builds an import-ready CSV using the exact column headers WooCommerce expects. Fill in an editable table of products, add or remove rows, then copy the result or download a .csv file you can feed straight into WooCommerce > Products > Import. Everything runs in your browser, so your product data is never uploaded.
How it works
- Edit the table cells to enter your products. Each row is one product with columns like Type, SKU, Name, Regular price, Categories, Stock, and more.
- Use Add row to create more products and the Remove control on a row to delete it. Load sample fills the table with example data you can edit.
- Click Generate CSV to build a WooCommerce-compatible file with the correct headers and proper quoting.
- Copy the CSV or Download .csv, then import it under WooCommerce > Products > Import.
Features
- Editable table using the column headers the WooCommerce importer reads, including Type, SKU, Name, Published, Regular price, Sale price, Categories, Short description, Description, and Stock.
- Add and remove product rows with one click.
- Correct CSV quoting: values containing commas, quotes, or line breaks are wrapped and escaped so the file parses cleanly.
- Copy to clipboard or download a ready-to-import .csv file.
- Fully client-side. No accounts, no uploads, nothing sent to a server.
Frequently asked questions
Where do I import the file in WooCommerce?
Go to WooCommerce > Products > Import in your WordPress admin, upload the generated .csv, and follow the column-mapping step. The headers match WooCommerce's defaults, so mapping is usually automatic.
What values does the Type column accept?
Use simple, variable, variation, grouped, or external. For virtual or downloadable products append the keyword, for example 'simple downloadable' or 'simple virtual'.
How do I format categories and prices?
Categories use 'Parent > Child' for hierarchy and commas to separate multiple categories. Prices are plain decimals with no currency symbol, for example 29.99. Leave Sale price blank when there is no active sale.
Does my data leave the browser?
No. The table, CSV generation, copy, and download all run locally in your browser. Your product data is never sent anywhere.
Can I import to update existing products?
Yes. Put the existing product's numeric ID in the ID column, keep its SKU, and WooCommerce will update that product instead of creating a new one. Leave ID blank to create new products.