Filtering and removing duplicate reviews
Last updated on November 18, 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. Wait for Preparing export to finish, then click Download to download the .zip file. The file is available for 24 hours; unzip it to get the CSV.
💡 Before saving the CSV, check your review dates. Use YYYY-MM-DD to avoid ambiguity. Slash dates such as 03/04/2024 are read month-first (MM/DD/YYYY), unless a date in the same column can only be day-first, such as 25/10/2024.
💡 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).
Deletion runs in the background, and Vitals emails you when it is complete. You should already have the exported CSV file as backup, as well as the new, curated one.
10. Wait for the deletion-complete email, then go to the Import tab and import the new CSV file. Reviews you had marked as featured, pinned or added to a carousel need to be marked again, and reviews you had excluded from automatic featured need to be excluded again. In Automatic mode, re-imported published reviews with text at or above your Minimum rating show in Featured Reviews on their own.
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).
Deletion runs in the background, and Vitals emails you when it is complete. You should already have the exported CSV file as backup, as well as the new, curated one.
10. Wait for the deletion-complete email, then go to the Import tab and import the new CSV file. Reviews you had marked as featured, pinned or added to a carousel need to be marked again, and reviews you had excluded from automatic featured need to be excluded again. In Automatic mode, re-imported published reviews with text at or above your Minimum rating show in Featured Reviews on their own.
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.
Still stuck?
Chat with our support team, we'll sort it out with you.