If you need to import an Excel spreadsheet and get the following error: "Unable to connect to the specified file. Corrupt OpenXML document." (image below), try the following steps to successfully import the file/s.
- Open the Excel file.
- Save it as XLS (not XLSX) file extension.
*Please note that in a XLS workbook, the row limit is 65,536 (216) and 256 columns (28) which corresponds to the column IV. With XLSX workbooks, limits are 1,048,576 rows (220) and 16,384 columns (214)
Please sign in to leave a comment.