while it does import the spreadsheet succesfully, it will not remove the duplicates or overwrite existing rows if the same spreadsheet was to be imported (with changes made to some rows) again. The duplicate rows will appear .
Is there a ool or a way to remove duplicates in a specified sharepoint list?
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.