Lazy Calendar Copying

December 15, 2008 8:58 AM

How can I take a sports schedule in a table format and easily make an iCal calendar?

I'm looking to take sports schedule that is only available in a table (columns for date, opponent, place, time, and result) and easily make an iCal (or csv that can be imported to Google Calendar or Sunbird) out of it.

posted by theichibun to computers & internet (3 comments total)

Oh, something I forgot. A service like I Want Sandy where I could email a list of things to remember and then be able to export those events as an iCal would work too. Sadly I canceled my Sandy account and they won't let people sign up anymore.
posted by theichibun at 9:02 AM on December 15, 2008

Is it a HTML table or a table in a Word document? You should be able to select that and paste into a spreadsheet application. From there you can export CSV.
posted by davidnorth at 1:27 PM on December 19, 2008

If you use Firefox, there's a nice extension called TableTools. It gives you a lot of control in how you copy html table content. Paste the content in tab delimited format into Notepad, save the file with a .csv extension, and import into iCal.
posted by ckohrman at 5:48 AM on January 31