Saving a JSON array in an excel file


Currently I'm doing a project where a sensor captures the distance in relation to time. My current problem lies in saving this data to an excel table, I am currently using this node (, and this is giving me the result of the image sent,tabela

It's just a value for each column, would i like to know how I can solve this problem? would require that the distance be in one column and the time in another respectively.




If you mean you want something like?

     distancia    temp
     10               28
     20               38
     30               48

Then I think you need to store the data together and then send it to the excel node.

Another way of achieving an excel compatible file would be to write it as csv ( comma separated file)
where you can create format each line and then add it to an existing file using the FILE-out node


gonna try this, when i did i will answer you! thanks


The csv node will convert well formed JSON into CSV which you can then easily save to a spreadsheet if needed.