# how to seprate key vale from debug output

**URL:** <https://forum.ansible.com/t/how-to-seprate-key-vale-from-debug-output/35685>\
**Category:** Ansible Project\
**Created:** [August 27, 2021, 6:52pm UTC](https://forum.ansible.com/t/how-to-seprate-key-vale-from-debug-output/35685 "2021-08-27T18:52:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gaurav\_Dhyani](https://avatars.discourse-cdn.com/v4/letter/g/ed8c4c/32.png) [@Gaurav\_Dhyani](https://forum.ansible.com/u/Gaurav_Dhyani)\
**Post date:** [August 27, 2021, 6:52pm UTC](https://forum.ansible.com/t/how-to-seprate-key-vale-from-debug-output/35685/1 "2021-08-27T18:52:42Z")

</div>

I have debug info like below, i want this in excel as key in the header and value below that.  
“msg”: {  
“HPE Ethernet 1Gb 4-port 331T Adapter #3”: “20.12.41”,  
“HPE Ethernet 1Gb 4-port 331i Adapter - NIC”: “20.12.41”,  
“HPE Smart Storage Battery 1 Firmware”: “1.1”,  
“Intelligent Platform Abstraction Data”: “27.01”,  
“Intelligent Provisioning”: “2.40.79”,  
“Power Management Controller FW Bootloader”: “1.0”,  
“Power Management Controller Firmware”: “1.0.9”,  
“Redundant System ROM”: “P89 v2.60 (05/21/2018)”,  
“SAS Programmable Logic Device”: “Version 0x03”,  
“Server Platform Services (SPS) Firmware”: “3.1.3.21.0”,  
“Smart Array P440ar Controller”: “7.00”,  
“System Programmable Logic Device”: “Version 0x34”,  
“System ROM”: “P89 v2.74 (07/21/2019)”,  
“iLO”: “2.70 May 07 2019”  
}  
}

---

<div class="post-metadata">

**Author:** ![Dennis\_M](https://avatars.discourse-cdn.com/v4/letter/d/34f0e0/32.png) [@Dennis\_M](https://forum.ansible.com/u/Dennis_M)\
**Post date:** [September 1, 2021, 6:40pm UTC](https://forum.ansible.com/t/how-to-seprate-key-vale-from-debug-output/35685/2 "2021-09-01T18:40:31Z")

</div>

Hi,

Please expose the debug task from YAML.

Regards,

пятница, 27 августа 2021 г. в 21:52:42 UTC+3, [dhyanig...@gmail.com](mailto:dhyanig...@gmail.com):
