How to Copy Power Query Queries in Excel?

Power Query is a data processing application that is commonly used for business analytics and data analysis. Power Query is supported by both Microsoft Excel and Microsoft Power BI. High-quality research requires a singular source of truth and well-organized, error-free data. While many researchers spend countless hours merging data, performing lookups, and changing data, Power Query allows all of these tasks to be mechanized in a few simple steps. Power Query is one of the most innovative tools accessible to any analyst working with data in Excel. It will not only save analysts time, but it will also result in fewer manual mistakes and a greater ability to collect data from a singular source of truth.

Know more about Merging Data from All Sheets from Files in some Folder using Power Query

Steps to Copy a Power Query

Step 1: Go to the worksheet from where you want to copy the query. 

Here you can see the Excel worksheet with the power query and we are going to copy the query of this worksheet to a new worksheet.

Step 2: Navigate to the data on the top of the ribbon and then select Queries & Connections.

Selecting queries & connections will open the query tab from where we can copy the query to a new worksheet.

Step 3: Now just Right-click on the Query and then select the copy option.

We have successfully copied the query from the queries & connection tab and it can now be pasted into a new worksheet.

Step 4: Now just open the worksheet where you want to copy the Query.

A new worksheet has been opened where we will paste the query we have copied from the previous worksheet

Step 5: Navigate to the data on the top of the ribbon and select Queries & Connection on the new worksheet.

Pasting the query in the Queries & connections tab in the new worksheet will apply the filters and import the previous data. 

Step 6: Now paste the copied Query in the queries window.

Now, you have successfully copied a power query.

Note: The same type of copying can be performed on the query which depends on other queries.