Export Calendar Microsoft Outlook 16.9

© Thomas Barwick/Getty Images You can sync your Google Calendar to Outlook on a Mac or PC. Thomas Barwick/Getty Images
  • You can sync your Google Calendar to the Outlook desktop app for Mac by adding your Google account and PC by importing your calendar.
  • You can also sync your Google Calendar to your Outlook.com account.
  • If you have a paid G Suite account, you can use the G Suite Sync for Microsoft Outlook tool.
  • Outlook can automatically sync with a Google Calendar when you use Outlook on mobile devices for iOS and Android operating systems.

If you use Outlook and Google calendars to manage your life, syncing them is critical to avoiding conflicts and ensuring you don't miss planned events or calls.

To export your calendar, open Outlook and then click File Open & Export. Choose the “Import/Export” option. In the Import and Export Wizard that opens, select “Export to a file” and then click “Next”. Select “Comma Separated Values” and click “Next”. Now, select the “Calendar” option in the folder list. Export calendar from Outlook to Excel spreadsheet. Go to File Open & Export Import/Export. See screenshot: 2. In the opening Import and Export Wizard, Under Choose an action to perform, select Export to a file, and then click Next to continue. .A better option is to export one calendar and import it into the other. Export a Microsoft Outlook Calendar. Start with the calendar you wish to export. Under the File tab, select “Options” then “Advanced” and finally “Export.” Select the file you want to export and choose “Next.” You’ll need to export the Outlook Calendar as.

How you add a Google Calendar to your Outlook account depends on what platform you're using. You can import your calendar, add your entire Google account to your Microsoft desktop app, or add a calendar while logged into your Outlook account.

If you want to sync your Google Calendar to Outlook, here are three ways to do it.

Check out the products mentioned in this article:

Microsoft Office (From $149.99 at Best Buy)

Apple Macbook Pro (From $1,299.00 at Apple)

Acer Chromebook 15 (From $179.99 at Walmart)

How to sync your Google Calendar on Outlook.com

1. Open Google Calendar.

2. In the left-hand column, hover over the calendar you want to add to Outlook.

3. Click the three dots beside the calendar.

4. Select 'Settings and sharing.'

© Abbey White/Business Insider You can only add one Google Calendar to Outlook at a time, though you can sync as many as you want. Abbey White/Business Insider

5. On the Settings page, scroll to the 'Integrate calendar' section

6. Copy the 'Secret address in iCal format' link.

© Abbey White/Business Insider This link will be pasted into Outlook. Abbey White/Business Insider

7. Log in to Outlook.com and click the calendar icon in the left sidebar.

© Abbey White/Business Insider This icon will be to the left of your Inbox folders list. Abbey White/Business Insider

8. Click 'Add calendar.'

9. Choose 'Subscribe from the web' in the left-hand column.

10. Paste the 'Secret address in iCal format' link.

11. Title the calendar and then click 'Import.'

© Abbey White/Business Insider If you don't title the calendar you won't be able to import it. Abbey White/Business Insider

How to sync your Google Calendar on Outlook for Windows

1. Go to https://calendar.google.com.

2. Click on the gear icon in the upper-right.

© Abbey White/Business Insider You can find this option in the upper-right next to your profile icon and the month dropdown. Abbey White/Business Insider

3. Select 'Settings' from the drop-down menu that appears.

4. Choose 'Import & Export' in the left sidebar.

5. Select 'Export' to download a zipped .ics file of your Calendar content.

© Abbey White/Business Insider A downloading link should appear at the bottom of your browser screen. Abbey White/Business Insider

6. Launch Microsoft Outlook.

7. Click 'File' in the upper menu bar.

8. Select Open & Export from the left sidebar.

Outlook

9. Click the 'Import/Export' option.

© Abbey White/Business Insider The third icon down features green and blue arrows. Abbey White/Business Insider

10. In the pop-up window that appears, click 'Import an iCalendar (.ics) or vCalendar file (.vcs)' before selecting 'Next.'

© Abbey White/Business Insider This is the file format that matches your Google Calendar download. Abbey White/Business Insider

