Corrupt xlsx2csv requires Microsoft .Net version 2 framework, but is capable of extracting and converting worksheets from corrupted Excel 2007 xlsx files to CSV. This tool can salvage data where Excel 2007 fails to do so.
I recently tried out Corrupt xlsx2csv, a software that requires installation of the Microsoft .Net version 2 framework. Despite its name, this program surprisingly extracts and converts to CSV format worksheets from even damaged or corrupted Excel 2007 xlsx format files. What's more, it successfully salvages data where Excel 2007 itself fails to do so.
The program has a Perl / Tk GUI front end, making it simple to navigate. Additionally, it can be used as a viewer of the unformatted data in an xlsx file without having Excel 2007 installed.
As some of you may know, Excel 2007 files are essentially zipped collections of mostly XML files. XML is not tolerant of file corruption, and from the errors generated, Excel 2007 seems to be using a fairly corrupt intolerant XML reading algorithm to even salvage unformatted data from corrupt xlsx format files.
However, Corrupt xlsx2csv uses an unzipper that is tolerant of XML file corruption and uses Perl coding to extract the sharedStrings.xml and worksheet.xml files which contain all of the unformatted data from an xlsx file. Since this Perl coding does not use standard XML reading applets or modules, but instead identifies the cell data as text or string and extracts, the result is almost flawless extracted data until the point of corruption is reached. In contrast, Excel 2007 appears to return no results for that particular xml file if it encounters any XML errors at all.
Overall, I found Corrupt xlsx2csv to be an insightful tool that successfully retrieves data where Excel 2007 fails. Its simple GUI and ability to view unformatted data make it a useful addition to any software toolkit.
The program has a Perl / Tk GUI front end, making it simple to navigate. Additionally, it can be used as a viewer of the unformatted data in an xlsx file without having Excel 2007 installed.
As some of you may know, Excel 2007 files are essentially zipped collections of mostly XML files. XML is not tolerant of file corruption, and from the errors generated, Excel 2007 seems to be using a fairly corrupt intolerant XML reading algorithm to even salvage unformatted data from corrupt xlsx format files.
However, Corrupt xlsx2csv uses an unzipper that is tolerant of XML file corruption and uses Perl coding to extract the sharedStrings.xml and worksheet.xml files which contain all of the unformatted data from an xlsx file. Since this Perl coding does not use standard XML reading applets or modules, but instead identifies the cell data as text or string and extracts, the result is almost flawless extracted data until the point of corruption is reached. In contrast, Excel 2007 appears to return no results for that particular xml file if it encounters any XML errors at all.
Overall, I found Corrupt xlsx2csv to be an insightful tool that successfully retrieves data where Excel 2007 fails. Its simple GUI and ability to view unformatted data make it a useful addition to any software toolkit.
What's New
Version 1.02: - Working no on a copy of the file, not the original.- Removed CMD window permanently from appearing.- Added a progress bar.- Lined up the widgets in two rows.- Fixed a bug where all worksheets did not display properly.
Version 1.0:
- Removed most formatting from CSV file save options.
- Add notebook tabs.
- Switched the basis of the program to ss2tk by H. Merijn Brand.
- Stop the excess print to CMD screen feedback.
- Add a message box indicating success at saving all the csv files.
- Stopped 2 decimal place rounding