In this tutorial, we’ll show you how to export WooCommerce variable products and variations to a CSV file. We’ll cover two options: exporting variable products without their variations, and exporting variable products together with all their variations.
Related tutorial: How to import variable products and variations from a CSV file.
To do this, we’ll use the WP Sheet Editor – WooCommerce Products plugin. It displays all your products and variations in a spreadsheet inside your WordPress dashboard, and includes a built-in Export tool that lets you download product data to a CSV file compatible with Excel, Google Sheets, and other spreadsheet applications.
The plugin also includes:
- Advanced search. Filter variable products and variations using any field as a search parameter, including product type, attribute, price, stock status, and more.
- Bulk editing. Apply changes to hundreds of products and variations at once using the Bulk Edit tool.
- Variations manager. Copy variations from one product to multiple products, generate variations for every attribute combination, and manage variation data in bulk.
- Import and export. Download and upload product and variation data using CSV files.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Once you have the plugin installed and activated, follow the steps below. We’ll walk through both export options in separate sections.
Open the Products Spreadsheet
Go to WP Sheet Editor > Edit Products in your WordPress dashboard. Alternatively, go to Products > All Products and click Open in a spreadsheet.
The spreadsheet will load all your WooCommerce products as rows, with every product field displayed as a column.
Option 1: Export Variable Products Without Variations
Use this option when you only need the parent variable product data and do not need to include individual variation rows in the export file.
Step 1. Filter Variable Products Using the Search Tool
Click Search on the top toolbar to open the Search tool.
Configure the following settings in the Search tool:
- Tick the Enable advanced filters checkbox.
- Field: Type (product_type)
- Operator: =
- Value: Variable
- Click Run search.
The spreadsheet will reload and display only variable products. The active search filter will be shown above the spreadsheet so you can confirm the correct product type is selected.
Step 2. Export the Variable Products to CSV
Click Export on the top toolbar to open the Export tool.
Configure the following settings inside the Export tool:
- Select the columns you want to export. Choose specific columns, all active columns in the spreadsheet, or all available columns.
- Select the rows you want to export. Select all rows from my current search to export only the variable products you just filtered.
- Select the app you’ll use to open the CSV. Choose Microsoft Excel 365, an older version of Excel, Google Sheets, or another CSV editor.
- Name of this export (optional). Saving a name lets you rerun the same export configuration in the future.
- Click Start new export.
The plugin will download a CSV file containing only the variable parent products. Each row in the file represents one variable product. Variations are not included in this export.
Option 2: Export Variable Products With Variations
Use this option when you need a complete export that includes both the parent variable products and all their individual variation rows. This is the format required when importing variable products back into WooCommerce using WP Sheet Editor.
Step 1. Filter Variable Products and Variations Using the Search Tool
Click Search on the toolbar to open the Search tool.
Configure the following setting in the Search tool:
- Tick the Search on variations checkbox.
- Click Run search.
The spreadsheet will reload and display both the variable parent products and all their associated variations. Each variation appears as its own row, grouped under its parent product.
Step 2. Export the Variable Products and Variations to CSV
Click Export on the top toolbar to open the Export tool.
Configure the following settings inside the Export tool:
- Select the columns you want to export. Choose specific columns, all active columns in the spreadsheet, or all available columns.
- Select the rows you want to export. Select all rows from my current search to include both the variable products and their variations.
- Select the app you’ll use to open the CSV. Choose Microsoft Excel 365, an older version of Excel, Google Sheets, or another CSV editor.
- Name of this export (optional). Saving a name lets you rerun the same export in the future without reconfiguring the settings.
- Click Start new export.
The plugin will download a CSV file containing both parent products and their variations. In the exported file, look at the Type column to distinguish between the two: parent variable products show the value variable, while individual variations show the value variation. Each variation row appears directly after its parent product row.
Exporting WooCommerce variable products with WP Sheet Editor – WooCommerce Products follows the same two-step pattern for both options: filter the products using the Search tool, then run the export using the Export tool. Use Option 1 when you only need parent product data, and Option 2 when you need a complete file that includes every variation row alongside its parent product.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Related tutorials:
- Bulk edit product variations
- Add product variations in bulk
- Copy variations from one product to multiple products
- Bulk edit variation prices
- Delete WooCommerce variations in bulk
- Remove SKUs from product variations in bulk
- Delete duplicate variations in bulk
- Set the same image across all variations
- Delete out-of-stock variations in bulk