System and method for logical identification of differences between spreadsheets

A non-transitory computer readable medium having stored thereon instructions for causing a processing circuitry to execute a process, the process comprising:

• identifying, in each of a first version and a second version of the spreadsheet, data and metadata associated with their respective headers;
• comparing between the first version and the second version of the spreadsheet to identify at least one structural difference, wherein the comparison is based on the identified headers data and metadata;
• comparing between the first version and the second version of the spreadsheet to identify at least one content value difference, wherein the comparison is based, in part, on the at least one identified structural difference;
• and
• saving the at least one identified structural difference and the at least one identified content value difference in a differences (Diff) dataset.

A system for logical comparison of different versions of a spreadsheet, comprising:

• a processing circuitry;
• and
• a memory, the memory containing instructions that, when executed by the processing circuitry, configure the system to:
• identify, in each of a first version and a second version of the spreadsheet, data and metadata associated with their respective headers;
• compare between the first version and the second version of the spreadsheet to identify at least one structural difference, wherein the comparison is based on the identified headers data and metadata;
• compare between the first version and the second version of the spreadsheet to identify at least one content value difference, wherein the comparison is based, in part, on the at least one identified structural difference;
• and
• save the at least one identified structural difference and the at least one identified content value difference in a differences (Diff) dataset.