Skip to main content

Save a query

Saving a query keeps its data type, fields, filters, groups, and sort under a name you choose. See how to save a new query, save changes or a copy, the naming rules, and what a saved query keeps.

B
Written by Bradley Taylor

Saving a query keeps its data type, fields, filters, groups, and sort under a name you choose. You can run it in any workbook, refresh its tables in place, or use it in a formula with =MS.RUN.

Save a new query

  1. Build your query in the Query Builder.

  2. Select Save at the bottom of the pane.

  3. Enter a name, or keep the suggested one, such as "Order lines, last 30 days."

  4. Select Save query. The pane confirms it, and the query appears in Saved.

Save a query you already ran

If you ran a query before saving it, select Save query on the result card. The table you ran becomes linked to the saved query, so refreshing it uses the saved version.

Save changes to a saved query

When you open a saved query in the builder and change it, the header reads Saved query · edited. Select Save changes to update it. Every table and formula that uses the query picks up the change the next time it refreshes.

Save a copy

To keep the original and save your edits as a new query, open the More menu next to the query name and select Save as a new query. To leave the original untouched and keep working without saving, select Stop editing (keep as a new query).

Naming rules

Each of your saved queries needs its own name. If you pick one that's taken, the pane shows That name is taken. Choose another name, or rename the older query in Saved.

What a saved query keeps

A saved query stores the query itself, never the rows. Each time you run or refresh it, it pulls the latest synced data. A date preset such as Last 30 days covers a new window each time, so the same saved query stays current without edits.

Did this answer your question?