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.