How date formatting works in dashboard exports

Last updated: February 27, 2025

When exporting data from dashboards, date formatting behavior differs between export formats to support different use cases:

CSV Exports

CSV exports intentionally use standardized date formats (YYYY-MM-DD or full timestamps) rather than display formatting. This ensures compatibility when importing the data into other systems.

Excel (XLSX) Exports

Excel exports maintain two aspects of date fields:

  • The visual formatting matches what you see in the dashboard (e.g., MM/DD/YYYY)

  • The underlying data preserves the full timestamp to maintain data precision

When users click into a cell in Excel, they may see the full timestamp rather than the formatted date. This is expected behavior and allows for maximum flexibility while preserving the visual formatting for general viewing.