Preview shows the first 50 rows of your query in the pane without touching your sheet. Run to sheet writes the full result as a table at the cell you choose.
Preview a query
Select Preview at the bottom of the Query Builder. The first 50 rows appear in the pane. Change a field, filter, or group and preview again until the result looks right.
Choose where the table goes
In your sheet, select the cell where the header row should go.
Under Put results at, select Use selection. The cell address appears in the step.
Run the query
If any step has a problem, such as a filter missing its value, the pane shows Fix 1 issue to run this query and marks the step to fix.
Select Run to sheet. The pane shows Running query and the cell it's writing to.
Keep working in the sheet while it runs. To stop it, select the cancel button.
When it finishes, the pane confirms the result, such as "Wrote 248 rows to Sheet1!A3:G251."
What gets written
The header row lands on your chosen cell, with a title and a sync line in the two rows over it. If you choose a cell in row 1 or 2, there's no room for those rows, so the title starts at your cell and the header row lands two rows lower.
Title: What the table holds, such as "Order lines, last 30 days."
Sync line: When your store last synced, as a fixed date and time. A note on that cell gives the time zone and when you pulled the data.
Header row: The column names, on the cell you chose.
Data: One row per result, with dates, currency, and numbers already formatted.
If the cells already have data
The pane warns you before writing over anything, naming the cells that have data. Select Replace it to write over them, or Cancel and choose another cell.
After the table lands
The table becomes a block the add-in tracks, so you can refresh it later from the ribbon. Refresh your data covers every way to refresh, and Save a query covers saving. The result card in the pane offers:
Go to range: Jumps to the table.
Refresh: Reruns the query with the latest synced data.
Save query: Saves it so you can rerun it in any workbook.
Run again: Writes the result again in the same place.
New query: Starts a fresh query.