# Loading of all sheets from .xlsx

**URL:** <https://community.easymorph.com/t/loading-of-all-sheets-from-xlsx/4320>\
**Category:** General Q&A\
**Created:** [February 27, 2023, 11:32am UTC](https://community.easymorph.com/t/loading-of-all-sheets-from-xlsx/4320 "2023-02-27T11:32:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![zsofi](https://community.easymorph.com/letter_avatar_proxy/v4/letter/z/ea666f/32.png) [@zsofi](https://community.easymorph.com/u/zsofi)\
**Post date:** [February 27, 2023, 11:32am UTC](https://community.easymorph.com/t/loading-of-all-sheets-from-xlsx/4320/1 "2023-02-27T11:32:17Z")

</div>

Hi dears,

I am looking for an option to load each sheet from an excel, no matter of naming or number.  
Each month I am loading excel workbooks, with several sheets. Some month the excel consists 13, other month 15 sheets and some sheets may be missing one month and appearing the next month. The naming of columns is identical in each sheet. Nowadays I am checking manually, if each sheet has been loaded, but I would like to automate it. What is the workaround? I was trying through iteration, but didn't work well. Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Jochen\_Marquardt](https://community.easymorph.com/user_avatar/community.easymorph.com/jochen_marquardt/32/5256_2.png) [@Jochen\_Marquardt](https://community.easymorph.com/u/Jochen_Marquardt)\
**Post date:** [February 27, 2023, 1:03pm UTC](https://community.easymorph.com/t/loading-of-all-sheets-from-xlsx/4320/2 "2023-02-27T13:03:30Z")

</div>

Hi,

you can first list all sheets of the file and iterate over the sheet names. The "Excel command" action could help.

 ![image](https://community.easymorph.com/uploads/default/original/2X/d/d8b292ba9177dc79ed2a468494150210806ad3fb.png)

Kind regards,

Jochen

---

<div class="post-metadata">

**Author:** ![bolud](https://community.easymorph.com/letter_avatar_proxy/v4/letter/b/82dd89/32.png) [@bolud](https://community.easymorph.com/u/bolud)\
**Post date:** [February 28, 2023, 7:36am UTC](https://community.easymorph.com/t/loading-of-all-sheets-from-xlsx/4320/3 "2023-02-28T07:36:22Z")

</div>

[worksheets.xlsx](https://community.easymorph.com/uploads/short-url/waq0rbNDZxINL0MQ55yj63LVY4s.xlsx) (12.1 KB)  
[worksheets.morph](https://community.easymorph.com/uploads/short-url/v7teZ1QweaK6fkL9gLRRNM36gmx.morph) (4.4 KB)  
Here it is. I hope it is what you are looking for.

---

<div class="post-metadata">

**Author:** ![zsofi](https://community.easymorph.com/letter_avatar_proxy/v4/letter/z/ea666f/32.png) [@zsofi](https://community.easymorph.com/u/zsofi)\
**Post date:** [March 16, 2023, 3:37pm UTC](https://community.easymorph.com/t/loading-of-all-sheets-from-xlsx/4320/4 "2023-03-16T15:37:47Z")

</div>

Hi both,  
thanks a lot for your assistance, I think I have to figure out more deep, how this iteration works, but your advise helped out a lot! 🙂
