WooCommerce – Export all Product Categories to a CSV

Managing a WooCommerce store comes with its own set of challenges, and one common frustration for store owners is the complexity of exporting WooCommerce categories.

In this post, we will show how to export WooCommerce categories to a CSV file using the WP Sheet Editor – Taxonomy Terms plugin.

This can be great if you want to migrate your WooCommerce data to another site, update product information in bulk, or simply create a backup for future reference.

WP Sheet Editor – Taxonomy Terms

We know how frustrating it is when you find yourself stuck in a tedious process that should ideally be simple.

That’s why we will use the WP Sheet Editor – Taxonomy Terms plugin.

This plugin allows you to manage WooCommerce taxonomies in a spreadsheet on WordPress, providing an intuitive interface to manage and export taxonomy terms effortlessly.

Why WP Sheet Editor – Taxonomy Terms?

• Flexibility: Customize your export based on specific criteria, ensuring that you export only the information you need.
• Time-Efficiency: Save time with bulk edits and exports, simplify your workflow and reduce the manual effort required.

After installing and activating the plugin, go to Sheet Editor > Edit Product categories, and it will display all your categories in a spreadsheet like this:

Export WooCommerce product categories to a CSV file

The first thing we need to do to download the data of our WooCommerce categories to a CSV file is to open the Export tool.

Once you open the Export tool, you need to select these values:

• What columns do you want to export: Here you need to select the columns or fields you want to export to the CSV file. You have three options:
  • Type the column names to export specific columns only.
  • Export all the active columns only by clicking on Select active columns.
  • Export all columns or fields by clicking on Select all.
• Which rows do you want to export: Here you need to select which rows you want to export. You have these two options:
  • All the rows from my current search: Select this if 1) you’re exporting all categories or 2) you run a search to export specific categories.
  • Rows that I selected manually with the checkbox: Next to the ID column, the spreadsheet contains a checkbox picker that you can use to select the rows you’ll export.
• What app will you use to edit this file (optional): You can select any of these options:
  • Microsoft Excel (Office 365)
  • Older versions of Microsoft Excel
  • Google Sheets
  • Other
• Name of this export (optional): You can add a name for this export, and it will be saved for future exports. If you want to reuse these options, you will just need to hover over the export tool and you’ll see all the exports you’ve saved by adding a name for them.
• Click on Start new export.

After you have exported your WooCommerce categories to a CSV file, you can open the file with any CSV editor.

Here’s what our WooCommerce categories CSV looks like in Google Sheets.

This is how you can export WooCommerce categories to a CSV file that you can edit with Excel, Google Sheets, or any other CSV editor.