Cannt read dates from customer list .CSV export

I am unable to view dates when exporting the .CSV from customer lists. 

1) .gz is a silly file type to use for compression 

2)I have followed the directions in this for PC. 
 

• Viewing Customer Lists Exports

I have tried the Excel import wizard. It works but dates are illegible. 

I have tried pasting from a text editor into both GooglSheets and Excel with the same issue. 

I am not an Excel nor Google sheets rookie by any means but this issue has stumped me. 

Extremely frustrated. 

.csv is an extremely simple format to use and export.