Compare csv files?

mader

Well-known member
Babiato Lover
Trusted Seller
Trusted Uploader
Sep 18, 2019
519
372
63
Hi guys, I have been struggling to find an answer to this question:
How I can compare 2 csv files and remove the lines which are duplicate?

Example:
I have file1.csv which has a few columns containing different text.
I want to remove from it, all the lines which are same as the ones in file2.csv.

I am currently using this website as some kind of solution: https://mytexttools.com/remove-lines-containing-string.html , but it takes me a lot of time to copy/paste and format everything.

Do you know of any ready solution for Windows 10?
 

DatDudeUpStairs

Be the change that you wish to see in the world.
Trusted Uploader
Jun 30, 2019
1,334
786
113
Asgardia
Hi guys, I have been struggling to find an answer to this question:
How I can compare 2 csv files and remove the lines which are duplicate?

Example:
I have file1.csv which has a few columns containing different text.
I want to remove from it, all the lines which are same as the ones in file2.csv.

I am currently using this website as some kind of solution: https://mytexttools.com/remove-lines-containing-string.html , but it takes me a lot of time to copy/paste and format everything.

Do you know of any ready solution for Windows 10?
I had a project like this last year. the best I found without dabbling in writing Excel scripts was google docs.
It had a delete duplicate option.
some other files for detecting duplicate threads is kudotool extenstion (Excel addon)
 
  • Like
Reactions: mader

About us

  • Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Quick Navigation

User Menu