Is it possible to load specific query to a specific empty tab in excel?

[Keith011]

Hi there,

Is it possible to load specific query to a specific (existing) empty tab in excel?

This is my excel workbook. "raw_data" is just me pasting raw data into that tab. "Table 1" is where power query exisit. "Sheet1" is an empty sheet i created manually in excel

this is my power query in excel. I want to tell power query to specifically load this "Testing" query into the "Sheet1" tab. can i do so?

[wdx223_Daniel · Accepted solution]

if it's your first time loading, just select "Create&Load to" to put the query where you want.

if the query has been loaded before, just right click it in the right Queries pane, select "Load To"