\
**Category:** General\
**Created:** [15 January 2021 22:35 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203 "2021-01-15T22:35:32Z")\
**Posts on this page:** 13\
**Page:** 1
**Author:**  [@Gaberiel](https://discourse.nodered.org/u/Gaberiel)\
**Post date:** [15 January 2021 22:35 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/1 "2021-01-15T22:35:33Z")
Hi everyone;
How can I convert excel data to an HTML table?
---
**Author:**  [@edje11](https://discourse.nodered.org/u/edje11)\
**Post date:** [16 January 2021 14:12 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/2 "2021-01-16T14:12:16Z")
Hi,
What did you try?
Have a look at the [node-red-contrib-spreadsheet-in](https://flows.nodered.org/node/node-red-contrib-spreadsheet-in) node.
Play with it in combination with something like [node-red-contrib-jsontohtml](https://node-red-contrib-jsontohtml).
And with some effort you will succeed .
---
**Author:**  [@Gaberiel](https://discourse.nodered.org/u/Gaberiel)\
**Post date:** [16 January 2021 20:14 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/3 "2021-01-16T20:14:10Z")
I'm trying to convert excel data to html file ..but I get this error
here is my flow:
---
**Author:**  [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [16 January 2021 21:46 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/4 "2021-01-16T21:46:35Z")
Is that a File In node you are reading it with? Have you used a debug node to see what it looks like coming out of the file? Is it JSON?
---
**Author:**  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [16 January 2021 21:49 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/5 "2021-01-16T21:49:56Z")
An xls file is a binary format. You cannot simply read the file data and send it to a JSON node. It just won't work.
To confirm what I am saying, use a debug node as @Colin suggests.
Did you try the suggestions by @edje11?
---
**Author:**  [@Gaberiel](https://discourse.nodered.org/u/Gaberiel)\
**Post date:** [16 January 2021 22:15 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/6 "2021-01-16T22:15:49Z")
no not JSON
---
**Author:**  [@Gaberiel](https://discourse.nodered.org/u/Gaberiel)\
**Post date:** [16 January 2021 22:19 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/7 "2021-01-16T22:19:52Z")
HI @edje11 ..the second link doesn't work
> [@edje11](#):
>
> Play with it in combination with something like [node-red-contrib-jsontohtml](https://node-red-contrib-jsontohtml).
---
**Author:**  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [16 January 2021 22:36 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/8 "2021-01-16T22:36:36Z")
> [@Gaberiel](#):
>
> .the second link doesn't work
its in the flows library - same as the first link
> **[node-red-contrib-jsontohtml](https://flows.nodered.org/node/node-red-contrib-jsontohtml)**
>
> A Node Red node for converting json to html
---
**Author:**  [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [17 January 2021 07:21 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/9 "2021-01-17T07:21:15Z")
You have to read the spreadsheet first, using a node that understand Excel, which is what the first link was for.
---
**Author:**  [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [17 January 2021 07:22 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/10 "2021-01-17T07:22:09Z")
> [@Gaberiel](#):
>
> no not JSON
Not much point feeding it into a JSON node then!
---
**Author:**  [@Gaberiel](https://discourse.nodered.org/u/Gaberiel)\
**Post date:** [17 January 2021 14:21 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/11 "2021-01-17T14:21:17Z")
Oh yeah, my bad ..I used node-red-contrib-spreadsheet-in package then "tableify" node and it's working..
Thank you @Colin & @Steve-Mcl & @edje11
---
**Author:**  [@Gaberiel](https://discourse.nodered.org/u/Gaberiel)\
**Post date:** [19 January 2021 16:13 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/12 "2021-01-19T16:13:27Z")
Here is my flow of others who need an example
```auto
[{"id":"9d4b3531.391338","type":"inject","z":"b00215d0.601ab8","name":"","repeat":"","crontab":"","once":false,"topic":"","payload":"","payloadType":"str","x":70,"y":100,"wires":[["1ef482ff.54be1d"]]},{"id":"1ef482ff.54be1d","type":"file in","z":"b00215d0.601ab8","name":"read a spreadsheet file as binary buffer","filename":"file_example_XLS_10.xls","format":"","chunk":false,"sendError":false,"x":310,"y":100,"wires":[["58da0822.79c4a8"]]},{"id":"58da0822.79c4a8","type":"book","z":"b00215d0.601ab8","name":"","x":270,"y":160,"wires":[["ed8b8fb2.0d17c"]]},{"id":"ed8b8fb2.0d17c","type":"sheet","z":"b00215d0.601ab8","name":"","sheetName":"Sheet1","x":330,"y":200,"wires":[["9c0ed110.bc235"]]},{"id":"9c0ed110.bc235","type":"sheet-to-json","z":"b00215d0.601ab8","name":"","raw":"false","range":"","header":"A","blankrows":true,"x":430,"y":240,"wires":[["3870180.425bde8"]]},{"id":"2dad414b.f976fe","type":"e-mail","z":"b00215d0.601ab8","server":"smtp.gmail.com","port":"465","secure":true,"tls":true,"name":"","dname":"Email","x":670,"y":260,"wires":[]},{"id":"3870180.425bde8","type":"tableify","z":"b00215d0.601ab8","name":"","before":"","after":"","tableStyle":"","theadStyle":"","tbodyStyle":"","trStyle":"","tdStyle":"","x":500,"y":280,"wires":[["2dad414b.f976fe","9480b253.bcdbd"]]},{"id":"9480b253.bcdbd","type":"debug","z":"b00215d0.601ab8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":690,"y":320,"wires":[]}]
```
---
**Author:**  [@system](https://discourse.nodered.org/u/system)\
**Post date:** [2 February 2021 16:13 UTC](https://discourse.nodered.org/t/excel-data-to-html-table/39203/13 "2021-02-02T16:13:28Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.