Discover all of the brand-new features and improvements to existing capabilities in the Dataiku 11.3 updateLET'S GO

Exporting Dates to MS Excel

User Story:

As a Data Analyst, I'd like to be able to export Dataiku Datasets into MS Excel files and have the parsed Date Time come through into MS Excel as MS Excel DataTime Columns not Text strings in the style of an ISO Data Time, this would save time and reduce confusion on the part of date consumers.


  • Problem was discovered in Dataiku DSS V8.0.4

cc: @AshleyW 


This would be great! We're also constantly importing and exporting Excel datasets with datestamps at my company. It would be great if both the Excel import and export capabilities could support Excel's DateTime object (64-bit floating point number of days since 1900-01-01 plus a day for the leap year bug in 1900). My team often uses prepare recipes to convert these, but it would be much better if DSS were to natively support them. Even when using a prepare recipe to transform dates to Excel format before export, since we can't set the format hint from Dataiku to indicate that these floating point timestamps should be treated as such, we currently have to open the exported files in Excel and manually format them as dates.

@natejgardner ,

Agreed.  You understand my pain.

Status changed to: In Backlog


You'll be pleased to hear this idea is in our backlog and we are determining the next steps for development. We can't provide a timeline at this point, but be sure to check back for updates!

For everyone else, kudos the original post to signal that you're interested in Dataiku developing and releasing this! Feel free to leave a comment in the discussion about how this capability would help you or your team.

Take care,


Great News!

I ran into this challenge again.  Currently using V10.0.3

Level 1

This would be very helpful, most of our exported data goes into Power BI which can handle it just fine. It's the more ad-hoc requests for other stakeholders where this can be a tad frustrating.

Importing the data in excel through Power Query works as a quick fix but not ideal.

Status changed to: Planned

Congrats - we're adding this to our roadmap! While timelines are always tricky, we'll let you know how it's progressing as updates are available.

If you've kudoed the post or added some comments about your particular use case, we may reach out to get some feedback.

Take care,


So glad to hear that this is one step closer to reality.

Level 1

Glad there is a plan to get an update in - same as others on the thread, my team often provides excel exports to stakeholders that don't utilize dataiku directly.  In order for dates to be in excel format, we have to go in each time and make the adjustments manually after exporting the excel.

It would be nice if the time zone display came threw in local time zone if I wanted as well.