It may happen to end with two different tables, in which you just want to know what are the exact differences, especially when you manage a lot of data.
I propose you a simple way to quickly get differences between two tables – the only difficult part is to get them in the right format !
The first step is to get two Excel workbook, for example an old one (Fig 1) and a new one (Fig 2).
Check that both tables have the same columns in the same order with the same naming, and that the first one contains a unique identifier – meaning there is no two times the same value in this column within the same file, and that same lines of both files have the same value in this column.
Also, you may want to order your tables, as the program will not do it – you can use standard Excel order function to do so.
Then, you should convert your Excel tables in CSV. Open then, and choose “File" => “Save As…" => “CSV (Comma delimited)(*.csv)", for the first file (Fig 3), and then again for the second file (Fig 4).
You can now download the Access database I propose you and save it in the same folder as your two CSV files.
Open it and select your language in the Macros menu (Fig 5), and the program will ask you to provide the name of the first file (Fig 6) to compare to the second one (Fig 7).
Pay attention to give the full name of the csv file, and to have them located in the same folder, or you will get an error (Fig 11).
About the author - International Business Consulting Yoann is an International Business Consultant, facilitator and coordinator. He worked more than 10 years in global business, supply chain, financial, SAP ERP projects, Web and SEO optimization for various industries, such as logistics, cosmetics, consumer goods, beauty care, or fashion, in more than 30 countries around the globe.
If you deal with data, then you probably use spreadsheets. Microsoft Excel is a widely popular spreadsheet software, and there’s a good chance that you use it. You can do a lot with Excel; moreover, repositories like Excel Template provide very useful templates to improve your productivity. Excel also provides many powerful tools. One such tool that can help you to analyse data is “Pivot table". How can you create a pivot table in Excel? Read on to find out.