# Reading my excel data in Processing

**URL:** <https://discourse.processing.org/t/reading-my-excel-data-in-processing/35792>\
**Category:** Beginners\
**Created:** [March 17, 2022, 9:00am UTC](https://discourse.processing.org/t/reading-my-excel-data-in-processing/35792 "2022-03-17T09:00:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![CharrR](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/charrr/32/14589_2.png) [@CharrR](https://discourse.processing.org/u/CharrR)\
**Post date:** [March 17, 2022, 9:00am UTC](https://discourse.processing.org/t/reading-my-excel-data-in-processing/35792/1 "2022-03-17T09:00:40Z")

</div>

Hello, processing newbie here~  
I’m just trying to open my excel data in processing, but have no idea what the code to do this is. I read a little about loadTable and String and printIn, but none of it is making sense to me 😓  
my excel data is saved as a .xlsx file, not sure if i should be converting it to something else…  
Nonetheless, any help at all will be greatly appreciated~  
thank youu

---

<div class="post-metadata">

**Author:** ![matheplica](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/matheplica/32/21035_2.png) [@matheplica](https://discourse.processing.org/u/matheplica)\
**Post date:** [March 17, 2022, 9:07am UTC](https://discourse.processing.org/t/reading-my-excel-data-in-processing/35792/2 "2022-03-17T09:07:04Z")

</div>

On this forum a thread that speak about it : [import xlsx](https://discourse.processing.org/t/import-excel-xlsx-to-processing/9816)

---

<div class="post-metadata">

**Author:** ![CharrR](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/charrr/32/14589_2.png) [@CharrR](https://discourse.processing.org/u/CharrR)\
**Post date:** [March 17, 2022, 9:18am UTC](https://discourse.processing.org/t/reading-my-excel-data-in-processing/35792/3 "2022-03-17T09:18:12Z")

</div>

Hi, i actually saw that forum and read through it, it didnt make much sense to me though. Just asking to see if anyone has a easier to understand solution lol

---

<div class="post-metadata">

**Author:** ![Chrisir](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/chrisir/32/45_2.png) [@Chrisir](https://discourse.processing.org/u/Chrisir)\
**Post date:** [March 17, 2022, 9:43am UTC](https://discourse.processing.org/t/reading-my-excel-data-in-processing/35792/4 "2022-03-17T09:43:52Z")

</div>

You can export/ save as in Excel.

Save as csv text file

This file you can copy into your Sketch folder.

Then loadStrings or loadTable

> [@Can't form array using splitText method (loadStrings)](https://discourse.processing.org/t/cant-form-array-using-splittext-method-loadstrings/28092):
>
> I’m trying to get text elements from a local text file into an array. pets.txt contains cat dog Hopefully this code explains the problem. Thanks for looking! var pets; var petArray = []; function preload() { . . . pets = loadStrings("pets.txt"); petArray = pets.splitText(','); } function draw() { . . . fill(0); textSize(20); text(pets,60,height-10); //prints… cat,dog text(“X” + petArray[1],160,height-10); //prints… Xundefined }

---

<div class="post-metadata">

**Author:** ![CharrR](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/charrr/32/14589_2.png) [@CharrR](https://discourse.processing.org/u/CharrR)\
**Post date:** [March 17, 2022, 10:41am UTC](https://discourse.processing.org/t/reading-my-excel-data-in-processing/35792/5 "2022-03-17T10:41:55Z")

</div>

Great! thank you, I’ll try that!