Skip to content

Microsoft Excel importer can import, historize and process monitoring data from Microsoft Excel worksheets.


The Microsoft Excel importer enables you to insert your own data into the predefined tables of the Microsoft Excel template for imports into the CMDB database. Each row represents a configuration item (CI) in, which is created (Instance) or updated (Change) in

Microsoft Excel import template Figure: Microsoft Excel import template


Microsoft Excel data in Figure: Microsoft Excel data in CMDB

The entity name

The name of the Microsoft Excel worksheet defines the entity name for created instances in the database.

The data of an instance or change

The first column of the Microsoft Excel table is reserved for one unique identifier (ID) per instance. You can assign the ID freely using characters, numbers and special characters (no spaces!).

Please make sure that you use the IDs only once per entity. Otherwise you would overwrite data from line X with data from line Y.


To import data from Microsoft Excel into the CMDB you need the following data:

  • URL to your instance to access the database service
  • environment you store your data in
  • API token with write access for the specific environment and instance


The second column shows the return result of the database for every instance. The following database status can be displayed next to potential error messages:

  • created: The database recognized that this is a new instance and created it in the database.
  • updated: The database detected that this is a modified instance and has extended the history of the instance in the database.
  • discarded: The database detected that there is no change to the instance and updates only the time of the import to the database.

How best you start

  1. Donwload MS Excel template from the GitHub repository
  2. Open MS Excel template
  3. Customize your personal settings in the "Settings" tab
    • URL of the server (SaaS is set default)
    • Environment on the platform
    • Personal API Token
  4. Now you start to add data in the other example tabs
  5. Click on the "Import to" button to transfer your data in the MS Excel tab to
  6. Have fun :-)