# Displaying specific data or cells from our excel/CSV file into a chart and text in node-red

**URL:** <https://discourse.nodered.org/t/displaying-specific-data-or-cells-from-our-excel-csv-file-into-a-chart-and-text-in-node-red/20610>\
**Category:** Dashboard\
**Created:** [20 January 2020 07:13 UTC](https://discourse.nodered.org/t/displaying-specific-data-or-cells-from-our-excel-csv-file-into-a-chart-and-text-in-node-red/20610 "2020-01-20T07:13:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nicsalabado](https://avatars.discourse-cdn.com/v4/letter/n/898d66/32.png) [@nicsalabado](https://discourse.nodered.org/u/nicsalabado)\
**Post date:** [20 January 2020 07:13 UTC](https://discourse.nodered.org/t/displaying-specific-data-or-cells-from-our-excel-csv-file-into-a-chart-and-text-in-node-red/20610/1 "2020-01-20T07:13:24Z")

</div>

Hi! We want to connect and display specific data or cells from our excel/CSV file into a chart and text in node-red. We also need to make a separate chart for each row.  
Can you please help us? Thank you so much!

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/c/9c961724b4f5bfe8f73acfe031f7ff48555aff17.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/8/7862d8b4b43fc312cda2657692deacd53d24eee4.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/c/bc4be0738730d0fe4b553582b590db5a39a514a9.png)

---

<div class="post-metadata">

**Author:** ![edje11](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/edje11/32/572_2.png) [@edje11](https://discourse.nodered.org/u/edje11)\
**Post date:** [20 January 2020 08:35 UTC](https://discourse.nodered.org/t/displaying-specific-data-or-cells-from-our-excel-csv-file-into-a-chart-and-text-in-node-red/20610/2 "2020-01-20T08:35:19Z")

</div>

It's not clear what node you are using to open the excel file, but if you are using `node-red-contrib-spreadsheet-in` then there should be a sample in your sample directory and with this sample it should be easy to get started.

---

<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:** [20 January 2020 08:47 UTC](https://discourse.nodered.org/t/displaying-specific-data-or-cells-from-our-excel-csv-file-into-a-chart-and-text-in-node-red/20610/3 "2020-01-20T08:47:04Z")

</div>

If it's just a csv file then the file in node (as you have) followed by a csv node will split up the lines into separate messages. If you then need 5 charts you will need to direct each to their own chart - you cannot auto generate an unknown number of charts - they all need to exist in advance. (so if your file size changes then this won't work).

But then you don't say what type of chart or which data you are trying to plot...

---

<div class="post-metadata">

**Author:** ![nicsalabado](https://avatars.discourse-cdn.com/v4/letter/n/898d66/32.png) [@nicsalabado](https://discourse.nodered.org/u/nicsalabado)\
**Post date:** [21 January 2020 01:59 UTC](https://discourse.nodered.org/t/displaying-specific-data-or-cells-from-our-excel-csv-file-into-a-chart-and-text-in-node-red/20610/4 "2020-01-21T01:59:38Z")

</div>

Sorry, I am using a **file in node** to open my excel file.  
I've already installed a `node-red-contrib-viseo-google-spreadsheet-in` is it okay or I have to uninstall the `node-red-contrib-viseo-google-spreadsheet-in` first before installing the `node-red-contrib-spreadsheet-in`? I am worried that it might cause conflict if ever I install it.