MicroStrategy ONE

Import Settings

Starting in MicroStrategy ONE (June 2024), you can define import settings such as preferred import type, attribute import form, and rules for column merges to improve your import experience.

When you import new data with a defined setting, that setting will be applied if you use Refresh or Duplicate. You should use a new Import, Edit, or Re-prompt option to import data with new settings.

  1. Click More Items in the Excel add-in side panel and click Settings.

  2. Expand the Import section.

  3. In Default import format, choose an import option from the drop-down.

    If the selected option is not valid for the object you want to import, the option will revert to Data.

    The chosen import type will be displayed by default but you can manually change the import type for every import

  4. Toggle on Import data as text to import attributes as text. When this option is turned off, Excel will automatically assign datatypes based on data.

  5. By default, adjacent column headers with identical values are merged in all cross-tab grids. To disable this behavior, toggle off Merge columns.