# Kibana data table to CSV (Duplicate Columns)

**URL:** <https://discuss.elastic.co/t/kibana-data-table-to-csv-duplicate-columns/372970>\
**Category:** Kibana\
**Created:** [January 9, 2025, 6:00am UTC](https://discuss.elastic.co/t/kibana-data-table-to-csv-duplicate-columns/372970 "2025-01-09T06:00:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yokesh\_GK](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yokesh_gk/32/140554_2.png) [@Yokesh\_GK](https://discuss.elastic.co/u/Yokesh_GK)\
**Post date:** [January 9, 2025, 6:00am UTC](https://discuss.elastic.co/t/kibana-data-table-to-csv-duplicate-columns/372970/1 "2025-01-09T06:00:41Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/2/1/2192ed9d733e6e1493196ab30fc77b11dacb6a2b.png)

The first image shows the data table I designed in Kibana, while the second image is the CSV file downloaded from that table.

You can see that the columns are duplicated from "Initiated" to "Errored." However, there are no actual columns in my data table; I’ve only used rows and metrics. Interestingly, if the events are created using columns, the exported CSV doesn’t have duplicates. Unfortunately, I can’t use columns because I need to display MRR data, which isn’t possible with columns, so I rely solely on metrics.

I was able to achieve the desired visualization, but the exported CSV still has duplicated columns. Notably, the MRR data isn’t duplicated, even though it’s in the metrics. For the rest of the fields in the metrics, I used formulas, as shown in the image. Could this be the reason why duplicates appear in the exported CSV?

All the metrics have been given unique display names, yet the duplication persists. Each formula calculates the count of `event.keyword` for different events (e.g., "Initiated," "Dialing," ..., "Errored").

---

<div class="post-metadata">

**Author:** ![Yokesh\_GK](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yokesh_gk/32/140554_2.png) [@Yokesh\_GK](https://discuss.elastic.co/u/Yokesh_GK)\
**Post date:** [January 9, 2025, 6:01am UTC](https://discuss.elastic.co/t/kibana-data-table-to-csv-duplicate-columns/372970/2 "2025-01-09T06:01:16Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/0/b/0bb1c055b298e2ac4a282fce2ca0093e23cc38f1.png)

This is the first image

---

<div class="post-metadata">

**Author:** ![Yokesh\_GK](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yokesh_gk/32/140554_2.png) [@Yokesh\_GK](https://discuss.elastic.co/u/Yokesh_GK)\
**Post date:** [January 9, 2025, 6:02am UTC](https://discuss.elastic.co/t/kibana-data-table-to-csv-duplicate-columns/372970/3 "2025-01-09T06:02:01Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/4/d/4d168faa2a98445f918fd996f1546d9c727099e6.png)

This is the metric image

---

<div class="post-metadata">

**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:** [January 9, 2025, 11:18am UTC](https://discuss.elastic.co/t/kibana-data-table-to-csv-duplicate-columns/372970/4 "2025-01-09T11:18:53Z")

</div>

What version of the stack are you using?

That issue has been resolved since version 8.2.0 .

---

<div class="post-metadata">

**Author:** ![Yokesh\_GK](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yokesh_gk/32/140554_2.png) [@Yokesh\_GK](https://discuss.elastic.co/u/Yokesh_GK)\
**Post date:** [January 10, 2025, 5:06am UTC](https://discuss.elastic.co/t/kibana-data-table-to-csv-duplicate-columns/372970/5 "2025-01-10T05:06:29Z")

</div>

The stack management version I am using is 7.17.10. Are there any workarounds to fix the issue in my current version?

---

<div class="post-metadata">

**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:** [January 10, 2025, 1:17pm UTC](https://discuss.elastic.co/t/kibana-data-table-to-csv-duplicate-columns/372970/6 "2025-01-10T13:17:39Z")

</div>

Unfortunately not other than upgrade to a more recent version.

---

<div class="post-metadata">

**Author:** ![Yokesh\_GK](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yokesh_gk/32/140554_2.png) [@Yokesh\_GK](https://discuss.elastic.co/u/Yokesh_GK)\
**Post date:** [January 15, 2025, 2:01pm UTC](https://discuss.elastic.co/t/kibana-data-table-to-csv-duplicate-columns/372970/7 "2025-01-15T14:01:14Z")

</div>

Thanks for your assist
