Import Excel Schedules to iCal
Hope this is something simple.
Mac Book Pro, Mac OS X (10.6.1)
Mac Book Pro, Mac OS X (10.6.1)
set AppleScript's text item delimiters to {","}
set AppleScript's text item delimiters to {tab}
Have also thought scripts are band-aids for bad software
If you dont want to bother with the scripting -- you can just import the CSV into a google calendar and then export it back out as an ics, then you import that ics file into ical.
Took me all of 5 minutes to do it.
Here is how to import csv into google calendar:
http://www.google.com/support/calendar/bin/answer.py?hl=en&answer=37118&topic=16 72003
This is the google help file on getting your CSV formatted properly in case there is a problem:
http://www.google.com/support/calendar/bin/answer.py?answer=45656
Here is how to export out of google calendar:
http://www.google.com/support/calendar/bin/answer.py?answer=37111
Hi there everyone,
I was wondering if this is now possible, since it has been a couple of years now?
I work on a mac with a timeline of jobs in an excel sheet, however, I would love to be able to have the file sync automatically and update with my excel sheet as I add new jobs to the list...
Is this a far fetched ambition?
Hi,
My Wife is training for the NY Marathon.
I listed the training plan in excel, saved the data with appropriate headings and converted it to ical for import.
Apart from missing some headings that resulted in an initial failure, it worked like a charm (Location, Private)
Everything you need to know is here ..
Import Excel Schedules to iCal