# ansible playbook - define data in excel sheets

**URL:** <https://forum.ansible.com/t/ansible-playbook-define-data-in-excel-sheets/33376>\
**Category:** Ansible Project\
**Created:** [July 12, 2020, 2:43am UTC](https://forum.ansible.com/t/ansible-playbook-define-data-in-excel-sheets/33376 "2020-07-12T02:43:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![stack\_flow](https://avatars.discourse-cdn.com/v4/letter/s/97f17d/32.png) [@stack\_flow](https://forum.ansible.com/u/stack_flow)\
**Post date:** [July 12, 2020, 2:43am UTC](https://forum.ansible.com/t/ansible-playbook-define-data-in-excel-sheets/33376/1 "2020-07-12T02:43:19Z")

</div>

I have excel file data.xslx and it has two sheets:

sheet1:

> Hostname | Mgmt\_ip |
> 
> - | - |  
> Switch-1 | 10.0.0.1 |  
> Switch-2 | 10.0.0.2 |  
> Switch-3 | 10.0.0.3 |

sheet2:

> Interface | Interface\_IP | Description |
> 
> - | - | - |  
> Ethernet1/1 | 192.168.100.1/30 | To Spine-1 |  
> Ethernet1/2 | 192.168.100.5/30 | To Spine-2  
> |

how to write yml to read data from each of the sheet of xlsx. I am unable to find ansible module for this.

---

<div class="post-metadata">

**Author:** ![stack\_flow](https://avatars.discourse-cdn.com/v4/letter/s/97f17d/32.png) [@stack\_flow](https://forum.ansible.com/u/stack_flow)\
**Post date:** [July 12, 2020, 3:00pm UTC](https://forum.ansible.com/t/ansible-playbook-define-data-in-excel-sheets/33376/2 "2020-07-12T15:00:27Z")

</div>

some help please.

---

<div class="post-metadata">

**Author:** ![Antony\_Stone](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@Antony\_Stone](https://forum.ansible.com/u/Antony_Stone)\
**Post date:** [July 12, 2020, 6:36pm UTC](https://forum.ansible.com/t/ansible-playbook-define-data-in-excel-sheets/33376/3 "2020-07-12T18:36:47Z")

</div>

I suggest you investigate [https://linux.die.net/man/1/ssconvert](https://linux.die.net/man/1/ssconvert).

Antony,