Compare data between Excel spreadsheets

How many times have you been sent the same spreadsheet? It's not uncommon to have data sent repeatedly, and all you really want to know is, "What's different? What, if anything, has changed?"

In less than a minute, this video shows you how to:

• Create connections to two sample Excel spreadsheets
• Query the data from the spreadsheets using SQL
• Compare data between the two spreadsheets
• Review the data comparison with Citrus Replay's unique cross-grid highlighting

The principles shown here can be applied to any data source, or indeed across different database types (see the related video Validate and compare data across databases).

The query used in this video is the default select of the whole spreadsheet. You can of course use any SQL query to filter or manipulate your data as required prior to the running the data comparison.

The two spreadsheets compared here have the same structure. However, you can map different schema and different data formats during the data comparison process.

Powerful Data Comparison which is incredibly easy to use? Download the 7-day trial of Citrus Replay now, and see for yourself.