Overview

Data collected using sensemetrics can be accessed directly from Microsoft Excel using the Excel Add-In. This tool is only available for Excel 2014 and newer.

Note: An active account is required to use the Excel Add-in. 

 

Using the sensemetrics Excel Add-in

 

1. Navigate to the Insert tab in Excel.

 

 

2. Select the Sensemetrics Excel Add-in from the drop-down Add-in list.

Note: You may have to search for Sensemetrics using the available search field to find the Sensemetrics add-in.

 

3. Navigate to the Home tab in Excel.

4. The Sensemetrics Excel Add-in should now be available on the right side of the toolbar. Click the button to open up the module.

 

 

5. Enter your API key and press Connect to access your data. Your API key can also be found by navigating to Settings -> Developers within the iTwin IoT app, as shown below.

 

You will now have access to all sensors contained within your account.

Select sensors, metrics, and date ranges, to import data into Excel. The tools are very similar to the export tools used in the Tables module.