Using Import from Excel

In the unified interface, Import from Excel is available from the action bar in most views. This import tool allows you to import Excel workbooks, CSV files, and XML files.

Import from Excel has many similarities to the Import Data Wizard but has a more modern user interface. Clicking on the Import from Excel button gives the two options shown in the following figure:

Figure 6.18 – Import from Excel 

Instead of a separate window, this wizard opens in a pane on the right-hand side of the screen. You can browse and select a file. The rest of the steps are similar to the Import Data Wizard; for instance, the mapping of columns to fields is shown in the next figure:

Figure 6.19 – Import from Excel mapping

An import job is created, and you can monitor this job in the same way that you did for the Import Data Wizard.

You can import only one file at a time. To import more files, you need to run the wizard again.

If you have other data...