Import Data

Starting in MicroStrategy ONE (March 2024), you can import visualizations as an image.

MicroStrategy for Office enables you to import reports, datasets, and dashboards from MicroStrategy to Excel.

1. Connect to the MicroStrategy for Office add-in. MicroStrategy for Office opens in a sidebar.
2. Select a starting cell.
3. Click Import Data.
4. By default, you are in Library where you can search for a report, dataset, or dashboard. You can also use the folder view in Content Discovery to browse.
5. Import data depending on the content:
   1. For datasets and reports, select a dataset or report and click Import or if you want to refine the data, click Prepare Data.
   2. For dashboards:
      1. Select a dashboard and click Import.
      2. Update pages and modify filters, if needed.
      3. Select a visualization and click Import.
      4. Starting in MicroStrategy ONE (March 2024), if you want to import a visualization as an image, select a visualization and click Import Image.

6. 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.

     

7. You can now see the imported object in the add-in sidebar. If you click on it, 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.