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.
Any one from you people can guide me on this then it will be much appreciated.
Hi @mattabrams , (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.
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.
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:
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 brought the feature back.
