# Ansible read excel sheet to build inventory

**URL:** <https://forum.ansible.com/t/ansible-read-excel-sheet-to-build-inventory/35152>\
**Category:** Ansible Project\
**Created:** [May 11, 2021, 7:15pm UTC](https://forum.ansible.com/t/ansible-read-excel-sheet-to-build-inventory/35152 "2021-05-11T19:15:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abhishek\_Agawane](https://avatars.discourse-cdn.com/v4/letter/a/90ced4/32.png) [@Abhishek\_Agawane](https://forum.ansible.com/u/Abhishek_Agawane)\
**Post date:** [May 11, 2021, 7:15pm UTC](https://forum.ansible.com/t/ansible-read-excel-sheet-to-build-inventory/35152/1 "2021-05-11T19:15:55Z")

</div>

Hi All,

Is there any way that i can import a list of hosts from an excel spreadsheet into ansible inventory so i can connect to each host via ansible and perform operations?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/ansible/original/1X/1882d9a01da5d8996a862359b0913cc568a39b84.svg) [@system](https://forum.ansible.com/u/system)\
**Post date:** [May 12, 2021, 3:48pm UTC](https://forum.ansible.com/t/ansible-read-excel-sheet-to-build-inventory/35152/2 "2021-05-12T15:48:10Z")

</div>

yes, an inventory plugin or inventory script can do this, there are  
several examples of this in 'the wild', but none are shipped as part  
of Ansible.

---

<div class="post-metadata">

**Author:** ![The\_Vandyy\_Vines](https://avatars.discourse-cdn.com/v4/letter/t/7993a0/32.png) [@The\_Vandyy\_Vines](https://forum.ansible.com/u/The_Vandyy_Vines)\
**Post date:** [May 12, 2021, 5:41pm UTC](https://forum.ansible.com/t/ansible-read-excel-sheet-to-build-inventory/35152/3 "2021-05-12T17:41:09Z")

</div>

Read\_csv is a module to read the csv