How to Export WooCommerce Products to Excel or CSV
If you need to know how to export WooCommerce products, you'll find that WooCommerce stores product data across multiple database tables, making exports complicated. The default export creates a CSV with inconsistent formatting, merged cells for variations, and attributes spread across dozens of columns.
Upload your WooCommerce product export and get a spreadsheet where variations inherit parent data, image URLs split into columns, and attributes organize into a readable structure for inventory analysis.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| ID |
| Type |
| SKU |
| Name |
| Published |
| Regular price |
| Sale price |
| Stock |
| Categories |
| Tags |
| Images |
| Parent |
| Attribute 1 name |
| Attribute 1 value(s) |
Common questions
How to export WooCommerce products?
Go to Products > All Products in your WordPress admin, click the Export button at the top, select which product fields to include, then click Generate CSV. WooCommerce creates a downloadable file with all products, variations, prices, and stock levels.
Why are some product names blank in the export?
Those are parent rows for variable products. WooCommerce exports the parent product with Type 'variable' and blank price, then lists each variation below it. The parent row holds category and description data while children hold size, color, and individual prices.
How do I count total products when variations are separate rows?
Filter the Type column to exclude 'variation' rows, or count only rows where the Parent column is empty. A product with five size variations creates six rows but represents one product.
What does the Published column value mean?
It shows 1 for published products visible in your store, 0 for drafts, and -1 for products in the trash. Private products show 1 but have 'private' in a separate visibility column if you enabled that field in export settings.
Why do I have columns named Attribute 1 name, Attribute 2 name up to Attribute 15?
WooCommerce creates a column pair for every attribute slot any product uses. If one product has five attributes, the export includes ten columns for all products even though most products leave them blank.
Can I export only simple products without variations?
The WooCommerce export includes all product types. After exporting, filter the Type column to show only 'simple' or delete rows where Type equals 'variable' or 'variation'.
How do I split the Images column into separate URLs?
The Images column contains URLs separated by the pipe character |. Use Excel's Text to Columns feature with | as the delimiter, or a formula like LEFT(Images, FIND('|', Images)-1) to extract the first image.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file