SharePoint - Export SharePoint event to Outlook Calendar - Question for Alon Havivi

1. Create a new calendar list on your SharePoint site.  You can do this by clicking Site Actions > View all Site Content  then…
   
   click Create And select Calendar
   
   
2. Now that our blank calendar is created we can now work on getting the items imported… which is the objective of this article: Open your Microsoft Outlook Calendar and copy the Public Folder by (a.) right-clicking on the Calendar Icon and (b.) copying it into a new folder called “Calendar Copy” located in your mailbox folders (you will have to create this folder before copying). 
   Above: Depending on how old the Calendar and its size it could take 2-20 minutes to copy. 
3. Now in a nutshell it’s time to export your Outlook Calendar into a Excel file format with the following columns:
   • Subject
   • Location
   • Start Date
   • Start Time
   • End Date
   • End Time
   • All Day event
4. We can do this by selecting the “Calendar copy” folder that we just created and clicking File > Import and Export…
   
   
   
   This will bring up the Wizard view 1.  Select Export to a file
   Now select Microsoft Excel 97-2003
   Select the location you wish to save the file.
   This will bring up the date range configuration popup.  
   Select the appropriate dates.
   
   
   Confirm the actions and finish the Wizard.
   If you need more help please check out the following Microsoft Help about Microsoft Outlook Import and Export.
5. Now that your data is in the Excel file let’s open it up and see what’s in there.  At this point you will notice the Start Date and End Date are in two separate columns.   Now before we do anything to this data we will need to go back to the blank Calendar list in SharePoint and switch to All Event View.  You can do this by entering the list and clicking Modify View > All Events View
6. Export this empty view to a Excel Spreadsheet and open it.  You can do this by clicking Actions > Export to Spreadsheet
   
   
   
7. Open this exported Outlook Calendar, merge Start Day and Start Time to a single column.  I’m not going to get into the detailed specifics of how to merge these columns as it may differ for individual users, but… In a high-level overview how to merge the columns you can use a formula similar to:
   
   =CONCATENATE(B:B,” “,C:C) or =CONCATENATE(D:D,” “,E:E) for a blank column in the same workbook to merge 2 column’s data. 
   
   The “B:B” is the column containing the Start date, the ” ” adds a space, and the “C:C” is the End Date.  If your data is in another you must column change the letters correspond to the appropriate column. 
   Above: In the image above you can see column M and N hold both Start/End date and times.
8. Merge End Date and End Time to another single column. Both of these two column should have two spaces between date and time and YY as year, not YYYY or 4 digits.
9. Copy all Subjects from the exported Calendar to Title column of the Calendar list. The rest are straight forward. Do not put anything to WorkSpace column since it’s read-only.
10. Correct any errors if you have any and please post them within this article’s comment for a solution. Then sync this list to the SharePoint calendar.

Final Result:

All items from Outlook are now on our new Calendar.

Related posts:

1. How to Move SharePoint Calendars Fast Moving a calendar list between site collections may be confusing, but it is actually very simple! This article demonstrates one method using list templates and Windows Explorer to move SharePoint Calendars fast.  Don’t worry, all your content will be moved also.  Let’s begin: You must have proper permissions between the two site collections to perform [...]...
2. SharePoint Data View Web Part Announcements List The frontpage of any corporate Intranet should have announcements to provide site users with up to date information about the on goings of the company. SharePoint provides a number of options to make this possible. The following article will provide you with information about how to use the Data View Web Part to display an [...]...
3. Custom SharePoint List Icons Recently I was asked by my manager to create a dashboard for executive members to quickly see the progress of active projects. She explained to me that she wanted a “priority level” indicator similar to that of the KPI in a basic table structure. The color of the indicator would change depending on the status [...]...
4. SharePoint Calendars: Remove the time for calendar items The ITS department created a new calendar dashboard and were delighted that they could finally discontinue the Outlook Public Folder Calendars that were previously in use. There was though one request that is completely understandable: “Please remove the ’12:00 AM and 11:59 PM’ values for the Start Time and End Time and instead just make [...]...
5. How to remove the “title” column from a SharePoint list Have you asked yourself the question: How do I remove the ‘title column’ from a Sharepoint list?  It can be annoying trying to figure out how to remove this column from default lists.  Often, site admins want their audiences to click on “New Item” in a Sharepoint list and not have to fill out the [...]...