# How to send data to excel

**URL:** <https://discourse.nodered.org/t/how-to-send-data-to-excel/13465>\
**Category:** General\
**Created:** [19 July 2019 05:06 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465 "2019-07-19T05:06:48Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [19 July 2019 05:06 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/1 "2019-07-19T05:06:48Z")

</div>

Hi, I am trying to send data of [wireless temperature and humidity sensor](https://store.ncd.io/product/industrial-long-range-wireless-temperature-humidity-sensor/) to excel.  
I have created nodes

 ![error1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/a/ab4f3076e9e981f4b116e8f54a943939752b93ab.jpeg)

here I have used here function node

 ![error2](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/6/61dcbf66fa4cd2bd2a819e0948b7abe0aacb6100.jpeg)

and file node to save data.

but i am unable to get data in excel.

please suggest me which nodes are good for it.

Thanx in advance.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [19 July 2019 06:21 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/2 "2019-07-19T06:21:06Z")

</div>

You are saving it as an Array, try keeping it as an object and then use the CSV node to convert it to comma separated values before using the file-out node

---

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [19 July 2019 06:24 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/3 "2019-07-19T06:24:35Z")

</div>

Can you please share the flow.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [19 July 2019 06:26 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/4 "2019-07-19T06:26:21Z")

</div>

No I'm on my phone.  
Have a play, given the suggestions above and debug nodes you should get there in a couple of minutes

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [19 July 2019 07:03 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/5 "2019-07-19T07:03:42Z")

</div>

Instead of `payload:[m]` try `payload:m` in your function node.

---

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [22 July 2019 06:53 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/6 "2019-07-22T06:53:25Z")

</div>

Hi, Thanx for the suggestion.I tried this

 ![error1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/7/708bbc8e05e5b9341b78b457654b570a9dc0594f.jpeg)

But I am getting values like this

 ![error2](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/6/62eb1f4c988dd04eb8cf94776b38ecb264a46fa2.jpeg)

Please help me out to get values in proper way.

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [22 July 2019 07:03 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/7 "2019-07-22T07:03:29Z")

</div>

Did you then feed it through a CSV node as was suggested ?

---

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [22 July 2019 08:08 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/8 "2019-07-22T08:08:50Z")

</div>

Yes, But when I am connecting the CSV node, Then I am not getting any values.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [22 July 2019 08:12 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/9 "2019-07-22T08:12:57Z")

</div>

So what does your flow look like with the csv node?

---

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [22 July 2019 08:19 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/10 "2019-07-22T08:19:48Z")

</div>

This one

 ![error3](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/1/124b83c4de8cf65b6e1208e835c0f7bc933bb4ea.jpeg)

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [22 July 2019 08:22 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/11 "2019-07-22T08:22:54Z")

</div>

Given you are only wanting to write two values, then your original function was 99% correct. You just needed to change the `[m]` for `m` in the return statement. Then you can forget about the CSV node.

---

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [22 July 2019 08:25 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/12 "2019-07-22T08:25:58Z")

</div>

I am getting values like this

 ![error4](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/1/1033de72ffa2f1b3253f73aed4847ae6882c83c7.jpeg)  
But I want the first row as heading like Temperature and humidity

---

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [22 July 2019 08:26 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/13 "2019-07-22T08:26:17Z")

</div>

Yes i have done that.

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [22 July 2019 10:49 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/14 "2019-07-22T10:49:01Z")

</div>

In the file node you can turn off the append line ending, as you are getting extra blank lines you don’t need.  
There is no easy way to just add the headings once. Easiest I probably just to create the initial empty file with just the headings in then let the flow append lines after that.

---

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [22 July 2019 11:33 UTC](https://discourse.nodered.org/t/how-to-send-data-to-excel/13465/15 "2019-07-22T11:33:00Z")

</div>

is there any another way to write once headings, something like the code in javascript.