In case you ever wondered about how to compare excel files/sheets, then this is for you.
A quick Google search leads you to lot of tools many of which are commercial. There do exist open source utilities as well like Spreadsheet Compare. Another tool is Office Diff that can be used to compare other file formats like word (doc) also apart from excel (xls).
Note that the former was found to be not working in some cases while the latter was not as rich as the former. Given this, the following approach is what I would recommend that works always. You do not need any tool to perform the diff although it might be a little bit more involved and not as straightforward. All that you'd need to do is to:
A quick Google search leads you to lot of tools many of which are commercial. There do exist open source utilities as well like Spreadsheet Compare. Another tool is Office Diff that can be used to compare other file formats like word (doc) also apart from excel (xls).
Note that the former was found to be not working in some cases while the latter was not as rich as the former. Given this, the following approach is what I would recommend that works always. You do not need any tool to perform the diff although it might be a little bit more involved and not as straightforward. All that you'd need to do is to:
- Export the excel sheets to tab-separated or comma-separated text files.
- Use any text diff utility like KDiff3, which was shared previously, to compare the text files.
No comments:
Post a Comment