If you’re migrating from WooCommerce to Shopify or BigCommerce and want to migrate the customer reviews, you’re in the right place. This tutorial explains how to quickly export all your customer reviews with the Comments and Reviews Spreadsheet plugin.
It displays all your post 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 export 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.
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.
Next, you need to select Review in Comment type and click on Search.
After that, all the reviews will be displayed on the spreadsheet. You’ll see the filters you have applied below the toolbar.
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.
Now select these options:
- Select all columns to export
- Tick the I understand it will export the posts from my current search checkbox.
- Optional. Tick the Tick I will edit this file with Microsoft Excel checkbox.
- Click on 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 your life completely by allowing you to apply massive changes, do advanced searches, import and export your comments using CSV files.