WooCommerce – Export Customer Reviews to a CSV File

Let’s learn how to export WooCommerce customer reviews to Excel or Google Sheets.

If you’re migrating from WooCommerce to Shopify or BigCommerce and want to also migrate all the customer reviews, you’re in the right place.

This tutorial explains how to quickly export all your Woocommerce customer reviews with the Comments and Reviews Spreadsheet plugin.

It displays all your posts and product comments on a spreadsheet where you can edit values as in Excel or Google Sheets.

Also, it contains a powerful bulk edit tool and allows you to do advanced searches in seconds.

Besides, you can import comments and reviews using a CSV (Comma Separated Value) file.

And you can download all your comments and reviews to a CSV file to edit it with Excel or Google Sheets.

Once installed and activated, you can open the comments spreadsheet by going to WP Sheet Editor > Edit Comments.

WooCommerce - Export Customer Reviews to a CSV File

Now you just need to follow these simple steps:

Step 1. Filter the product reviews

For this, you need to open the Search tool with one click on the toolbar.

Search for Customer Reviews to export

Next, you need to select Review in Comment type and click on Search.

search for reviews to export

After that, all the reviews will be displayed on the spreadsheet.

You’ll see the filters you have applied below the toolbar.

Export Customer Reviews to Excel or Google Sheets

Step 2. Export the reviews to a CSV file

After filtering all the reviews, open the Export tool with one click on the top toolbar.

open export tool to Export Customer Reviews

Now select these options:

Export Customer Reviews to Excel or Google Sheets

  • Click Select all to export all columns
  • Which rows do you want to export?: Select all rows from my current search
  • What app will you use to edit this file? (optional): Select any of the options. Google Sheets, for example
  • Name of this export (optional): You can enter a name for this export and use it for future exports
  • Click Start new export


After these really simple steps, the CSV file will be downloaded to your computer.

You can edit it, import it to Shopify or BigCommerce, etc.

As you can see, the Comments and Reviews Spreadsheet simplifies WooCommerce management.

It allows you to apply massive changes, do advanced searches, and import or export your Woocommerce customer reviews using CSV files.

You can also check out our tutorial on How to Import Customer Reviews from Excel or Google Sheets.

Or maybe you want to learn How to Export Product Reviews to a CSV File.

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.