# Import data from excel inside the table component

**URL:** <https://forum.inductiveautomation.com/t/import-data-from-excel-inside-the-table-component/94028>\
**Category:** Ignition\
**Tags:** database, perspective, scripting\
**Created:** [August 1, 2024, 9:57am UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-inside-the-table-component/94028 "2024-08-01T09:57:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sakshi\_Gupta](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@Sakshi\_Gupta](https://forum.inductiveautomation.com/u/Sakshi_Gupta)\
**Post date:** [August 1, 2024, 9:57am UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-inside-the-table-component/94028/1 "2024-08-01T09:57:54Z")

</div>

Hello community, hope you are well!  
I want to know if there's a way to import the data into the table component of ignition perspective.  
For Adding data in bulk , adding one row at a time becomes tedious, hence wanted to try if we can just import excel so that huge chunk of data is added to my table in one go.  
Thanks.

---

<div class="post-metadata">

**Author:** ![Alexi\_Andrzejewski](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alexi_andrzejewski/32/65032_2.png) [@Alexi\_Andrzejewski](https://forum.inductiveautomation.com/u/Alexi_Andrzejewski)\
**Post date:** [August 1, 2024, 12:31pm UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-inside-the-table-component/94028/2 "2024-08-01T12:31:59Z")

</div>

I don't think Excel has a built-in feature for exporting to json wich i think is the easiest format.

However here is an online tool I found to convert CSV to JSON

> **[CSV To JSON Converter](https://www.convertcsv.com/csv-to-json.htm)**
>
> Convert CSV data to JSON. TSV to JSON

By the way I dosn't have to be csv, xlsx files works as well

I you prefer not give away private data Microsoft gave an example of a script to use to convert your excel file to json

> **[Output Excel data as JSON - Office Scripts](https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/get-table-data)**
>
> Learn how to output Excel table data as JSON to use in Power Automate.

Once your table converted, you can juste copy-paste it to the props.data property of your table component

---

<div class="post-metadata">

**Author:** ![Sakshi\_Gupta](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@Sakshi\_Gupta](https://forum.inductiveautomation.com/u/Sakshi_Gupta)\
**Post date:** [August 1, 2024, 12:51pm UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-inside-the-table-component/94028/3 "2024-08-01T12:51:54Z")

</div>

@Alexi_Andrzejewski i want to push(import) data into the table by importing an excel file into perspective table, so that i dont have to manually keep entering each row of my table

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 1, 2024, 12:53pm UTC](https://forum.inductiveautomation.com/t/import-data-from-excel-inside-the-table-component/94028/4 "2024-08-01T12:53:12Z")

</div>

You can use a File Upload component to get the Excel File into Ignition. In the file received event, you would push the file bytes into the Apache POI libraries, from which you can loop through the workbooks sheets and rows and columns **however you like**. But you have to write some jython.

Various discussions of how to do this, with scattered examples:

[https://forum.inductiveautomation.com/search?q=file%20upload%20apache%20poi%20order%3Alatest](https://forum.inductiveautomation.com/search?q=file%20upload%20apache%20poi%20order%3Alatest)

If you'd like to study a particularly complex example, you may find this interesting:

> [@Spreadsheet Import Tool](https://forum.inductiveautomation.com/t/spreadsheet-import-tool/93500):
>
> While waiting on IA review, interested parties can get this here: [https://www.automation-pros.com/SpreadsheetImportTool/](https://www.automation-pros.com/SpreadsheetImportTool/) I intend to publish at this link as well as in the Exchange going forward. Announcements will be in this topic. (: