WooCommerce – Export all Product Categories to Excel or Google Sheets Quickly

Your client asks you a detailed report of all that has to do with your WooCommerce store in order to suggest some changes. However, he says he wants them in an Excel or Google Sheets. That’s a problem because you have to export them one by one or copy all their info in a spreadsheet.

But don’t worry. Here we’ll show you how to export all product categories to edit them in Excel or Google Sheets or to give your client a good report of the store’s state.

Categories, Tags, Product Attributes, Taxonomies Spreadsheet

This plugin will help you apply changes to thousands of taxonomies with its powerful Bulk Edit tool.

Once installed and activated, go to Sheet Editor > Edit Product categories, and it will display all your categories in a spreadsheet like this:

Open the Export tool

It’s really simple. Just click on the Export tool on the plugin’s top toolbar.

Select the columns you’ll export

Once you open the tool, you’ll be asked to select the columns you want to edit. These are the columns you can export:

  • ID
  • Hierarchy
  • Name
  • Slug
  • Parent
  • Status
  • Count
  • Description
  • Taxonomy
  • Display type
  • Thumbnail
  • Order
  • SEO Title
  • SEO Description
  • SEO Keyword
  • SEO No Index

You can select the ones you want to export. But if you want to select them all, just click on Select all.

Then, tick the I understand it will export the posts from my current search checkbox and click on Start new export.

Done!

Now your CSV file will be downloaded to your computer and you’ll be able to edit it, print it, or whatever you wish. It’s so simple!

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu