• Login
  • Courses
  • Books
  • Cheat Sheets
  • Tutorials Archive
  • VBA Code Generator
  • Contact

Power Spreadsheets

Excel and VBA tutorials and training. Learn how to use Microsoft Excel and Visual Basic for Applications now.

Excel Power Query from Workbook (Single Data Source): Example

This Excel Power Query from workbook (single data source) example helps you:

  • Import a single data source from a workbook with Power Query (Get & Transform); and
  • Load the imported data to an Excel Table in a new worksheet.
Excel Power Query from workbook (single data source) example

Table of Contents

  • Excel Power Query from Workbook (Single Data Source) Process
  • Excel Power Query from Workbook (Single Data Source) Example
  • Excel Power Query from Workbook (Single Data Source) Explanation
  • More Excel Power Query (Get & Transform) Training Materials and Resources

Excel Power Query from Workbook (Single Data Source) Process

(1) Go to Ribbon > Data > Get Data > From File > From Excel Workbook.

Power Query displays the Import Data dialog box.

(2) Do the following in the Import Data dialog box:

  1. Browse to the folder where the workbook with the source data is stored.
  2. Double-click the workbook.

Power Query displays the Navigator dialog box.

(3) Do the following in the Navigator dialog box:

  1. Select the data source (left of the dialog box).
  2. Click Load (bottom right of the dialog box).

Excel Power Query from Workbook (Single Data Source) Example

I do the following to:

  • Import a single data source (the data stored in Sheet1) from a workbook named “Workbook Single Data Source by PowerSpreadsheets dot com.xlsx” stored in the “PowerSpreadsheets dot com” folder; and
  • Load the imported data to an Excel Table in a new worksheet.

(1) Go to Ribbon > Data > Get Data > From File > From Excel Workbook.

(2) Double-click the “Workbook Single Data Source by PowerSpreadsheets dot com.xlsx” workbook.

(3) Select Sheet1.

(4) Click Load.

The GIF at the top of this post shows:

  • This process; and
  • The results I obtain.

Excel Power Query from Workbook (Single Data Source) Explanation

Power Query (Get & Transform) allows you to import data into Excel.

You can:

  • Connect Power Query to different data sources, including Excel workbooks.
  • Specify where and how Power Query loads the imported data.

The process I describe above works with Power Query's default data-loading settings. When you import data from a single data source in an Excel workbook, Power Query loads the imported data (by default) to an Excel Table in a new worksheet.

More Excel Power Query (Get & Transform) Training Materials and Resources

You can find more Excel Tutorials (including other Power Query examples) in the organized Tutorials Archive: Click here to visit the Archives.

If you want to learn how to work with Power Query, you may be interested in the following books (affiliate links):

  • M is for (Data) Monkey: Click here to get this book.
  • Power Query for Power BI and Excel: Click here to get this book.
  • Master your Data with Power Query in Excel and Power BI: Click here to get this book.
  • Collect, Combine, and Transform Data Using Power Query in Excel and Power BI: Click here to get this book.
guest
guest
0 Comments
Inline Feedbacks
View all comments

I publish a lot of Tutorials and Training Resources about Microsoft Excel and VBA. Here are some of my most popular Excel Training Resources:

  1. Free Excel VBA Email Course
  2. Excel Macro Tutorial for Beginners
  3. Excel Power Query (Get and Transform) Tutorial for Beginners
  4. Excel Keyboard Shortcut Cheat Sheet
  5. Excel Resources
Terms and Conditions

Privacy Policy

Limit of Liability and Disclaimer of Warranty

Affiliate Disclosure

Copyright © 2015–2023 PDS Intelligence Pte. Ltd. All rights reserved.
Excel ® is a registered trademark of the Microsoft Corporation. Power Spreadsheets is not affiliated with the Microsoft Corporation.