Edit Database without creating duplicates

Need help, i am constantly cleaning my database collection but not necessarily easy in Wix so i used a master spreadsheet. But if i upload back into the collection it creates duplicates! And this collection is connected to a dynamic page that has thousands of pages and ratings elements, so i would lose those elements if i started over.
So essentially need help with the best way to edit, add or clean data in excel then get it back into wix collection?

to clarify, my master file is not the collection but the way a collection is setup, Wix wants it to be. Yet the features arent the same as excel or sheets so i cant edit thousands of records as efficently