WooCommerce – How to Export/Import Hundreds of Categories – Excel or Google Sheets

Imagine you want to export all your categories to edit them all in Excel or Google Sheets. Maybe you want to edit all their SEO requirements using a SEO tool like Screaming Frog or Moz. Or maybe you have a CSV file containing all your categories’ information and you have made some changes to your categories and want to upload them.

Whatever the case, in this article we’ll show you how easy it is to export or import all your product categories. We’ll use the Categories, Tags, Product Attributes, Taxonomies Spreadsheet plugin.

Install the plugin now

This plugin helps you edit hundreds of taxonomies in seconds. It displays them in a beautiful spreadsheet where you can edit freely.

Besides, it contains a powerful Bulk Edit and an Export/Import option for you to integrate your work from Excel or Google Sheets.

You can download the plugin here:

- or - Read more about it

Once you install and activate the plugin, open it by going to Sheet Editor > Edit Product categories.

1- Export your categories to edit them in Excel or Google Sheets

In any case you want to download all your product categories to edit them in Excel or Google Sheets, you can easily do it with the plugin’s Export tool.

For this, just click on Export on the plugin’s top toolbar.

Then, select the columns you want to export in the What columns do you want to export field. You can select them all or select individual columns by writing their names in the field.

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

2- Edit your categories in Excel or Google Sheets

Once you’ve exported the categories, you can open the CSV file with Excel or Google Sheets. It’s really simple. Just imagine you’re editing any other spreadsheet because that’s what you’re doing.

After making the changes you wish, save changes to the CSV file and you can import it to WP Sheet Editor.

3- Import your categories from Excel to WP Sheet Editor

The plugin’s Import tool is really useful if you:

  • Edit your categories in Excel or Google Sheets
  • Have used a SEO tool like Screaming Frog or Moz and have your corrections in a CSV file.

Therefore, you need to click on the plugin’s Import tool, located on the plugin’s top toolbar.

In the Import csv screen, you need to select these values:

  • Source: CSV file from my computer
  • CSV file: Click on Select file
  • Click on Next

Click on Import all the columns.

Finally, click on The preview is fine, start import.

Done!

As you can see, the plugin’s Import and Export tools are really useful. You may have many other situations in which you can use them.

You can download the plugin here:

- or - Read more about it

Close Menu