11. In the file window, locate and select the zipped folder you downloaded for Google Calendar before clicking 'Open.'

12. Choose 'Import' in the window that appears to bring your Google Calendar items into your Microsoft Calendar. You can also choose to create a new calendar in Outlook.

Export Calendar Microsoft Outlook 16.9© Abbey White/Business Insider Your Google Calendar will not be visible in Microsoft Outlook. Abbey White/Business Insider

How to sync your Google Calendar on Outlook for Mac

1. Launch Microsoft Outlook.

2. Click on 'Outlook' in the top toolbar.

3. Select 'Preferences' from the drop-down menu.

© Abbey White/Business Insider This option will be directly beneath 'About Outlook.' Abbey White/Business Insider

4. Choose 'Accounts.'

© Abbey White/Business Insider This section stores all the accounts you have connected to Outlook. Abbey White/Business Insider

5. Click on the '+' icon at the bottom of the left sidebar.

© Abbey White/Business Insider This will let you add or create a new account. Abbey White/Business Insider

6. Select 'New Account.'

7. In the login window that appears, enter the Gmail account associated with the Google Calendar you want to sync then press 'Continue.'

© Abbey White/Business Insider The email doesn't have to be associated with Microsoft Outlook. Abbey White/Business Insider

8. Choose 'Continue' to authorize your Gmail account to be synced to the Microsoft Cloud.

9. A new browser window will open with a list of your Google Accounts. Select the email account you want to sync to Outlook.

© Abbey White/Business Insider Choose the Google account you want to sync. Abbey White/Business Insider

1o. On the next page, click 'Allow' to authorize Microsoft Apps & Services to have access to your Google Calendar.

11. Select 'Open Microsoft Account' in the pop-up window that appears.

12. Click 'Done' after your account has been added.

13. Click the Calendar icon at the bottom of Outlook's left sidebar to see your Google Calendar events in your Microsoft Calendar.

Related coverage from Tech Reference:

-->

You can share calendar information in Microsoft Outlook by either sharing a calendar folder, if you have an Exchange Server account, or by exporting the contents of a calendar folder to an iCalendar calendar (.ics) file. Calendar information can also be shared online using a variety of protocols.

For more information about sharing online calendars, see Sharing Online Calendars, RSS Feeds, Microsoft SharePoint Foundation Folders, and Exchange Folders.

Sharing Calendar Folders

Template

Sharing messages are used to either invite or request access to a calendar folder, or to respond to a sharing invitation or request by either allowing or denying access to a calendar folder. To construct a sharing invitation or sharing request, the CreateSharingItem method of the NameSpace object is used to create a SharingItem object. A Folder object reference to the desired calendar folder is used to establish the sharing context for the sharing message.

Note

You can only reference the Calendar default folder when creating a sharing request. A single SharingItem object can represent both a sharing invitation and a sharing request, if the Calendar default folder is used as the sharing context.

Export Calendar Microsoft Outlook 16.9 2020

Sharing responses are automatically created and sent by calling the Allow or Deny methods of a SharingItem which represents a sharing request. Calling the Allow or Deny method allows or denies, respectively, access to the requested folder - the user requesting access need not receive the sharing response.

Exporting Calendar Information

The CalendarSharing object is used to export information from the calendar folder to an iCalendar calendar file, and can also be used to create a MailItem object that not only contains the iCalendar calendar file as an attachment, but also provides the calendar information as formatted HTML within the body of the mail message. The CalendarSharing object provides several properties that can be used to limit the scope and detail of calendar information included in the iCalendar calendar file and in the body of the MailItem.

The GetCalendarExporter method of the Folder object is used to obtain a CalendarSharing object reference for a specified calendar folder. From the CalendarSharing object, you can either use the SaveAsICal method to save an iCalendar calendar file, or you can use the ForwardAsICal method to create a MailItem that contains both formatted calendar information and an iCalendar calendar file.

Calendar Microsoft Word

Once exported, an iCalendar calendar file can be opened by using the OpenSharedFolder method of the NameSpace object.

Export Calendar Microsoft Outlook 16.9 Download

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.