The latest articles on DEV Community by Abriam Downing (@abriam_downing_7589a04b2f). https://dev.to/abriam_downing_7589a04b2f https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4183240%2Ff65b90c8-825e-4999-8730-a2fa9dcf025d.png https://dev.to/abriam_downing_7589a04b2f en Abriam Downing Tue, 13 Oct 2026 23:52:21 +0000 https://dev.to/abriam_downing_7589a04b2f/duplicate-csv-rows-start-with-exact-matches-then-review-36k https://dev.to/abriam_downing_7589a04b2f/duplicate-csv-rows-start-with-exact-matches-then-review-36k <p>Disclosure: I create Rowstead, a browser-local CSV tool. This guide was prepared with AI assistance.</p> <h2> A shared name is not enough </h2> <p>Two people can have the same name. One person can have several addresses. Removing a row because its name looks familiar can discard useful information. Start with complete-row matches and keep a review copy.</p> <h2> Spaces can hide a match </h2> <p>A leading or trailing space can make two otherwise matching cells different. If trimming is appropriate for your data, review that change before checking for duplicate rows again. Some values contain meaningful spaces, so choose cleanup deliberately.</p> <h2> Keep a decision trail </h2> <p>Record why you kept or removed a record. For uncertain rows, mark them for review rather than guessing. Keep the source file and your decision log together.</p> <h2> Check what your tool actually does </h2> <p>An exact duplicate-row check does not infer identity or merge people. Email syntax checks do not establish deliverability or marketing permission. Keep those distinctions visible in your import workflow.</p> <h2> Review before exporting </h2> <p>Compare original and cleaned previews. Save the source, export a reviewed copy, then test a small import in the destination.</p> <p>I use these review principles in <a href="https://rowstead.pages.dev/" rel="noopener noreferrer">Rowstead</a>. The practical lesson applies whichever CSV tool you choose.</p> data productivity tools