If you want to compare two Excel .CSV different version files like Excel 2013 or 2010 than you must understand some technical or advance features of different excel versions. Sometimes we are unable to perform many tasks in excel so we have to perform some technical exercise and a bit knowledge of excel to compete with the documentation analysis.

So the question is that how to compare two excel (csv) documents. So it is an easy but a little bit technical work to deal with. There are so many examples but the main thing is that how to deal with manual intervention.

Comparing Tow CSV Documents:

Some time people do some searches but they could not able to reach at the basic through. Some people are not familiar with vb but if the code is given than it could be easy task to copy and paste and debug.

Comparing Two Excel CSV Files

For example if a person have two CSV files that he need to be compare and to make a third excel csv file.

First file contain a list of information it make a column say A and second column call B contain a name , and a third one is C and it go with another name, which is part of names that contain in B.

File B will contain a group of names which are of similar format and everything.

So what is a person may looking for that it will create another document that contain all of the information that is in column B, and it add the rows of information that is in column A, but not in B. this should also be done in a way that comparing csv files with the name in B that are present in A to file B, if the name that are present In column B from file A which are not in file B. than the entire row should add to the File C.

For the solution of this problem there are also many options but there should be involve some manual intervention.

Procedures Phase By Phase:

We will start with the open page of both CSV documents say file 1 and file2.

In the D1 of first file csv enter a formula (COUNTIF ([file2.csv] file2! B: B, B1) and we copy this down.

And we put a similar formula to the D1 of second file csv with the reference of first file instead of second. Where we can see that how many names are matched in each line, so we can easily short and re-filter the names on each file.

So little bit of effort, which contains only copy and paste of code to the work to be done.

So it is not exactly glamorous but it works. Hope the method of comparing two excel CSV files will help you out to understand.

Leave a Reply

Your email address will not be published. Required fields are marked *