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.

@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 10, 2023, 10:29am 8

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

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	222	December 26, 2024
CSV export & personal rating Questions & Help website	0	77	June 27, 2025
Only as JSON General	4	258	April 5, 2025

Download History csv

Related topics