Filtering and removing duplicate reviews
Last updated on October 21, 2026
Before attempting this process, please ensure you have exported all your store's reviews and saved the CSV file intact. This will be your backup file in case you make any mistakes.
You can remove duplicate reviews with the help of Excel (for Windows) or Libre's Calc (for Ubuntu) with only a few clicks.
First of all, export your store's reviews: in the Product Reviews app, go to the Import tab and click Export. The reviews arrive by email as a .zip file; unzip it to get the CSV.
💡 Check for duplicates on the product_handle, author, rating and body columns together, never on body alone. Different customers often write the same short text (for example "Great product!"), and those genuine reviews would be deleted.
💡 Ensure that the reviews in the CSV are verified and are real reviews. Shopify does not allow the display of fake/manipulated reviews according to their Acceptable Use Policy.
Using Microsoft Excel
1. Open the CSV file with Excel.
2. Press CTRL + A to select all the data.
3. Go to the Data tab in the navigation bar.
4. Find the Remove Duplicates button from the Data Tools section of the toolbar.
5. Untick all columns, tick product_handle, author, rating and body, and press OK to remove duplicates.
6. The file should now have all the duplicates hidden, so press CTRL + A to select everything.
7. Open a brand new Excel file and copy everything to the new file (selection without duplicates).
8. Name the file and save it in CSV format.
9. In the Product Reviews app, go to Settings, open Data management and click Delete all reviews (type DELETE to confirm).
No need to worry. You should already have the exported CSV file as backup, as well as the new, curated one.
10. Once you've deleted all the reviews, go to the Import tab and import the new CSV file. Reviews you had marked as featured, pinned, verified or added to a carousel need to be marked again.
And you're done! Your reviews will be re-imported, only this time without any duplicates! You can also check this out for more information: How to Find Duplicates in Excel.
Using LibreOffice Calc
1. Open the CSV file with Calc.
2. Press CTRL + A to select all the data, so a row only counts as a duplicate when every column matches.
3. Go to the Data tab in the navigation bar.
4. Find More filters, then select the Standard filter.
5. In the first box, under Field name, select none instead of Column H, then open the Options drop-down and check the box for No duplications, then click OK.
6. The file should now have all the duplicates hidden, so press CTRL + A to select everything.
7. Open a brand new Calc file and copy everything to the new file (selection without duplicates).
8. Name the file and save it in CSV format.
9. In the Product Reviews app, go to Settings, open Data management and click Delete all reviews (type DELETE to confirm).
No need to worry. You should already have the exported CSV file as backup, as well as the new, curated one.
10. Once you've deleted all the reviews, go to the Import tab and import the new CSV file. Reviews you had marked as featured, pinned, verified or added to a carousel need to be marked again.
And you're done! Your reviews will be re-imported, only this time without any duplicates!
If you encounter any issues when uploading the CSV file, please reach out to us. We will check it for any signs of corruption and try to re-upload it on your behalf.