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.
- Open the Supermetrics sidebar in the Google Sheets file you want to copy queries from.
- Open the SupermetricsQueries tab (if this is hidden, navigate to Extensions → Supermetrics → Manage queries to open it).
- Find the row with the query you want to export.
- Highlight the full row and copy it.
- Paste the row into the SupermetricsQueries tab in your destination Excel file. Learn how to view the SupermetricsQueries tab in Excel.
- In the pasted row, delete the values in the cells for Query ID, Sheet name, and Range address.
- Scroll to the far right to find the Range address (static) column (column AO).
- 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.
- 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.
- If any of these values have been rendered in scientific notation, convert the cell to text.
- Highlight the query row and click Refresh all in the Supermetrics sidebar.