Apple's iCal is a calendar application that you can use to plan and display events on a graphical calendar. If you export iCal information to a file then the application saves your calendar information to a delimited text file with the ICS file extension. You can view your ICS in any text editor such as Notepad or Microsoft Word. You can also import ICS files into Microsoft Excel using Excel's Text Import Wizard.
Run the iCal application.
Click the name of the calendar that you wish to export to Excel under the "Calendars" heading.
Click "File" in the menu bar and click "Export." Select a location for the file. iCal exports your calendar information into an ICS delimited text file.
Run the Microsoft Excel application.
Click the "File" tab and then click "Open." Navigate to the folder that contains your ICS file and open the file in Excel. Excel will run the Office Text Import Wizard to convert your ICS data into Excel format.
Check the box next to the ":" colon entry under the "Delimiters" heading.
Click "OK" to save your settings and import your ICS calendar data into Excel.