# Import existing excel data

**URL:** <https://forum.inductiveautomation.com/t/import-existing-excel-data/91499>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 6, 2024, 4:58pm UTC](https://forum.inductiveautomation.com/t/import-existing-excel-data/91499 "2024-06-06T16:58:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mihaly\_Sztojka](https://avatars.discourse-cdn.com/v4/letter/m/bc79bd/32.png) [@Mihaly\_Sztojka](https://forum.inductiveautomation.com/u/Mihaly_Sztojka)\
**Post date:** [June 6, 2024, 4:58pm UTC](https://forum.inductiveautomation.com/t/import-existing-excel-data/91499/1 "2024-06-06T16:58:38Z")

</div>

Hi ,

Is it possible to use column values from an existing excel in Ignition (which is on my own computer)?

Thanks

---

<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:** [June 6, 2024, 5:22pm UTC](https://forum.inductiveautomation.com/t/import-existing-excel-data/91499/2 "2024-06-06T17:22:17Z")

</div>

> [@Mihaly\_Sztojka](#):
>
> which is on my own computer

You would have to use a file upload component to push it into Ignition. You would then typically load the bytes of the file in the Apache POI library (provided with Ignition) to extract what you wish from the spreadsheet. Then push that information into tags or database tables that the rest of Ignition can use.

---

<div class="post-metadata">

**Author:** ![Kevin\_Flener](https://avatars.discourse-cdn.com/v4/letter/k/74df32/32.png) [@Kevin\_Flener](https://forum.inductiveautomation.com/u/Kevin_Flener)\
**Post date:** [June 6, 2024, 5:58pm UTC](https://forum.inductiveautomation.com/t/import-existing-excel-data/91499/3 "2024-06-06T17:58:01Z")

</div>

What are you trying to accomplish with the file?

Write the column values to a database? Use in a component?

More information goes a long way towards directing the solution.

---

<div class="post-metadata">

**Author:** ![Mihaly\_Sztojka](https://avatars.discourse-cdn.com/v4/letter/m/bc79bd/32.png) [@Mihaly\_Sztojka](https://forum.inductiveautomation.com/u/Mihaly_Sztojka)\
**Post date:** [June 10, 2024, 6:29pm UTC](https://forum.inductiveautomation.com/t/import-existing-excel-data/91499/4 "2024-06-10T18:29:54Z")

</div>

I want to run an API for loop with the column values and use the data from the API response  
example in python:

```python
excel_file = 'data.xlsx'
df = pd.read_excel(excel_file)

column_values = df['A'].tolist()

api_url = 'https://api.example.com/data'

for value in column_values:
    response = requests.get(f"{api_url}?param={value}")

```