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.

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.
   
   
5. Paste the row as values only into the SupermetricsQueries tab in your destination Excel file on the row you prepared. 
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 again, and paste the copied row as values only.
11. Highlight the query row and click Refresh all in the Supermetrics sidebar.