# How to enable the Export CSV Dialect in Grafana 7.0

**URL:** <https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663>\
**Category:** Grafana\
**Tags:** templating\
**Created:** [April 27, 2021, 7:26am UTC](https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663 "2021-04-27T07:26:41Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![mohammadawaisjavaid](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/mohammadawaisjavaid/32/14623_2.png) [@mohammadawaisjavaid](https://community.grafana.com/u/mohammadawaisjavaid)\
**Post date:** [April 27, 2021, 7:26am UTC](https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663/1 "2021-04-27T07:26:41Z")

</div>

I have installed Grafana 7.0 and have populated some data in the data table panel but when I am trying to export the CSV using more options then how can I add the Export CSV dialect option in the export button click. ![11](https://us1.discourse-cdn.com/grafana/original/3X/9/7/9729788b431d09c5c43068a3fddd3dfe8c592009.png)

Any one from you people can guide me on this then it will be much appreciated.

---

<div class="post-metadata">

**Author:** ![anon70503803](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@anon70503803](https://community.grafana.com/u/anon70503803)\
**Post date:** [May 6, 2021, 10:47pm UTC](https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663/2 "2021-05-06T22:47:34Z")

</div>

Hi @mohammadawaisjavaid,

Apologies. Can you help me understand: what is not working for you? Are you saying that on v7.0 you do not see the `Excel CSV Dialect` box?

---

<div class="post-metadata">

**Author:** ![mahamjamilkhan](https://avatars.discourse-cdn.com/v4/letter/m/f475e1/32.png) [@mahamjamilkhan](https://community.grafana.com/u/mahamjamilkhan)\
**Post date:** [May 18, 2021, 6:33am UTC](https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663/3 "2021-05-18T06:33:06Z")

</div>

Hi @anon70503803 , (replying on behalf of @mohammadawaisjavaid) we are using **Datatable panel** for displaying data because of its search feature. But when we try to export csv it does not give us option to check or uncheck **Export CSV dialect** option, resulting in comma separated sheet instead of a presentable format sheet.

---

<div class="post-metadata">

**Author:** ![anon70503803](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@anon70503803](https://community.grafana.com/u/anon70503803)\
**Post date:** [May 25, 2021, 7:10pm UTC](https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663/4 "2021-05-25T19:10:00Z")

</div>

Hi @mahamjamilkhan,

What exact version of Grafana are you running? In the changelog, it appears that this feature was added in Grafana 7.3.0. I tested in this on 7.4.5 and 7.5.1-7, and 8 beta. The button worked on all, but not on 8.0.0-beta1 or beta2.

---

<div class="post-metadata">

**Author:** ![anon70503803](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@anon70503803](https://community.grafana.com/u/anon70503803)\
**Post date:** [May 26, 2021, 3:31pm UTC](https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663/5 "2021-05-26T15:31:59Z")

</div>

FYI I’ve made an issue and a draft PR for a fix to this issue in v8:

> <https://github.com/grafana/grafana/issues/34686>
>
> \<!--
> Please use this template to create your bug report. By providing as much i…nfo as possible you help us understand the issue, reproduce it and resolve it for you quicker. Therefor take a couple of extra minutes to make sure you have provided all info needed.
> 
> PROTIP: record your screen and attach it as a gif to showcase the issue.
> 
> \- Questions should be posted to: https://community.grafana.com
> \- Use query inspector to troubleshoot issues: https://bit.ly/2XNF6YS
> \- How to record and attach gif: https://bit.ly/2Mi8T6K
> \--\>
> 
> \*\*What happened\*\*:
> 
> it seems that the Download for Excel toggle option inside Inspect --\> Data has a bug in v8. Clicking the toggle fails with the following error (reproduced on play.grafana):
> 
> !\[image\](https://user-images.githubusercontent.com/37156449/119568556-430b2c00-bd49-11eb-935c-e72f1af311f0.png)
> 
> \*\*What you expected to happen\*\*:
> 
> For the toggle to "switch" when clicked. Successfully test this functionality on 7.3.0, 7.4, and all minor versions of 7.5
> 
> \*\*How to reproduce it (as minimally and precisely as possible)\*\*:
> 
> Try to click the \`Download for Excel\` toggle on play.grafana.com for any \`Inspect\` tab. 
> 
> \*\*Anything else we need to know?\*\*:
> 
> I was able to fix this in my developer environment. A small refactoring of the \`toggleDownloadForExcel\` function seemed to resolve the error.
> 
> \[See my draft PR here for the idea\](https://github.com/grafana/grafana/pull/34685).
> 
> \*\*Environment\*\*:
> \- Grafana version:
> \- Data source type & version:
> \- OS Grafana is installed on:
> \- User OS & Browser:
> \- Grafana plugins:
> \- Others:

but I’d still like to know what exact version you are running…

---

<div class="post-metadata">

**Author:** ![mohammadawaisjavaid](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/mohammadawaisjavaid/32/14623_2.png) [@mohammadawaisjavaid](https://community.grafana.com/u/mohammadawaisjavaid)\
**Post date:** [May 26, 2021, 4:30pm UTC](https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663/6 "2021-05-26T16:30:41Z")

</div>

Thankyou for opening up a issue. Please read the subject. We hve mentioned that we are using grafana 7.0 version.

---

<div class="post-metadata">

**Author:** ![anon70503803](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@anon70503803](https://community.grafana.com/u/anon70503803)\
**Post date:** [May 26, 2021, 4:38pm UTC](https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663/7 "2021-05-26T16:38:07Z")

</div>

I would strongly recommend upgrading to a newer version. I just spun up a Grafana 7.0.0 instance on docker and the Excel toggle does not appear:

Checking the changelog, it looks like this feature was added, removed, and then re-added with fixes in Grafana 7.3:

> **[CSV exports for Excel - What's new in Grafana v7.3 | Grafana documentation](https://grafana.com/docs/grafana/latest/whatsnew/whats-new-in-v7-3/#csv-exports-for-excel)**
>
> Learn about new and updated features in Grafana v7.3

quote:

## CSV exports for Excel

### In v7.0, we introduced a new table panel and inspect mode with Download CSV enabled. However, CSV export to Excel was removed. Due to a large number of inquiries and requests, this [community contribution from tomdaly](https://github.com/grafana/grafana/pull/27284) brought the feature back.

### For more information, refer to [Download raw query results as CSV](https://grafana.com/docs/grafana/latest/panels/inspect-panel/#download-raw-query-results-as-csv) in the Grafana documentation.

---

<div class="post-metadata">

**Author:** ![anon70503803](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@anon70503803](https://community.grafana.com/u/anon70503803)\
**Post date:** [May 26, 2021, 4:40pm UTC](https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663/8 "2021-05-26T16:40:12Z")

</div>

When I run `docker run -d -p 3000:3000 grafana/grafana:7.0.0` the inspect panel looks like this:

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/e/5/e5c8541356eced76d39bb0288b9b2911558b0be7.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/grafana/original/2X/e/ef5308cc58c9e5a13187b5012eb99f406928462f.png) [@system](https://community.grafana.com/u/system)\
**Post date:** [April 27, 2022, 7:26am UTC](https://community.grafana.com/t/how-to-enable-the-export-csv-dialect-in-grafana-7-0/46663/9 "2022-04-27T07:26:55Z")

</div>

This topic was automatically closed after 365 days. New replies are no longer allowed.