I have a csv file named master.csv, which has the following columns

link, name

And another csv file called details.csv, which has the following columns

link, name, price, desc

I want to match master.csv against details.csv and delete the rows from master.csv which already have details in details.csv. link column is the unique column that matches both.

1 Answer 1


In Excel you can do like this, the manual way:

  1. Open details.csv.
  2. Open master.csv, copy all content and paste it below the last line in details.csv.
  3. Close master.csv.
  4. Select Remove Duplicates, mark only Column A and press OK. Now the duplicate rows should be removed from the lower part of the document (originating from master.csv).
  5. Remove the rows in the upper part of the document, that originated from details.csv.
  6. Save the file as master.csv.

If you have some requirements that it should be done programmatically, in another program or about the output of the operation, please provide that information.

  • 1
    This should work. As of now, I have no need to do the same programmatically.
    – esafwan
    Feb 19, 2018 at 11:05
  • 2
    Great to hear and I'm glad I could help! Actually it's my first answer that gets accepted :-)
    – PatrikN
    Feb 19, 2018 at 20:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.