The following steps will guide you through the process of exporting any Monnit Humidity sensors’ data and modifying the spreadsheet in Microsoft Excel to show separate values for humidity and temperature. This is useful if you are looking to chart the humidity and temperature data independently.

To get started, log into your wireless sensor network account on iMonnit ( then select the humidity sensor from the “Sensor List” that you would like to export data for. Set the date range you want to export data for by clicking in the date box at the top right of the sensor information window, then select the export tab. Choose “Include Data from This Sensor” then click the “Export Data” button to save the .csv file to your computer.

Export Monnit Sensor Data

Open the saved csv file in Microsoft Excel. The humidity sensors’ data appears in two columns in the spreadsheet. The “Text” column show the sensors information as it was presented to you in the iMonnit online portal (%RH @ Temperature). The raw sensor data is also found in the “Data” column with the first number being %RH followed by the temperature in Celsius. The two data points are separated by a comma. To separate this data into two individual columns for charting, we need to start by adding a blank column after the “Data” column. To do this, select the column after “Data” to highlight it. Once highlighted, click on the Excel menu item titled “Insert” then select “Column”.

Insert column

Next we will separate the sensor data into two fields by highlighting the “Data” column, then select the Excel menu item titled “Data” and choose “Text to Columns”.

Choose Text to Columns

From the pop-up window select “Delimited” then click the “Next” button.

Select delimited

On the next screen, select “Comma” as the delimiter then click the “Next” button.

Choose delimiter

Next click the “Finish” button to apply the data changes. Your sensor data will now be separated into the two columns. Simply rename the columns to your preference. You now have separate humidity and temperature data for creating your custom reports or charts in Microsoft Excel.

Rename columns

For more information on using Monnit wireless sensors, visit the support section of our website.