How to convert the dates to mm/dd/yyyy format in exported excel & csv files in Apache Superset?

[anushatv16]

Hi Team,

I am using Apache Superset to create dashboards and have a table visualization where one of the columns is a date. In the visualization, I was able to format the date as mm/dd/yyyy using Superset's customization options.

However, when exporting this table data to Excel or CSV, the date column defaults to the yyyy-mm-dd format. I need the exported date format to be in mm/dd/yyyy instead.

Please find the attached screenshot for reference.

Before exporting to Excel or CSV (In the Superset Table View):

After exporting to Excel or CSV:

Could you suggest any possible solutions to achieve this?

[dosubot[bot]]

A similar issue was previously reported and resolved. The issue was about exporting charts to Excel with date type columns, where the date formatting was not as expected. This issue was closed by a pull request that fixed the datetime with timezone export ^[1].

To address your specific need to export dates in the mm/dd/yyyy format, you might want to look into the DateWithFormatter class and the TimeFormatter class in the Superset codebase. These classes are responsible for date formatting and allow for custom date format functions ^[2][3].

Additionally, Superset's configuration files define several date formats, including US_DATE, which is %m/%d/%Y. You might need to ensure that this format is applied during the export process ^[4].

If the current implementation does not support this directly, you may need to customize the export functionality to apply the desired date format. This could involve modifying the export logic to use the US_DATE format when exporting to Excel or CSV.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}