Handling unsupported Excel features

The Problem

PANDA supports importing Excel files, however, certain features may cause data to fail to import.

As a proprietary data format Excel files have a long and complicated history. PANDA does not can support all the features that Excel does. Some unsupported features are handled automatically, for example:

In addition to these limitations only the first worksheet of an Excel workbook will be imported.

The Solution

Excel files that fail to import should be resaved as CSV files prior to import.

If an Excel file fails to import for any reason the only solution is to export it to a CSV. This can be done in Excel or in another spreadsheet application, such as LibreOffice. In the latter simply choose Save As from the File menu and then select "Text CSV" as the file type. If prompted with advanced options (delimiter, etc.) you may leave them set to the defaults.