Date-Time format that parses in Excel, Chrome, and Firefox

Question

Is there a date-time format for CSV that's recognized by Excel, Chrome, and Firefox (and ideally more broadly) and valid across locales in US and EU?

Excel can read CSV with ISO Dates, but does not recognize the ISO Date Time values in the first column:

Here's an example CSV:

"datetime"            
"1985-07-17T09:12Z"   
"1985-07-17 09:12"    
"1985-07-17"          
"12/10/2010 9:12",
"10-Dec-2010 09:11",
"Dec 10, 2010 09:11"

• "1985-07-17T09:12Z" parses in Chrome and Firefox but not Excel
• "1985-07-17 09:12" parses in Chrome and Excel but not Firefox
• "1985-07-17" parses in Chrome, Excel and Firefox but loses the time
• "12/10/2010 09:12" parses in Chrome, Excel and Firefox but assumes US Locale
• "10-Dec-2010 09:11" does not parse in Firefox
• "Dec 10, 2010 09:11" parses in Excel, Chrome and Firefox ... but US only??

Chrome can read lots of locale-specific date time formats, but Firefox is pickier.

Update: Added a more complete example

Question: Does "Dec 10, 2010 09:11" parse for me in all three only because I'm in the US, or would this work more generally?

• Date format that is guaranteed to be recognized by Excel

• Parsing an ISO8601 date/time (including TimeZone) in Excel

Answer 1

The following format works in Chrome, Firefox, IE, Safari, Edge (parsed with javascript new Date()). Excel also parses this format (at least in my locale with default YYYY-MM-DD date format):

YYYY/MM/DD HH:mm

An example of a timestamp in this format is:

1985/07/17 09:12