# Copying an Excel file to a table's dataset

**URL:** <https://forum.inductiveautomation.com/t/copying-an-excel-file-to-a-tables-dataset/34942>\
**Category:** Ignition\
**Created:** [May 21, 2020, 3:38pm UTC](https://forum.inductiveautomation.com/t/copying-an-excel-file-to-a-tables-dataset/34942 "2020-05-21T15:38:18Z")\
**Posts on this page:** 1\
**Showing post:** 38

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [January 18, 2022, 1:12pm UTC](https://forum.inductiveautomation.com/t/copying-an-excel-file-to-a-tables-dataset/34942/38 "2022-01-18T13:12:33Z")

</div>

I just tried the `openpyxl` library and it works in Ignition 8.1.  
Version 2.6.4 is the last one to support Python 2.7.  
If anyone wants to try…  
[openpyxl-2.6.4.zip](https://forum.inductiveautomation.com/uploads/short-url/jo7uXmP9CZYEjBWW3OVdiT9TPtv.zip) (1.1 MB)

Just copy everything in the .zip file into the `C:\Program Files\Inductive Automation\Ignition\user-lib\pylib` folder under Windows.

[https://openpyxl.readthedocs.io/en/stable/](https://openpyxl.readthedocs.io/en/stable/)

---

_[View the full topic](https://forum.inductiveautomation.com/t/copying-an-excel-file-to-a-tables-dataset/34942)._