NB: This process works for me using Numbers.app, Google Calendar, and iCal. Feel free to reference this post as well, but the new post is much more thorough and has a few new tools that I wrote to facilitate the process of getting spreadsheet events into your calendar app of choice. Update May 07, 2013: This post has been completely rewritten and updated here. Bottom line: You can batch import events from a spreadsheet to iCal or Google Calendar by formatting the headers correctly, exporting / import as.
