# Newbie need Help with an export to Excel

**URL:** <https://discourse.nodered.org/t/newbie-need-help-with-an-export-to-excel/68987>\
**Category:** General\
**Created:** [13 October 2022 13:19 UTC](https://discourse.nodered.org/t/newbie-need-help-with-an-export-to-excel/68987 "2022-10-13T13:19:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![makro01](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/makro01/32/68994_2.png) [@makro01](https://discourse.nodered.org/u/makro01)\
**Post date:** [13 October 2022 13:19 UTC](https://discourse.nodered.org/t/newbie-need-help-with-an-export-to-excel/68987/1 "2022-10-13T13:19:11Z")

</div>

Hello,  
I'm brand new to Node-Red. I got most things from my themp and voltet measurements.  
Now I want to start a new project. I send a request to my car and I want to automatically write it to an Excel spreadsheet at the same time every day, Date KM % Battery Remaining Battery  
I've already tried something, but only one piece of information arrived in Excel and only in one line.  
So I hope someone can help me to make my project fly 🙂

> [{"id":"6566300f.c3f59","type":"debug","z":"7cd76bbd.117da4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":990,"y":860,"wires":},{"id":"f705fd8.b0d16","type":"change","z":"7cd76bbd.117da4","name":"","rules":[{"t":"set","p":"ts","pt":"msg","to":"","tot":"date"},{"t":"set","p":"ts","pt":"msg","to":"$moment(ts).locale("de").tz('Europe/Berlin').format('DD.MM.YYYY HH:mm:ss')","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"ts & ';' & msg.payload.data.attributes.totalMileage\t","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"ts & ';' & msg.payload.data.attributes.batteryLevel\t","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"ts & ';' & msg.payload.data.attributes.batteryAutonomy\t","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":590,"y":960,"wires":[["52b2ab1d8d89182d"]]},{"id":"eb4feda0e69229ce","type":"inject","z":"7cd76bbd.117da4","name":"battery-Level","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"battery-status","payload":"data.attributes.batteryLevel","payloadType":"str","x":90,"y":880,"wires":[["7c9baca42ac959fe"]]},{"id":"d6d81effee406b69","type":"inject","z":"7cd76bbd.117da4","name":"battery-rest","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"battery-status","payload":"data.attributes.batteryAutonomy","payloadType":"str","x":90,"y":940,"wires":[["7c9baca42ac959fe"]]},{"id":"9c899ce1e6464984","type":"inject","z":"7cd76bbd.117da4","name":"Kilometer","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"cockpit","payload":"payload.data.attributes.totalMileage","payloadType":"str","x":100,"y":1000,"wires":[["7c9baca42ac959fe"]]},{"id":"85bef2c0834b9529","type":"join","z":"7cd76bbd.117da4","name":"","mode":"custom","build":"object","property":"topic","propertyType":"msg","key":"payload","joiner":"\n","joinerType":"str","accumulate":true,"timeout":"","count":"1","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"num","reduceFixup":"","x":510,"y":860,"wires":[["f705fd8.b0d16","6566300f.c3f59"]]},{"id":"7c9baca42ac959fe","type":"renault-ze","z":"7cd76bbd.117da4","name":"Dacia Spring","x":350,"y":1000,"wires":[["85bef2c0834b9529"]]},{"id":"52b2ab1d8d89182d","type":"excel","z":"7cd76bbd.117da4","name":"Auto","file":"/data/user/Auto.xlsx","x":830,"y":940,"wires":[["6566300f.c3f59"]]}]

 ![auto](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/7/47855d277ef63bb157944796414060429af20f65.png)

I hop its ok , I ask the 3 Informations over API from the Car and then I want it to put it in excel in one Line and the next day in the next line and so on.  
Rregards Markus  
sorry for the english is not my first language 🙂

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [12 December 2022 13:19 UTC](https://discourse.nodered.org/t/newbie-need-help-with-an-export-to-excel/68987/2 "2022-12-12T13:19:38Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.