none
Add Holiday Calendar to SharePoint

    Question

  • I'd like to add Holidays to our SharePoint calendar. We are using MOSS 2007 and Outlook 2003. I can't seem to figure out how to import an outlook calender with holidays to SharePoint calendars or how to impost and Excel holiday calendar to SharePoint. I think my best bet is Excel. If you know how to import a holiday calender to SharePoint via Excel, will you provide me step-by-step instructions?
    Wednesday, October 14, 2009 1:31 PM

Answers

  • Hi.

    Export your calendar from Outlook using these steps:

    1. File -> Import and Export
    2. Select "Export to a file", Next.
    3. Select "Tab separated values (Windows)", Next
    4. Select your Calendar, Next
    5. Select y export file name and folder, Next
    6. Select Finish
    7. Click Ok in the Set Date Range" dialog.

     Import the file into a new list using these steps:

    1. Site actions -> Create
    2. In the "Custom Lists" section, select "Import Spreadsheet"
    3. Enter a name and description for your list
    4. Browse to your exported text file.
    5. Click Import

     Excel will start up with a Import dialog.

    1. In the import dialog, select "Range of cells"
    2. Click in the "Select range" text box.
    3. Select the Subject to End Time columns and drag down to all rows you want to import.
      (So it will result in something like MyExportedCalendar!$A$1:$E$46 , I had 45 + header rows)
    4. Click Import.

    The data is now imported in to a list.

    1. Select View and -> Create View.
    2. Select "Calendar View"
    3. Enter a name for the View, for example My Calendar View
    4. In the Time Interval section, select Begin -> Start Date and End -> End Date
    5. In the Calendar Columns, select Month View Title -> Subject, Week View Title -> Subject and Day View Title -> Subject
    6. Click Ok.

    You now have a Calendar view your imported items.

    Hope this helps.

    Regards,
    Magnus


    My blog: http://InsomniacGeek.com
    • Marked as answer by mswanson19 Wednesday, October 14, 2009 3:32 PM
    Wednesday, October 14, 2009 2:24 PM

All replies

  • Hi.

    Export your calendar from Outlook using these steps:

    1. File -> Import and Export
    2. Select "Export to a file", Next.
    3. Select "Tab separated values (Windows)", Next
    4. Select your Calendar, Next
    5. Select y export file name and folder, Next
    6. Select Finish
    7. Click Ok in the Set Date Range" dialog.

     Import the file into a new list using these steps:

    1. Site actions -> Create
    2. In the "Custom Lists" section, select "Import Spreadsheet"
    3. Enter a name and description for your list
    4. Browse to your exported text file.
    5. Click Import

     Excel will start up with a Import dialog.

    1. In the import dialog, select "Range of cells"
    2. Click in the "Select range" text box.
    3. Select the Subject to End Time columns and drag down to all rows you want to import.
      (So it will result in something like MyExportedCalendar!$A$1:$E$46 , I had 45 + header rows)
    4. Click Import.

    The data is now imported in to a list.

    1. Select View and -> Create View.
    2. Select "Calendar View"
    3. Enter a name for the View, for example My Calendar View
    4. In the Time Interval section, select Begin -> Start Date and End -> End Date
    5. In the Calendar Columns, select Month View Title -> Subject, Week View Title -> Subject and Day View Title -> Subject
    6. Click Ok.

    You now have a Calendar view your imported items.

    Hope this helps.

    Regards,
    Magnus


    My blog: http://InsomniacGeek.com
    • Marked as answer by mswanson19 Wednesday, October 14, 2009 3:32 PM
    Wednesday, October 14, 2009 2:24 PM
  • This is EXACTLY what I needed. Thanks!
    Wednesday, October 14, 2009 3:32 PM
  • This is also exactly what we needed.

    Thanks.

    Wednesday, June 27, 2012 12:27 PM