Compare data in large excel spreadsheet

Vote count:

0

I have two large (very large) excel spreadsheets, and I need to find the differences between the two. They are both outputs of SQL queries, one with old code and one with new code and I need to validate that the new code still returns all the same stuff as the old code. What I'm mostly interested in is knowing which row or column is different in the new version, and not as much about how they are different.

The spreadsheets are too large for excel to handle. I've also tried the ExcelCompare project from na-ka-na on github, but I ran into memory issues with that as well. Is there a (free) tool that can handle these big tables, or a technique I could use to break them up into more manageable pieces?

asked 5 mins ago

Jackson H

1

Compare data in large excel spreadsheet