---
title: "How to export Supermetrics queries from Google Sheets to Excel"
slug: "how-to-export-supermetrics-queries-from-google-sheets-to-excel"
description: "Learn how to manually copy Supermetrics queries from Google Sheets to Excel with this step-by-step guide, ensuring seamless data transfer and functionality."
updated: 2026-05-20T08:22:05Z
published: 2026-05-20T08:22:05Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to export Supermetrics queries from Google Sheets to Excel

This guide describes how to manually copy Supermetrics queries built with Google Sheets to Excel. Even though the queries built in both products are stored in a sheet called 'SupermetricsQueries', column offset differences mean that some adjustments are needed to keep everything working.

## Before you begin

Before you can transfer your queries from Google Sheets to Excel, make sure:

- The data sources your queries use are connected to Supermetrics in Excel with the same accounts you use to log in to them in Google Sheets.
- The Excel file you’re transferring to has at least one Supermetrics query in it (this creates the SupermetricsQueries sheet).
- The Excel file you’re copying to has a similar structure — number of tabs, for example — to the file in Google Sheets.

## Instructions

### Step 1: Prepare the Excel file

In your destination Excel file, prepare the row where you'll be pasting the query details from Google Sheets to make sure there are no formatting mishaps, such as numbers converted into scientific notations. [Learn how to view the SupermetricsQueries tab in Excel](/v1/docs/about-the-supermetricsqueries-tab-advanced).

1. Highlight the target row on the SupermetricsQueries tab in Excel.
2. Change the formatting first to **General** and then to **Text**.

### Step 2: Copy the query row from Google Sheets to Excel

1. Open the Supermetrics sidebar in the Google Sheets file you want to copy queries from.
2. Open the SupermetricsQueries tab (if this is hidden, navigate to **Extensions → Supermetrics → Manage queries** to open it).
3. Find the row with the query you want to export.
4. Highlight the full row and copy it. ![Spreadsheet showing Query ID and related details with a highlighted copy option.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/google-sheets-copy-query-row.png)
5. Paste the row **as values only** into the SupermetricsQueries tab in your destination Excel file on the [row you prepared](/v1/docs/how-to-export-supermetrics-queries-from-google-sheets-to-excel#step-1-prepare-the-excel-file).
6. In the pasted row, delete the values in the cells for Query ID, Sheet name, and Range address.
7. Scroll to the far right to find the Range address (static) column (column AO).
8. Add the cell location you want for the query’s results into this column, and the name of the sheet where you want them to appear in the Sheet name column.
9. Scroll right to the Refresh with account column (column AU). Copy the value there into column AT, and then delete what was in column AU.
10. If any of these values have been rendered as scientific notation, remove the contents on the row, [prepare the row](/v1/docs/how-to-export-supermetrics-queries-from-google-sheets-to-excel#step-1-prepare-the-excel-file) again, and paste the copied row as values only.
11. Highlight the query row and click **Refresh all** in the Supermetrics sidebar.