Once you've deleted all the reviews, go to the Import section and import the new CSV file.Īnd 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.Ĥ. You should already have the exported CSV file as backup, as well as the new, curated one.ġ0. Go back to your Products section in the Product Reviews app and delete all of your reviews. Name the file and save it in CSV format.ĩ. Open a brand new Excel file and copy everything to the new file (selection without duplicates).Ĩ. The file should now have all the duplicates hidden, so press CTRL + A to select everything.ħ. Select the body column if not already selected and press OK to remove duplicates.Ħ. Find the Remove Duplicates button from the Data Tools section of the toolbar.ĥ. With the entire column selected, go to the Data tab in the navigation bar.Ĥ. The body column of the reviews is where the review text can be found, and this is what we'll be using to check for duplicates.ģ. Select the body column of the file by clicking on its corresponding cell tab ( H tab). You can remove duplicate reviews with the help of Excel (for Windows) or Libre's Calc (for Ubuntu) with only a few clicks.įirst of all, you need to export your store's reviews to a CSV file from the Import section. This will be your backup file in case you make any mistakes. Before attempting this process, please ensure you have exported all your store's reviews and saved the CSV file intact.
0 Comments
Leave a Reply. |