# Ansible import excel format price list from supplier and export to remote inventory unit how to

**URL:** <https://forum.ansible.com/t/ansible-import-excel-format-price-list-from-supplier-and-export-to-remote-inventory-unit-how-to/32929>\
**Category:** Ansible Project\
**Created:** [May 14, 2020, 6:28am UTC](https://forum.ansible.com/t/ansible-import-excel-format-price-list-from-supplier-and-export-to-remote-inventory-unit-how-to/32929 "2020-05-14T06:28:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Chan](https://avatars.discourse-cdn.com/v4/letter/m/b487fb/32.png) [@Michael\_Chan](https://forum.ansible.com/u/Michael_Chan)\
**Post date:** [May 14, 2020, 6:28am UTC](https://forum.ansible.com/t/ansible-import-excel-format-price-list-from-supplier-and-export-to-remote-inventory-unit-how-to/32929/1 "2020-05-14T06:28:33Z")

</div>

Hi I am not sure if this idea even possible, I want to use Ansible to pull price list from suppliers and remotely send and (copy) into designated inventory (remote servers) these update price lists are in excel and once the price list are updated, the cost and budget are also updated based on the latest changes, can someone please help me if there is a module can do such task.

---

<div class="post-metadata">

**Author:** ![racke](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/racke/32/4767_2.png) [@racke](https://forum.ansible.com/u/racke)\
**Post date:** [May 14, 2020, 8:31am UTC](https://forum.ansible.com/t/ansible-import-excel-format-price-list-from-supplier-and-export-to-remote-inventory-unit-how-to/32929/2 "2020-05-14T08:31:53Z")

</div>

> Hi I am not sure if this idea even possible, I want to use Ansible to pull price list from suppliers and remotely send  
> and (copy) into designated inventory (remote servers) these update price lists are in excel and once the price list are  
> updated, the cost and budget are also updated based on the latest changes, can someone please help me if there is a  
> module can do such task.

It is likely that this is possible, you probably can utilize standard Ansible modules for your project.

"uri" for pulling price lists  
"copy" for sending the price lists to the remote servers  
"command" to run the updates

Regards  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Racke

---

<div class="post-metadata">

**Author:** ![Michael\_Chan](https://avatars.discourse-cdn.com/v4/letter/m/b487fb/32.png) [@Michael\_Chan](https://forum.ansible.com/u/Michael_Chan)\
**Post date:** [May 17, 2020, 12:08pm UTC](https://forum.ansible.com/t/ansible-import-excel-format-price-list-from-supplier-and-export-to-remote-inventory-unit-how-to/32929/3 "2020-05-17T12:08:59Z")

</div>

Hi racke  
If the web site requires login user/pw for access right, what module I should use?  
Thanks  
MC

---

<div class="post-metadata">

**Author:** ![racke](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/racke/32/4767_2.png) [@racke](https://forum.ansible.com/u/racke)\
**Post date:** [May 17, 2020, 12:29pm UTC](https://forum.ansible.com/t/ansible-import-excel-format-price-list-from-supplier-and-export-to-remote-inventory-unit-how-to/32929/4 "2020-05-17T12:29:51Z")

</div>

> Hi racke  
> If the web site requires login user/pw for access right, what module I should use?  
> Thanks  
> MC

Hello Michael,

please checkout the examples in the documentation of the URL module:  
[https://docs.ansible.com/ansible/latest/modules/uri\_module.html](https://docs.ansible.com/ansible/latest/modules/uri_module.html).

They show how to login and keep the cookie for for subsequent requests.

Regards  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Racke