# Sending data from node-red to xlsx file on windows 10
**URL:** https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674
**Category:** General
**Created:** [27 July 2022 08:39 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674 "2022-07-27T08:39:29Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Aldryan](https://discourse.nodered.org/u/Aldryan)
#### Post date: [27 July 2022 08:39 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674/1 "2022-07-27T08:39:29Z")
Hello, I'm still very new to Node-red and am confused on how to create a xlsx file and update it through the flow
Basically, I tried to recreate a flow from this reference
> **[Node-RED to Excel](https://www.hackster.io/rjrajbir/node-red-to-excel-98c840)**
>
> Sending data of wireless temperature and humidity sensor to Excel. By Rajbir Singh.
I modify the input to just a timestamp with a moment node(node-red-contrib-moment) and connect it to csv then to the file node. This is my flow:
When I deployed the flow and clicked the time stamp, there is a payload but no xlsx file was created/updated (when I manually create the file).
FYI, I use siemens IoT 2050 to connect to node-red and on windows 10 (idk if there is a difference)
---
### Author:  [@grant1](https://discourse.nodered.org/u/grant1)
#### Post date: [27 July 2022 09:46 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674/2 "2022-07-27T09:46:03Z")
I believe there might be an issue with permissions to the C-drive folder you specified, or maybe the format. Can you try a few variations, for example..
`c:/file.csv` or `c:\\file.csv`
(try a .csv first...once that works, change to .xlsx)
Just a crazy suggestion...rather than sending to Excel (once an hour, once a day, etc.), why not send to a free InfluxDB database and view it via free Grafana? I started using Node-RED for a similar task (temperature readings) and [this video](https://www.youtube.com/watch?v=JdV4x925au0) helped me get started with the NR+Influx+Grafana trio.
---
### Author:  [@Aldryan](https://discourse.nodered.org/u/Aldryan)
#### Post date: [27 July 2022 10:28 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674/3 "2022-07-27T10:28:22Z")
Hi, thanks for the reply!
I tried to change the path format, the file extension, and change the path from C to my D-drive. But all that doesn't seem to work.
Thanks for the suggestion, but on this project one of the objectives that are given to me is to create a .csv or .xlsx file from the node-red. Do you mind trying my flow and see whether there is a problem? this is my flow as of now.
```auto
[{"id":"ee64ddc4.82773","type":"tab","label":"Flow 3","disabled":false,"info":""},{"id":"f4ed7228.1727","type":"inject","z":"ee64ddc4.82773","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":160,"y":140,"wires":[["d3c27fc0.e81ec"]]},{"id":"d3c27fc0.e81ec","type":"moment","z":"ee64ddc4.82773","name":"","topic":"","input":"","inputType":"msg","inTz":"Asia/Jakarta","adjAmount":"0","adjType":"hours","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"en_gb","output":"","outputType":"msg","outTz":"Asia/Jakarta","x":360,"y":140,"wires":[["3839708f.ea64a","a44f5.508d8b0b8"]]},{"id":"3839708f.ea64a","type":"debug","z":"ee64ddc4.82773","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":570,"y":240,"wires":[]},{"id":"c1158bc0.daaa38","type":"file","z":"ee64ddc4.82773","name":"TestNodered","filename":"\\Users\\Aldryan Minanto\\Documents\\TestNodered.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"utf8","x":830,"y":140,"wires":[["c7cbf44b.daef48"]]},{"id":"c7cbf44b.daef48","type":"debug","z":"ee64ddc4.82773","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1010,"y":240,"wires":[]},{"id":"a44f5.508d8b0b8","type":"csv","z":"ee64ddc4.82773","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\r\\n","temp":"Time","skip":"0","strings":true,"include_empty_strings":false,"include_null_values":false,"x":630,"y":140,"wires":[["c1158bc0.daaa38","a1f60d30.79f07"]]},{"id":"a1f60d30.79f07","type":"debug","z":"ee64ddc4.82773","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":790,"y":240,"wires":[]}]
```
Or maybe if you have a similar flow, do you mind sharing it? thank you again for the help!
---
### Author:  [@grant1](https://discourse.nodered.org/u/grant1)
#### Post date: [27 July 2022 11:32 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674/4 "2022-07-27T11:32:57Z")
@Aldryan Thanks for the flow. I got it to work with the following (on my PC)...
Filename (in Write File node): `F:\Users\USER\Documents\NodeRedTestFolder\NodeRed.csv`
(adapt to a folder of your choice on your Windows PC)
I also had to change the permissions to the folder (to "Full control"):
---
### Author:  [@Aldryan](https://discourse.nodered.org/u/Aldryan)
#### Post date: [27 July 2022 12:34 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674/5 "2022-07-27T12:34:59Z")
Hi, I'm glad that my flow is working fine, I've tried to change the file path and the permissions of the folder, but it's still not working. Are there any other external factors that I need to change?
---
### Author:  [@grant1](https://discourse.nodered.org/u/grant1)
#### Post date: [27 July 2022 13:23 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674/6 "2022-07-27T13:23:47Z")
Do you have any errors appearing in the Debug pane?
---
### Author:  [@Aldryan](https://discourse.nodered.org/u/Aldryan)
#### Post date: [27 July 2022 15:15 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674/7 "2022-07-27T15:15:46Z")
Not that I could see, I hope this gif could explain my current situation.
Uploading: Part 2.gif...
---
### Author:  [@Aldryan](https://discourse.nodered.org/u/Aldryan)
#### Post date: [27 July 2022 15:16 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674/8 "2022-07-27T15:16:47Z")
Part 2 of the gif
---
### Author:  [@grant1](https://discourse.nodered.org/u/grant1)
#### Post date: [27 July 2022 15:29 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674/9 "2022-07-27T15:29:40Z")
As you do not have any errors in your debug pane, I believe your flow in Node-RED is fine. Your problem must be related to your Windows permissions. Keep trying different combinations, folder locations, (even a USB drive), etc.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [25 September 2022 15:30 UTC](https://discourse.nodered.org/t/sending-data-from-node-red-to-xlsx-file-on-windows-10/65674/10 "2022-09-25T15:30:01Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.