# Ansible dict date to csv file

**URL:** <https://forum.ansible.com/t/ansible-dict-date-to-csv-file/37083>\
**Category:** Ansible Project\
**Tags:** ansible-project\
**Created:** [September 10, 2022, 6:04pm UTC](https://forum.ansible.com/t/ansible-dict-date-to-csv-file/37083 "2022-09-10T18:04:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vbotka](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/vbotka/32/359_2.png) [@vbotka](https://forum.ansible.com/u/vbotka)\
**Post date:** [September 10, 2022, 6:04pm UTC](https://forum.ansible.com/t/ansible-dict-date-to-csv-file/37083/1 "2022-09-10T18:04:20Z")

</div>

Create the list. Put the below declarations into \*vars\*

&nbsp;&nbsp;csv\_query: '.[`Clusters`, key, value.node, value.state]'  
&nbsp;&nbsp;csv: "{{ Clusters|dict2items|json\_query(csv\_query)|  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;map('flatten')|map('join', ',')|list }}"

gives

&nbsp;&nbsp;csv:  
&nbsp;&nbsp;- Clusters,192.168.1.1,node1,up  
&nbsp;&nbsp;- Clusters,192.168.1.2,node2,down  
&nbsp;&nbsp;- Clusters,192.168.1.3,node3,up

Write the file

&nbsp;&nbsp;- copy:  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dest: /tmp/Clusters.csv  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;content: "{{ csv|join('\n') }}"

gives

> cat /tmp/Clusters.csv

Clusters,192.168.1.1,node1,up  
Clusters,192.168.1.2,node2,down  
Clusters,192.168.1.3,node3,up