Hi when I download my History in csv form is there any way of getting the date & time I watched it to match my time zone? For example on csv a tv show I watched shows up as |2023-05-27T13:44:38Z] but I watched it 2023-05-27 11:44pm. TIA

Thanks so much I will give it a go

Nup had no luck. Made my brain hurt In the end

I’d ask ChatGPT how to format a UTC date to your time zone in excel (or whatever spreadsheet app you’re using). I assume there is some built in function to do so. Behind the scenes, we store all dates in UTC then format them using your browser.

Thanks that gave me the formula now have to wait to get to a PC. The sheets or Excel apps don’t allow you to do something that technical

@r.deniroj For what it’s worth I asked for a download of my Spotify history and used this formula to convert the ISO timestamp to a readable timestamp, in my timezone: =DATEVALUE(MID(A2;1;10)) + SUM(TIMEVALUE(MID(A2;12;8));“1:00:00”) turns 2021-10-02T05:48:44Z into 2-10-2021 6:48:44 the…

Thanks so much for going out of your way to respond Merry Christmas

Download History csv

Discussions TV Shows

r.deniroj (r.deniroj) June 9, 2023, 1:51am 5

Anybody else please?

Topic		Replies	Views
CSV export list date change General	0	120	October 11, 2023
Overwrite watch time when import CSV Questions & Help	1	63	August 14, 2025
Import from TVTime error Questions & Help	2	223	December 26, 2024
CSV export & personal rating Questions & Help website	0	77	June 27, 2025
Only as JSON General	4	259	April 5, 2025

Download History csv

Related topics