Data blog
Write Select Statements for Excel Spreadsheets
SelectCompare allows for data comparison of Excel spreadsheets, as well as other data sources with a simple, unified interface.
You may be initially anxious about writing an SQL statement to pull data from your Excel, but it is pretty easy!
This post will show you a few examples of writing queries against your spreadsheet that you will be able to use right away for your Excel data comparison.
If you want to find out how to connect to an Excel workbook, please read another post on this blog - Compare Excel Spreadsheets
You will see below how to query Excel spreadsheets, specify ranges of columns and rows, and write simple filters that make SQL so powerful.
Compare Excel Spreadsheets
Business and Data analysts, Developers, and QA testers often have to verify their data are 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. Have a look at the Excel data comparison use cases - there are plenty more!