You export data from Insights to CSV but the times are wrong:
Data is exported as RAW data to CSV files and excel displays it as RAW.
Set the dates in your CSV file by right clicking the column and choosing Format Cells... and then using the Custom or Date category.
Note: the times/dates are UTC, so make sure to change and add or subtract the hours according to your location.
Format Cells -
The result -