dashboard export in xls and xml format

[corrad82-4s]

Is your feature request related to a problem? Please describe.
As Microsoft Excel, and its xls/xlsx file types, is a common standard among business analysis and business intelligence teams, and xml is one of the formats in use for data exchange and interoperability, the possibility of having an export of dashboards in those formats.

Describe the solution you'd like
In addition to already present icons to export in json and csv, two further intuitive icons might be placed, once clicked an export in xml or xls is triggered.

Describe alternatives you've considered
Considered alternatives are related to the possibility of a post-transformation of already available outputs, i.e. from json to xml or from csv to excel, but I think having the possibility directly in superset instead of applying post transformation with other tools might be better.

Additional context
I am aware of issue #11162.
Is anyone already working on this feature and/or can provide any suggestion about how to implement it? And / Or might be interested in a contribution?

[srinify]

Hi @corrad82-4s to clarify this, do you want users to be able to explore datasets in XLS format and charts / dashboards in XML format? Or just datasets in XLS / XML?

[corrad82-4s]

Hi @srinify , thank you for your answer. We want users to be able to export charts content in xls and xml file in addition to already existing possibilities of exporting them in json or csv

[srinify]

Sorry, to be 100% clear ... what do you mean by 'charts content'?

A screenshot / image of the chart? The JS code behind the chart? The underlying data for the chart?

[corrad82-4s]

@srinify sorry to you for not being so clear.
In short, I mean the underlying data, the same data that would be exported in json or csv from dashboard edit page

or from csv export from dashboard's chart menu

[srinify]

Got it, I'm with you now :]

[srinify]

@junlincc I wonder if this could be a good medium-complexity "first issue" for someone 🤔

[exemplary-citizen]

I'd be happy to take this on. We can use the same pattern that is in place for downloading CSVs https://github.com/apache/superset/blob/master/superset/views/base.py#L560 and adapt it to xml and xlsx by adding XmlResponse and XlsxResponse classes. Do you think this should get split up into two seprate PRs? one for each file type?

[arojoal]

+1

https://medium.com/geekculture/apache-superset-export-data-to-excel-38b8170a30ee

A good explanation of why it is necessary for end users to have an option to export to excel...

[a-cid]

+1

As a non-US user, my users have trouble with standard CSVs because our locale uses dots as digit group separators, instead of as decimal separators. Naively loading a CSV that uses dots as decimal separators in Excel results in incorrect parsing of these values (ie: 1.5 becomes 1500).

This feature would be an immense improvement to them.

[LalaGabor]

+1

[Qweyer]

+1 for this feature

[iyakhiev]

I need this feature too.

[romanbody]

+1 for this feature
is there any plan/update regarding this feature?

[h0rn3t]

+1

[amravazzi]

+1

[pdakkata-quot]

+1

[Neel-rishabhsoft]

+1

[timnick-snow]

+1

[timnick-snow]

Hope to have this feature

[mkhayom]

+1

[andrey-mikhailov]

+1

[msaifi255]

+1

[DiegoQ77]

+1

[rpmulya]

+1

[rasharp]

+1

[oyasuyuki]

+1

[jordiisidro]

+1

[caponord]

+1

[distrx01]

+1

[BlessMario]

• 1 (would be very nice)

[scr1ble]

+1

[sunsikai]

+1

[itziarmj]

The excel export is available in the edit chart, but not in the charts in the dashboard.
Could it be possible to add this functionality also to the charts included in a dashboard?
This way, users that do not have edit permission can also access this feature.

[MaheshKungaria]

+1 need Export to Excel option on Superset 2.0.0 reports

[sebastianliebscher]

The excel export is available in the edit chart, but not in the charts in the dashboard. Could it be possible to add this functionality also to the charts included in a dashboard? This way, users that do not have edit permission can also access this feature.

To clarify:

• Excel export in chart builder added in 2.1.0
• Excel export and Excel full export in dashboard added in 3.0.0

What's left is the XML export. There is currently an open PR #14628

[rusackas]

I'm tempted to close this out since it's both a stale/silent thread (it's been silent well over a year), and a feature request rather than a bug. Clearly there's a lot of interest in the feature, however. Is anyone willing to contribute the remaining parts?

[rusackas]

Ok, I'm closing this as stale. If anyone wants to tackle parts of what's left, I'd advise just doing so on a PR, or opening "Ideas" threads on GitHub Discussions for any additional feature requests. Thanks to all those who participated in this thread and all the PRs that have been merged toward the effort thus far.