2013 Schedule in spreadsheet form?

Hey Ballpark Chasers:

Time to start scheming about next year's trip(s). Has anyone come across a site that has the entire MLB schedule in a downloadable .csv or .xls format?

Happy chasing!

Thanks,
Randall Moore

0 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Andrew Pautz on November 27, 2012 at 1:21pm

I was searching for the same thing. I couldn't find one anywhere, so I made one myself.

https://docs.google.com/spreadsheet/ccc?key=0AgVWW57QQa1PdEp4TmhBQ2...

There are still a lot of TBDs. I'm not responsible for any incorrect or changing information. There's one extra game on the spreadsheet- the 3/31 season opener. Since it's completely TBD, I simply added it to the schedule.

If anyone is looking to do this in the future, you can find individual home schedules from the teams' schedule pages. Unfortunately, they only offer iCal format. In the past they offered CSVs (they may or may not still be available in CSV format if you can figure out the appropriate URL). I used this web tool I found to convert from iCal to CSV:

http://csv2sql.evandavey.com/ical2csv/

Unfortunately, I'm not familiar with anything that'll allow you to batch convert.

I then used the command line to consolidate all the individual CSVs (can Google this as well- it's very easy if you've used the command line before).

If you're code-savvy, you could probably do this a little more efficiently.