how to load the power query table into existing worksheet without adding any new columns

Hi, @Chaturvedi, Santosh

If you mean you want the Power Query result on an existing worksheet instead of creating a new worksheet:

• Go to "Data" > "Queries & Connections."
• Right-click the query and select "Load To."
• Select "Table."
• Select "Existing worksheet."
• Choose the cell where you want the Power Query table to start, then click "OK."

Microsoft explains the load options here:

https://support.microsoft.com/en-us/excel/create-load-or-edit-a-query-in-excel-power-query

If by "without adding any new columns" you mean you want Power Query to keep only the columns already in your existing table, you will need to remove the unwanted columns in Power Query before loading it. Power Query loads the columns returned by the query.

If the issue still persists, to help narrow down the issue:

1. Are you trying to load the query into an existing Excel table that already contains data?
2. Are extra columns being added when you refresh the query?

Click "Add comment" to let me know.

Thanks!

Loading a query never inserts columns into your sheet. It writes the table into the cells you choose. The question is a bit ambiguous, so here what i think you mean.

1. Load into a specific cell on an existing sheet
2. In Power Query Editor, select Close & Load To... (or in Excel: Data → Queries & Connections, right-click the query, Load To...).
3. Select Table, then Existing worksheet.
4. Click the cell where the table should start, then OK.

The table is written from that cell, overwriting what's there. Leave enough empty space to the right and below, or it will overwrite your data.

2. Stop the extra columns appearing

• Open the query in Power Query Editor and remove columns you don't want with Remove Columns or Choose Columns. What's in the final step is exactly what loads.
• Remove any Index or custom columns you added in earlier steps.
• Don't type extra columns next to the loaded table. The table auto-expands and can swallow or collide with them.

3. Keep your sheet from shifting when row or column counts change
4. Click inside the loaded table, then go to Table Design → Properties (the external data properties).
5. Under "If the number of rows in the data range changes upon refresh," choose Overwrite existing cells with new data, clear unused cells.
6. Untick Include row numbers if it's checked.
7. Tick Preserve column sort/filter/layout if you've formatted the columns.
8. Load into an existing Excel table Power Query can't append to or merge into an existing table. It always creates its own. If you need your own columns beside the result, load the query as Connection only and pull in the values with formulas, or put your extra columns outside the loaded table and reference them.