# When Downloading CSV, one variable value's is getting in two different column because of comma **URL:** \ **Category:** Kibana\ **Created:** [February 8, 2023, 8:12am UTC](https://discuss.elastic.co/t/when-downloading-csv-one-variable-values-is-getting-in-two-different-column-because-of-comma/324984 "2023-02-08T08:12:08Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Arshukla](https://avatars.discourse-cdn.com/v4/letter/a/c68b51/32.png) [@Arshukla](https://discuss.elastic.co/u/Arshukla)\ **Post date:** [February 8, 2023, 8:12am UTC](https://discuss.elastic.co/t/when-downloading-csv-one-variable-values-is-getting-in-two-different-column-because-of-comma/324984/1 "2023-02-08T08:12:08Z")
When Downloading CSV from Tabular format, each variable is getting separated with Comma (,). Due to this variable which are numerical values (for e.g., 2,946) are also getting in different columns. As shown in below image, Intra\_Freq value was 4,678. But due to getting separated with comma, the values are getting split as 4 and 678. ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/a/aac15dad61fcda0cd60388d3edeac3cce84a66a5.png) And if go to Advanced setting and format:number:defaultPattern, it will change for all variables. Whereas some of the variables require comma Please suggest the way forward in this case ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [February 8, 2023, 11:23am UTC](https://discuss.elastic.co/t/when-downloading-csv-one-variable-values-is-getting-in-two-different-column-because-of-comma/324984/2 "2023-02-08T11:23:45Z")
Hi @Arshukla can you share some more information here to reproduce the issue? What version of the ELK stack are you using? Is this a CSV coming from a visualization (Lens, Agg-based, etc...) or from a search CSV report (Discover, etc...)? ---
**Author:** ![Arshukla](https://avatars.discourse-cdn.com/v4/letter/a/c68b51/32.png) [@Arshukla](https://discuss.elastic.co/u/Arshukla)\ **Post date:** [February 9, 2023, 6:04am UTC](https://discuss.elastic.co/t/when-downloading-csv-one-variable-values-is-getting-in-two-different-column-because-of-comma/324984/3 "2023-02-09T06:04:38Z")
Hello @Marco_Liberati I am using v8.6.1 for ES, and Kibana. the CSV is getting exported from Lens (tabular format) and when CSV is opened, it applies TEXT TO COLUMN based on Comma (,) as all variables are separated with Comma only. In this process the values which more than hundred, i.e., thousands and have comma in between are getting shifted to next column ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [February 9, 2023, 7:41am UTC](https://discuss.elastic.co/t/when-downloading-csv-one-variable-values-is-getting-in-two-different-column-because-of-comma/324984/4 "2023-02-09T07:41:02Z")
But is the CSV exported with the duplicated column and splitted value? Can you open the CSV with a simple text editor and check? ---
**Author:** ![Arshukla](https://avatars.discourse-cdn.com/v4/letter/a/c68b51/32.png) [@Arshukla](https://discuss.elastic.co/u/Arshukla)\ **Post date:** [February 9, 2023, 8:01am UTC](https://discuss.elastic.co/t/when-downloading-csv-one-variable-values-is-getting-in-two-different-column-because-of-comma/324984/5 "2023-02-09T08:01:39Z")
![image](https://us1.discourse-cdn.com/elastic/original/3X/9/7/97df9011159645b70d71a4c3b88ece3d173b7b2f.png) Please find screenshot of the text editor. All values are separated with comma. Even some values which are in thousands are also having Comma in between. ---
**Author:** ![jughosta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jughosta/32/107160_2.png) [@jughosta](https://discuss.elastic.co/u/jughosta)\ **Post date:** [February 20, 2023, 9:25am UTC](https://discuss.elastic.co/t/when-downloading-csv-one-variable-values-is-getting-in-two-different-column-because-of-comma/324984/6 "2023-02-20T09:25:07Z")
Hi @Arshukla, Could you please check the current state of "csv:quoteValues" toggle on Advanced Settings page? Switching it on could help in your case. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 20, 2023, 9:25am UTC](https://discuss.elastic.co/t/when-downloading-csv-one-variable-values-is-getting-in-two-different-column-because-of-comma/324984/7 "2023-03-20T09:25:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.