This article will explain how to separate humidity and temperature into 2 cells for graphing, analyzing in Excel.
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® (www.imonnit.com) 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 boxes at the top right of the sensor information window. Next, select the data you want to be displayed including “Raw Data” as one of the choices, then select the export tab. Choose “Data from This Sensor” then click the “Export Data” button to save the .csv file to your computer.
Open the saved CSV file in Microsoft Excel. The humidity sensors’ data appears in two columns in the spreadsheet. The “Text” column shows the information of the sensor as it was presented to you in the iMonnit online portal (%RH @ Temperature). The raw sensor data is also found in the “Raw 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 “Raw Data” column. To do this, select the column after “Raw Data” to highlight it. Once highlighted, click on the Excel menu item titled “Insert” then select “Column”.
Next we will separate the sensor data into two fields by highlighting the “Data” column, then select the Excel menu item titled “Raw Data” and choose “Text to Columns”.
From the pop-up window select “Delimited” then click the “Next” button.
On the next screen, select “Comma” as the delimiter then click the “Next” button.
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.