Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Individual datasets
  • A single dataset
  • A dataset with parameters

    Info

    NOTE: When importing one or more Excel files as a parameterized dataset, you select worksheets to include from the first file. If there are worksheets in other Excel files that match the names of the worksheets that you selected, those worksheets are also imported. All worksheets are unioned together into a single imported dataset with parameters. Pattern-based parameters are not supported for import of Excel worksheets.


Limitations

Info

NOTE: Before you begin, you should review information on file formats supported for import, which cause your files to fail to import or to be properly ingested and formatted. For more information, see Supported File Formats.

  • XLSX and XLS format are supported. Other Excel-related formats, such as XLSM format, are not supported.
  • Some characters, such as hashtags (#) and curly braces ({}) cannot be used in filenames. For more information, see Supported File Formats.
  • Filepath and source row number information is not available from original Excel files. These references return values from the CSV files that have been converted on the backend. For more information, see Source Metadata References.
  • Source Excel files with cells bracketed by single double quotes may not be properly ingested if any terminating quotes are missing.

    Tip

    Tip: You can check the data quality bars for mismatched values or, for strings, the data histogram bars for anomalous values to see if the above issue is present. If so, deselect Detect Structure on import. Then, use a Split rows transformation applied to the affected column to break up the column as needed.


  • Macros in your Excel files are not imported.
    • During import, cell formulas are applied, and the output values are used in the imported dataset.
  • You cannot import password-protected Excel files.
  • Import of Excel files with protected columns or cells is not supported.
  • Compressed Excel files are not supported.

...