Hope I am not the only one with this problem. When I extract the data from insights about the temperature (for example, from my Honeywell thermostats and the weather) I get very strange coded info in the CSV. I have looked at the data in Notepad++, where it all looks fine. But when I try to use it in excel (to create graphs) I cannot work with it at all. For example, a string of the temperature will be:
As can be seen, the first temperature is correct (18,5), the measured Temp is shown as 2 trillion or something and the weather temp as 76 trillion. I can’t work with this as there is no simple reformatting available. (e.g. Measured temp shall be 20,78 and Outside Temp is 7,6 degrees)
How come this info is so badly formatted? What can be done about it?