loading csv into excel spreadsheet -

In the downloaded CSV the timestamp in not provided as a 'julian' date+time

Would be best by far is SwitchBot would provide date/time in Julian or provide this option to enable calculation.