Date and time in separate columns in CSV export

Feedback & Ideas
1

Date and time in separate columns in CSV export please

Using ‘text to columns’ in excel is a pain

Tanks

5 Likes
2

This has been driving me mad for some time. Please make it a format that Google sheet can understand!

1 Like
3

I sorted this with:

=iferror(datevalue(left(A1,find(" at",A1))),“1967-01-01”)

4

Hi there @mattmoney, @pontus and anyone else stumbling upon this topic,

I found another thread about this problem and thought I would let you know, so that – if you want to – you can add your support/vote to that thread in order to combine our efforts and push for a solution.

Here it is:

Cheers!

5

Google sheets is a pretty poor spreadsheet web app. If you want to manipulate data free, I would advise Open Office or Numbers.

6

Wild guess, I’d say the T was to indicate the start of the time and the Z to indicate that Zulu time was being used. Zulu is a military or navigation name for UTC. R-