Data blog — Northwind RSS

Compare Excel Spreadsheets

Comparing Excel Spreadsheets - Why? Business and Data analysts, Developers and QA testers often have to verify their data is correct. Microsoft Excel is used to create a snapshot of "good data". Reports are captured and copied into Excel, data is exported and distributed as the model to use. SelectCompare allows you to compare Excel spreadsheets in the same way as other data sources. This post is going to show you the process of creating data connections to Excel workbooks and comparing data between two spreadsheets. Hava a look at the Excel data comparison use cases - there is plenty more! Where do I start? First, you have to install appropriate driver to connect to the Excel workbooks. It is an easy...

Continue reading