How-to | Import an Excel workbook#

You can import Excel workbooks directly into Dataiku. If the Excel workbook has multiple sheets, you can choose whether to:

  • Import each sheet into its own Dataiku dataset (creating one dataset per sheet).

  • Import all (or a selection of) sheets into one Dataiku dataset.

Upload the workbook#

  1. From the upper right corner of the Flow, click + Dataset > Upload your files.

  2. Click Select Files, and choose your Excel workbook.

  3. Continue with the following steps depending on whether your workbook has one or multiple sheets.

For workbooks with a single sheet#

  1. Click Configure Format and make any changes as necessary.

  2. Click Create to create the Dataiku dataset.

For workbooks with multiple sheets#

  1. On the dialog for a new uploaded files dataset, choose to Create Multiple Datasets or Create a Single Dataset.

  2. Beneath the dataset preview, adjust the Sheets selection field, as needed.

  3. You may also want to Add the sheet name as an output column.

  4. Make any other format or schema adjustments.

  5. If you are creating one dataset, click Create. If you are creating multiple datasets, you can choose to Create and next to move to the next sheet or Skip if you don’t wish to add a dataset from this sheet. From the final sheet, click Create.

Important

If you are using Dataiku versions 12.6 or below, you must use the Excel sheet importer plugin to import multiple sheets to different Dataiku datasets.