Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Operating System
Sync ical with excel
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="albanmews" data-source="post: 494188" data-attributes="member: 35632"><p>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:</p><p></p><p>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.</p><p>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.</p><p>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.</p><p>4. Copy your Excel worksheet data into a new Word document which will be your Data Source for your mail merge.</p><p>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.</p><p>5. Replace the event description in the SUMMARY: line with your mergefield for event description.</p><p>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").</p><p>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.</p><p>8. Click on the iCal calendar file you've just updated. It will open iCal and import the events into the calendar you specify.</p><p></p><p>If you're familiar with mail merge in Word, this all isn't difficult.</p><p></p><p>Here's what the key Word Form Letter lines with my mergefield names look like:</p><p></p><p>DTSTART;TZID=US/Eastern:«yymmdd»T«starthhmmss»</p><p>SUMMARY:«description»</p><p>DTEND;TZID=US/Eastern:«yymmdd»T«endhhmmss»</p><p>DESCRIPTION:«noteline1»\n«noteline2»</p><p></p><p>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.</p><p></p><p>Good luck!</p></blockquote><p></p>
[QUOTE="albanmews, post: 494188, member: 35632"] 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: DTSTART;TZID=US/Eastern:«yymmdd»T«starthhmmss» SUMMARY:«description» DTEND;TZID=US/Eastern:«yymmdd»T«endhhmmss» DESCRIPTION:«noteline1»\n«noteline2» 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! [/QUOTE]
Verification
Name this item 🌈
Post reply
Forums
Apple Computing Products:
macOS - Operating System
Sync ical with excel
Top
