Here's how:
- Go to Data > Get & Transform Data > Get Data > From File.
- Select the type of file that you want to import (such as From Excel Workbook or From Text/CSV).
- Select the file you want to import, and then select Import.
- In the Import Data dialog, select the data you wish to import, how you want to view the data in your workbook, and where you want to put it. To select where the data will be loaded, select the dropdown arrow beside Load, and then select Load To.
- Do one of the following:
| To | Do this |
|---|---|
| Import the data to the current worksheet | Select Existing worksheet, and then select OK. |
| Import the data to a new worksheet | Select New worksheet, and then select OK. Excel adds a new sheet to your workbook and automatically pastes the external data range at the upper-left corner of the new worksheet. |