How to Import Outlook Calendar Into SharePoint

Written by james stone
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Import Outlook Calendar Into SharePoint
( Images)

Microsoft SharePoint makes it easier for employees to work together in a collaborative environment. Combined with Outlook's functionality, employees can set up a web site to share information with colleagues, including shared calendar information. They only need to import each individual calendar's data in order to combine scheduled events from each member's own Outlook calendar.

Skill level:


  1. 1

    Open Outlook and then click "File" and from the drop-down menu. Click the "Import and Export" link.

  2. 2

    Click the "Export to a file" from the "Choose an action to perform" box. Click the "Next" button.

  3. 3

    Click the "Microsoft Excel" from the "Create a file of type" box and then click the "Next" button. Click the "Yes" button when prompted to install.

  4. 4

    Click the "Calendar" folder from the "Select folder to export from" box and then click the "Next" button.

  5. 5

    Click the "Browse" button to save the file to a location of your choice.

  6. 6

    Click the "Map Custom Fields" check box to specify the column headings and data that will appear. Click the "OK" button and then click the "Finish" button.

  7. 7

    Double-click on the Excel spreadsheet you saved to open it. Format the column headings and then click "Save As a Web page."

  1. 1

    Open SharePoint and click the "Create" button on the top link bar.

  2. 2

    Click the "Import Spreadsheet" link from the Create Page window.

  3. 3

    Type a name and description in the Name and Description section of the window.

  4. 4

    Click the "Browse" button from the Import from Spreadsheet area to locate the spreadsheet and then click the "Open button." Click the "Import" button. The Import to SharePoint List window displays on screen and the Excel worksheet opens.

  5. 5

    Click the button next to the "Select Range" box. Click the upper-left cell in the spreadsheet and drag across the screen of all the cells you want imported in SharePoint. Click the "Import" button to finish the process.

Tips and warnings

  • Outlook data changes over time and SharePoint does not automatically update this data.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.