Export date as readable by Excel

  • 14 May 2020

When I export data from Mixpanel as a CSV file, the date format is Jul 25 ‘19 which is completely unintelligble by Excel. I have to manually manipulate the data using “Search and Replace” to get it into a format which Excel will recognize as a date. Please consider exporting the date data as a standard date format rather than a custom date format.

Be the first to reply!