Request: Add "Download to Excel" option in SQL Editor to handle malformed JSON data

[zahragh996]

Description

Currently, the SQL Editor in Apache Superset allows downloading results only in CSV format. However, when working with datasets where some columns contain JSON data, malformed JSON entries cause the data to spill over into adjacent columns when exported to CSV. This issue leads to incorrect formatting and unusable output.

Problem Details

• Impact: Users dealing with datasets containing JSON-like structures (e.g., nested data) encounter column misalignment due to malformed JSON values.
• CSV Limitation: CSV format does not inherently handle complex or malformed JSON data, and this often results in improper row and column parsing.

Proposed Feature

Please add a "Download to Excel" option alongside the current "Download to CSV" functionality in the SQL Editor. Excel (.xlsx) format:

1. Provides a more structured data export format.
2. Mitigates issues caused by malformed JSON as Excel cells can handle multi-line and complex data more gracefully.
3. Would serve as an alternative to CSV for datasets containing mixed or nested data.

Question

• In the meantime, is there an existing workaround or setting in Superset to prevent JSON data from spilling into adjacent columns when downloading as CSV?