# Import and display a text/csv file in Node-RED dashboard

**URL:** https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622
**Category:** Dashboard
**Created:** [7 November 2019 08:22 UTC](https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622 "2019-11-07T08:22:49Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Jude.Robise](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jude.robise/32/13970_2.png) [@Jude.Robise](https://discourse.nodered.org/u/Jude.Robise)
#### Post date: [7 November 2019 08:22 UTC](https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622/1 "2019-11-07T08:22:50Z")

</div>

How do I **import** and **display** a **text** or **csv** file into the node red **dashboard**? Display as in columns would be great.

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [7 November 2019 08:38 UTC](https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622/2 "2019-11-07T08:38:57Z")

</div>

You have asked how to do two separate things. Which don't you know how to do and what have you tried so far?

---

<div class="post-metadata">

### Author: ![Jude.Robise](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jude.robise/32/13970_2.png) [@Jude.Robise](https://discourse.nodered.org/u/Jude.Robise)
#### Post date: [7 November 2019 08:50 UTC](https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622/3 "2019-11-07T08:50:24Z")

</div>

I'm trying to import csv file to dashboard (with columns if possible). How to do it? Thanks for the reply.

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [7 November 2019 09:04 UTC](https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622/4 "2019-11-07T09:04:32Z")

</div>

As I said, that is two tasks. First read the file, second display it.

---

<div class="post-metadata">

### Author: ![Jude.Robise](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jude.robise/32/13970_2.png) [@Jude.Robise](https://discourse.nodered.org/u/Jude.Robise)
#### Post date: [7 November 2019 09:10 UTC](https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622/5 "2019-11-07T09:10:20Z")

</div>

okay. I read the file using csv file. I want to display it in the dashboard.

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [7 November 2019 09:18 UTC](https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622/6 "2019-11-07T09:18:24Z")

</div>

If you search the node red flows library for 'table' you will find there is node-red-contrib-ui-table which you may find useful.

---

<div class="post-metadata">

### Author: ![Jude.Robise](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jude.robise/32/13970_2.png) [@Jude.Robise](https://discourse.nodered.org/u/Jude.Robise)
#### Post date: [7 November 2019 09:32 UTC](https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622/7 "2019-11-07T09:32:49Z")

</div>

okay I added it. I will try to do it. thanks a lot in advance for the help.

---

<div class="post-metadata">

### Author: ![Jude.Robise](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jude.robise/32/13970_2.png) [@Jude.Robise](https://discourse.nodered.org/u/Jude.Robise)
#### Post date: [7 November 2019 10:10 UTC](https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622/8 "2019-11-07T10:10:35Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/a/af4e99521c85da7097249f130a1368c2d5e2cac9.png)

---

<div class="post-metadata">

### Author: ![Jude.Robise](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jude.robise/32/13970_2.png) [@Jude.Robise](https://discourse.nodered.org/u/Jude.Robise)
#### Post date: [7 November 2019 10:12 UTC](https://discourse.nodered.org/t/import-and-display-a-text-csv-file-in-node-red-dashboard/17622/9 "2019-11-07T10:12:06Z")

</div>

```auto
[{"id":"67991373.45438c","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"4440c71e.f88f18","type":"ui_table","z":"67991373.45438c","group":"fe9b4de4.dcd72","name":"test","order":11,"width":"0","height":"0","columns":[{"field":"Person ID","title":"Person ID","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"Name","title":"Name","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"Department","title":"Department","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}}],"outputs":0,"cts":false,"x":750,"y":160,"wires":[]},{"id":"6681b08b.4a688","type":"file in","z":"67991373.45438c","name":"Read File","filename":"C:\\Users\\user\\Documents\\Records_Report.csv","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":360,"y":160,"wires":[["e843fa29.885718"]]},{"id":"9a7a7971.dbc4b8","type":"inject","z":"67991373.45438c","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":140,"y":160,"wires":[["6681b08b.4a688"]]},{"id":"e843fa29.885718","type":"csv","z":"67991373.45438c","name":"","sep":",","hdrin":true,"hdrout":false,"multi":"mult","ret":"\\r\\n","temp":"","skip":"0","x":570,"y":160,"wires":[["4440c71e.f88f18"]]},{"id":"fe9b4de4.dcd72","type":"ui_group","z":"","name":"Name list","tab":"da612906.998368","disp":true,"width":"15","collapse":false},{"id":"da612906.998368","type":"ui_tab","z":"","name":"Main-PC","icon":"dashboard","disabled":false,"hidden":false}]

```
