Import Visualization

Starting in MicroStrategy (June 2024), you can customize the import experience withImport Settings and Page-by Settings.

Starting in MicroStrategy ONE (March 2024), the MicroStrategy for Excel add-in enables you to import data from dashboards as a visualization.

1. Connect to the MicroStrategy for Office add-in. MicroStrategy for Office opens in a side panel.
2. Select a starting cell.
3. Click Import Data.
4. The import window appears which allows you to browse content in the Library Web view, where you can select source objects from the smart view or Content Discovery.
5. Select a dashboard and click Import.
6. Navigate to the desired page and adjust filters, if needed.

7. Select a visualization and click Import Visualization or choose Import Visualization from the drop-down.

   

8. If the selected cell range is unavailable, the Import Destination dialog appears asking you to select a new destination for your data. Select one of the following two options:

   • Active Cell: Select a cell in the sheet where you want your data to be imported.

   • New Sheet: A new sheet containing your data will be created.

     

9. Imported objects display on the add-in side panel.

   Starting in MicroStrategy ONE (June 2024), imported content displays on the side panel based on the Excel sheet placement to support simplified content tracking.

   

10. If you click an imported object, it becomes highlighted in the worksheet.

    You can also view your data's imported object and source details by expanding the Show Details drop-down.