# correct csv format

**URL:** <https://forum.ansible.com/t/correct-csv-format/33664>\
**Category:** Ansible Project\
**Tags:** ansible-project\
**Created:** [August 24, 2020, 10:27am UTC](https://forum.ansible.com/t/correct-csv-format/33664 "2020-08-24T10:27:09Z")\
**Posts on this page:** 2\
**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:** [August 24, 2020, 10:27am UTC](https://forum.ansible.com/t/correct-csv-format/33664/1 "2020-08-24T10:27:09Z")

</div>

> server1  
> server2  
> server3  
> PermitEmptyPasswords no  
> PermitEmptyPasswords no  
> PermitEmptyPasswords no  
> Found  
> Not Found  
> Not Found  
> &nbsp;&nbsp;  
> \*But I want output in this format-:\*
> 
> server1, PermitEmptyPasswords no , Found  
> server2, PermitEmptyPasswords no , Not Found  
> server3, PermitEmptyPasswords no , Not Found

Try this

&nbsp;&nbsp;&nbsp;&nbsp;- shell: echo  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"{{ lines|map('extract', output)|list|join(',') }}"  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\>\> file\_output.csv  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;loop: "{{ range(0, len|int)|list }}"  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;vars:  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;step: 3  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;len: "{{ output|length / step }}"  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;lines: "{{ range(item, output|length, step)|list }}"

---

<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:** [August 24, 2020, 11:01am UTC](https://forum.ansible.com/t/correct-csv-format/33664/2 "2020-08-24T11:01:26Z")

</div>

This is probably the right time you post the "output".

You've already said

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- name: list output to CSV  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;shell: echo "{{ item }}" \>\> file\_output.csv  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;delegate\_to: 127.0.0.1  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;with\_items: "{{ output }}"

\*the output of csv file-:\*

server1  
server2  
server3  
PermitEmptyPasswords no  
PermitEmptyPasswords no  
PermitEmptyPasswords no  
Found  
Not Found  
Not Found

I guessed the variable "output" is a list

&nbsp;&nbsp;&nbsp;&nbsp;output:  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- server1  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- server2  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- server3  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- PermitEmptyPasswords no  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- PermitEmptyPasswords no  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- PermitEmptyPasswords no  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- Found  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- Not Found  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- Not Found

Is it?