# Excel data to a tables Dataset

**URL:** <https://forum.inductiveautomation.com/t/excel-data-to-a-tables-dataset/62951>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [August 12, 2022, 12:38pm UTC](https://forum.inductiveautomation.com/t/excel-data-to-a-tables-dataset/62951 "2022-08-12T12:38:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [August 12, 2022, 12:38pm UTC](https://forum.inductiveautomation.com/t/excel-data-to-a-tables-dataset/62951/1 "2022-08-12T12:38:42Z")

</div>

Hello, I want to know if it is possible copying a Excel file to a tables Dataset in ignition perspective

---

<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 12, 2022, 12:46pm UTC](https://forum.inductiveautomation.com/t/excel-data-to-a-tables-dataset/62951/2 "2022-08-12T12:46:25Z")

</div>

Yes, but not without considerable custom code. Ignition includes the Apache POI libraries that can work with Office documents. The script would typically be tied to Perspective’s file upload component, and would need to explicitly pick out the parts of the spreadsheet that would become columns in the dataset. There’s no “generic” script for this.

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [August 12, 2022, 12:55pm UTC](https://forum.inductiveautomation.com/t/excel-data-to-a-tables-dataset/62951/3 "2022-08-12T12:55:59Z")

</div>

@JordanCClark created a script that should get you started,

> [@Copying a Excel file to a tables Dataset](https://forum.inductiveautomation.com/t/copying-a-excel-file-to-a-tables-dataset/34942/12):
>
> For another option re: reading Excel files, I started and never finished an Ignition module that brings in the [fastexcel](https://github.com/dhatim/fastexcel) library: [https://github.com/paul-griffith/kotlin-module](https://github.com/paul-griffith/kotlin-module)