What is a basic yet efficient UX for "cleaning up a table similar records"?

I am interested in curating data of various sorts, one example of which is company metadata. Another example is movie metadata, or book metadata, or sports player metadata. Basically, a spreadsheet of thousands of rows (if not millions or …