Download data

[lorasevilla111]

Hi mates

We run into a problem we can´t solve and it gets us really stuck. I hope any of you could help us out with this. In our project, we are using temperature sensors to survey a certain area. We are getting loads of information every single day and we need to put them into an excel doc in order to manage with them properly. When we download the information we already get it in an excel, though all rows are placed in the same box, being the data from every column separated by a comma. We need to get them information in independent columns for statistics/presentation purposes. Do you know if there is any toll that helps with this?
Looking forward your answer. Thanks in advance

[shramik_salgaonkar]

i did not understand what you mean by above, can you share a screenshot for what you mean.

[jameszahary]

Here is some info on fetching data to a spreadsheet.

CayExcel - REST API Tutorial / Demo using Excel VBA

This is an Excel spreadsheet with some VBA code, that that gives you simple access to all your Cayenne data inside a spreadsheet with just your username/password, and a few clicks. You can load hour/day/week data series of your sensors, send data to Cayenne which can control your devices, and build fancy displays with text and graphics containing current values and history of your sensors. It essentially gives access to your data without going through the website. It is just a spreadsheet, no…

GitHub - jameszah/CayExcel: CayExcel - REST API Tutorial / Demo using Excel...