# CSV Output, How to download csv file? Comma issues

**URL:** <https://forum.opensearch.org/t/csv-output-how-to-download-csv-file-comma-issues/1509>\
**Category:** SQL\
**Created:** [September 12, 2019, 3:28pm UTC](https://forum.opensearch.org/t/csv-output-how-to-download-csv-file-comma-issues/1509 "2019-09-12T15:28:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nico007](https://avatars.discourse-cdn.com/v4/letter/n/9de0a6/32.png) [@nico007](https://forum.opensearch.org/u/nico007)\
**Post date:** [September 12, 2019, 3:28pm UTC](https://forum.opensearch.org/t/csv-output-how-to-download-csv-file-comma-issues/1509/1 "2019-09-12T15:28:58Z")

</div>

Hi all,  
We are attempting to download CSV copy of some logs, however we have the issue where the output is on the screen and also when we do copy in plain text to text editor and save it as csv, commas inside the message break the csv file.

is there a solution to this?

Query:  
POST \_opendistro/\_sql?format=csv  
{  
“query”: “SELECT @timestamp,message FROM elasticsearch\_cluster-2019.35 LIMIT 50”  
}

 ![image](https://us1.discourse-cdn.com/flex019/uploads/mauve_hedgehog/original/1X/86b01a364fbd6ab85403d9469ed29cd17a58afbd.png)

---

<div class="post-metadata">

**Author:** ![anirudha](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/anirudha/32/5647_2.png) [@anirudha](https://forum.opensearch.org/u/anirudha)\
**Post date:** [February 25, 2020, 3:05am UTC](https://forum.opensearch.org/t/csv-output-how-to-download-csv-file-comma-issues/1509/2 "2020-02-25T03:05:46Z")

</div>

this is only a testing UI in the dev tools sections. We will release a new SQL workbench next release with a pretty UI and ability to download and debug sql queries
