Supported data sources

The Unstructured Data stage supports only Microsoft Excel files as the source file.

The Unstructured Data stage supports the following file formats:

Microsoft Excel 97-2003 OLE2 (.xls), including support of password-encrypted file.
Microsoft Excel 2007-2010 OOXML (.xlsx), including support of password-encrypted file.

The Unstructured Data stage does not support Microsoft Excel files that are created by Microsoft Excel for Mac.