Import Data

Starting in Strategy One (August 2025), you can import live connect datasets into Sheets.

Starting in Strategy One (July 2025), you can import Mosaic models into Sheets.

Strategy for Google Sheets™ enables you to import data from dashboards, reports, datasets, and cubes in a raw tabular data form.

1. Connect to Strategy for Google Sheets™.

2. Select a starting cell and click Import Data.

3. The import window displays. Browse content in the Library Web view to select your source objects from the smart view or Content Discovery.

4. Import data depending on the selected content:

   1. For datasets, cubes, reports, Mosaic models, and starting in Strategy One (August 2025), live connect datasets, select an object and click Import Data. If you want to refine the data, you can Prepare Data Before Importing.

      Prepare Data is only available for reports.

      

   2. For dashboards:

      1. Select a dashboard and click Import.

      2. Go to your desired page and modify filters, if needed.

      3. Choose a visualization and click Import.

         

5. If the selected cell range is already populated, the Import Destination dialog displays. Select one of the following two options:

   1. Active Cell: Select a new cell to import data.

   2. New Sheet: A new sheet containing your data is created.

   Imported objects display on the add-in side panel.

6. To view your data's imported object and source details, click an object in the add-in panel and expand the Show Details drop-down list.