Start Excel and open a new or existing spreadsheet. Go to the "Data" tab and click on "From Other Sources" in the Get External Data group. Choose "From Microsoft Query" in the drop-down list.

1. Click anywhere inside the Excel Table that you want to load into Power Query. 2. Click the Data tab. 3. In the Get & Transform Data group, click From Table/Range.

To run the new script, click the Automate tab. Click All Scripts in the Office Scripts group, which will open a list of existing scripts in the Code Editor window, as shown in Figure C.