Power Query Problems

How to Load Power Query Results into an Existing Excel Worksheet

Maira Mehtab Oct 9, 2026 869 views

Question details

The user wants to output data from Power Query directly into a specific existing worksheet rather than creating a new sheet.

How to Load Power Query Results into an Existing Excel Worksheet

Product: Microsoft Excel
Device & OS: not provided
Scenario: Exporting or loading transformed data from the Power Query Editor back into a specific location within an active Excel workbook.
Observed behavior: The user needs to select a specific destination cell for the data to load. The action may fail if the target range overlaps with an already existing Excel table.

Before you start

Ensure that the destination range in your existing worksheet is completely empty and does not overlap with any currently formatted Excel tables.

Solution 1Recommended

Use the 'Close & Load To' Option

This is the standard method to specify an exact worksheet and cell for your Power Query output.

By default, clicking the top half of the 'Close & Load' button will generate a brand new worksheet. To control exactly where the data goes, you must use the drop-down menu.

Click the Close & Load Drop-down

In the Power Query Editor, go to the Home tab. Click the drop-down arrow on the 'Close & Load' button, then select 'Close & Load To...'.

Select the Table Format

When the Import Data dialog box appears, choose 'Table' under the 'Select how you want to view this data in your workbook' section.

Specify the Existing Worksheet

Under the 'Where do you want to put the data?' section, select 'Existing worksheet'. Click the cell selector icon and click on the specific destination cell in your worksheet where you want the upper-left corner of the table to appear.

Confirm and Load

Click 'OK' to execute the load. Your queried data will now populate starting from the selected cell.

Tip: Always select the top-leftmost cell of your intended empty range to prevent accidental overwriting of nearby data.

Solution 2

Fix Overlapping Table Errors During Load

Resolve issues when Power Query fails to load due to existing tables occupying the destination range.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you frequently encounter complex data processing errors or heavy load times in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet tool that handles large datasets smoothly and supports standard Excel formats without the hefty subscription fees.

1. Download and Install: Visit the official WPS Office website to download the free installer for your operating system.
2. Open WPS Spreadsheets: Launch the application and select 'Spreadsheets' to access the robust data management tools.
3. Import Your Excel Files: Open your existing .xlsx files directly in WPS Office to continue editing and analyzing your data with full compatibility.

Free and lightweight alternative to Microsoft OfficeFully compatible with Microsoft Excel (.xlsx, .xls) files and table structuresIntuitive interface with powerful built-in data processing and analysis toolsSupports seamless migration with familiar formulas and functions

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Power Query default to a new worksheet instead of an existing one?

By default, clicking the main 'Close & Load' icon automatically creates a new worksheet to prevent accidentally overwriting existing data. To choose an existing worksheet, you must click the drop-down arrow below the button and explicitly select 'Close & Load To...'.

Can I change the load destination of a query after it has already been loaded?

Yes. Open the Queries & Connections pane, right-click the query you want to move, and select 'Load To...'. From there, you can change the destination from a new worksheet to a specific cell in an existing worksheet.

What happens if the data loaded from Power Query expands beyond the initially empty range?

The Power Query result is loaded as a dynamic Excel Table. As you refresh the query and new rows are added, the table will automatically expand downward. It will safely shift underlying cells if necessary, provided there are no other formatted tables directly blocking its path.

Excel & Data Problems