Microsoft Excel — Sharing PowerQuery Queries Between Excel Workbooks
The more you use PowerQuery (“Get and Transform” in Excel 2016), you will encounter situations where you want to share a query with others or use a query in a different Excel workbook.
This was exactly the situation I ran into on a client project the other day, so it was time to figure this out!
Fortunately, it is very easy to do!
The example file I am using for this is a real-life client Excel file where we are analyzing selected Twitter accounts.
We “scrape” Twitter using IFTTT and create a Google Sheets file for each account we want to monitor. That is five accounts. Within Excel, we create a query for each account and select “Connection Only”.
We then “Append” those Connection Only queries into one query, modify the content to our preferences and download that one query into Excel as a Table. This then services as our data source for analysis.
Let’s Do It — Create a Copy in Another Excel File
— Access the query you want to copy
- Open Excel workbook
— Open a new Excel workbook, where we will copy the query into
- Click on the PowerQuery Add-in and click on Show Pane
- Inside the Show Pane window, right-click for the shortcut menu and select Paste
- The query populates in the new workbook. Save the file and you’re done!
It’s easy once you know how!
“It’s time for different”
Don is passionate about helping professionals and organizations keep up and adapt to the changing business world that we operate in.
“What Do You Do?”
I frequently get this question. My response (it’s not what you think!)? Check it out here!