Results 1 to 3 of 3
  1. #1

    Member Since
    Aug 05, 2007
    Sync ical with excel
    Is there a software program available where i can sync ical with microsoft excel. i downloaded a schedule in microsoft excel format and would like to export it to ical, any suggestions?
    thank you

  2. #2

    Member Since
    Aug 05, 2007
    Thanks to a hint I found elsewhere, I managed to do what you want by creating a Word mail merge list from my Excel file event entries in iCal format. Here are the basic steps:

    1. Drag any iCal event from your calendar onto your desktop and open it in Word. This file shows you the iCal standard lines required to describe an event.
    2. Copy the lines between the BEGIN:VTIMEZONE line and the next to last line END:VEVENT into a new document. Use Tools|Data Merge Manager to Create a Form Letter from this new document.
    3. In your Excel worksheet of events, create columns for start dates in yyyymmdd format, start times in hhmmss format (24-hour clock) and similarly for end dates and end times. Use appropriate unique column header names.
    4. Copy your Excel worksheet data into a new Word document which will be your Data Source for your mail merge.
    4. In the Word Form Letter document, look for the DTSTART line and replace the date (before the "T" character) with the Word mergefield name you've used for the start yyyymmdd. Replace the time (after the "T" character) with your mergefield name for the start hhmmss. Do the same for the DTEND line for end date and time.
    5. Replace the event description in the SUMMARY: line with your mergefield for event description.
    6. If you use calendar notes for the events, replace the text in the DESCRIPTION: line with your mergefield column names for note lines(multiple lines are separated by "\n").
    7. Do a Merge to New Document (test this with just a few merge records first at this point). Globally replace the section breaks with nulls to remove them. Select all and copy the lines back into the original iCal event file you created in step 1., replacing the template lines you highlighted in step 2 and save.
    8. Click on the iCal calendar file you've just updated. It will open iCal and import the events into the calendar you specify.

    If you're familiar with mail merge in Word, this all isn't difficult.

    Here's what the key Word Form Letter lines with my mergefield names look like:


    If you need other iCal lines, make a dummy event, look for the appropriate lines in the copied event, and replace the data with a mergefield title for your Excel data.

    Good luck!

  3. #3

    tonyoriordan's Avatar
    Member Since
    Jan 27, 2009
    Talking sync excel to ical for mac os x 10.5.6
    to sync your shift roster from excel to ical i will go through all the steps because usually people on shift will not normally use word form letters etc.
    1. prepare your data in Excel create column of dates and custom format colum yyyymmdd no forwad slash. only two other columns needed description and unique id

    2.create a single event in ical and drag to your desk top and open with word.
    3. delete last line END:VCALENDAR
    4.find unique ID "UID:C8E07A3D-2D99-4BC3-AEA5-DD87162B8C300" and copy to excel column put any number at end of ID and add 1 to next column C8E07A3D-2D99-4BC3-AEA5-DD87162B8C301 create a uid for every date by dragging down from two created,
    you data is now ready save excel sheet.
    5 In word go to tools and open Data merge manager
    a: Create "Form Letter"
    b: Get Data Open Data source which is your excel file
    C:The Merge fields appear
    Drag date to this field and replase date in front of T with merge field DTEND;TZID=Europe/Dublin:«sdate»T010000
    Descrition to this field
    Now go to merge and click on merge to new document
    new Doc is created
    In new Doc go to edit replace to remove page breaks and do the following
    in replace type ^b and in replace with box type the word break and hit the space bar once, this is important. Hit replace all . got to end of doc and replace the last line which should be the word break with END:VCALENDAR
    Nearly there.
    Edit Select all and copy to clip board. Go back to original .ics file and highlight all text and edit and paste over it.
    close file and answer yes to any pop up, your saved file should be in word format with .ics extension. drag file into ical and it should import all data.
    Best of luck hope this save you the aggro I had with this

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sync Outlook w/ iCal then iCal w/ Google Calendar
    By MacMike82 in forum OS X - Apps and Games
    Replies: 2
    Last Post: 02-07-2013, 03:13 AM
  2. iCal sync
    By Sibusiso36 in forum Switcher Hangout
    Replies: 3
    Last Post: 01-09-2013, 05:48 AM
  3. Sync. Excel Contacts
    By boxtrot in forum Switcher Hangout
    Replies: 2
    Last Post: 11-23-2011, 06:06 PM
  4. attempting to import an excel file into my iCal
    By mac-newb in forum OS X - Apps and Games
    Replies: 0
    Last Post: 04-15-2009, 12:23 PM
  5. iCal Sync
    By JBannister in forum iOS and Apps
    Replies: 1
    Last Post: 09-24-2008, 08:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts