Converting ICS files to Google Sheets

It’s that time of year for NBA season ticket holders.

Preseason is upon us and the regular season is around the corner.

For me, that means splitting up our games between our various family members.

The way we do this requires a bit of a hack that I thought I would post about this morning in hopes that any of you out there know a better way.

Step 1 – Go to your team’s website, find the schedule, and select “add to calendar” or something like that. This is the page on the Knicks website.

Step 2 – Choose “other” or “download” to get an .ics file downloaded to your computer.

Step 3 – Use this free web app to convert the .ics file you downloaded to a .csv file.

Step 4 – Import that .csv file into Excel or Google Sheets.

The thing I always get stuck on is the Knicks schedule is published in GMT time and so the dates and times for the games always come in incorrectly. Which requires me to either write a script to convert them or just fix them manually. I have not found a way to download the .ics file in EST, which would be a huge benefit.

In any case, I am excited for the NBA season to begin. I am not expecting much from the Knicks this year as they are in full rebuild mode (including the knee of our franchise player).

But there is nothing like a close game in the fourth quarter at MSG and I’m hoping we get some of those this year.

8 Views
 0
 0