# Click PLC information to Excel

**URL:** <https://discourse.nodered.org/t/click-plc-information-to-excel/66249>\
**Category:** General\
**Created:** [9 August 2022 19:58 UTC](https://discourse.nodered.org/t/click-plc-information-to-excel/66249 "2022-08-09T19:58:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rbmgf7](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@rbmgf7](https://discourse.nodered.org/u/rbmgf7)\
**Post date:** [9 August 2022 19:58 UTC](https://discourse.nodered.org/t/click-plc-information-to-excel/66249/1 "2022-08-09T19:58:17Z")

</div>

I'm VERY inexperienced to all of this and after much turmoil I finally got Node-Red to receive data and send text to a Click PLC I have on the shop floor that is currently collecting natural gas usage via MODBUS from an inline gas meter.

I have three sets of data that I would like to merge with a date-time stamp and then send it to Excel. At the moment, I have the PLC sending the info every second.

So far I have the three MQTT payloads going through a JSON parser (converting to object) then to Write File. The values are exporting in a single row instead of in columns. Wondering if I need to use Function to add the date and time? I tried the Inject that works but not sure if that's the best option.

 ![node-red](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/a/fa583e641ef31329e167a0a2f5690a7c4673fb36.png)

---

<div class="post-metadata">

**Author:** ![MecatronicaMADE](https://avatars.discourse-cdn.com/v4/letter/m/ce7236/32.png) [@MecatronicaMADE](https://discourse.nodered.org/u/MecatronicaMADE)\
**Post date:** [9 August 2022 20:48 UTC](https://discourse.nodered.org/t/click-plc-information-to-excel/66249/2 "2022-08-09T20:48:22Z")

</div>

Hi @rbmgf7 first, welcome to Node-RED forum.

1.- there is an option in MQTT in node to "parsed JSON object":

![Screenshot from 2022-08-09 15-39-21](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/6/a65f36ff1809d0d7cf698b841d6c383c224e4062.png)

2.- You should look at this: [Aggregating sensor data with time stamp to save in excel](https://discourse.nodered.org/t/aggregating-sensor-data-with-time-stamp-to-save-in-excel/20629/4)

---

<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:** [8 October 2022 20:49 UTC](https://discourse.nodered.org/t/click-plc-information-to-excel/66249/3 "2022-10-08T20:49:11Z")

</div>

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