How do I Export, Import, and Merge Calendars in Outlook?

Calendar is one of the most prominent features in Microsoft Outlook, using which one can set up meetings, organize appointments, schedule work, etc. Working with an Outlook Calendar can become difficult under various circumstances. Such as working with multiple accounts or recently upgraded Outlook to a newer version or if you are unable to access Outlook Calendar from multiple devices.

This article is compiled with all the information that you need to know about exporting, Importing, and Merging your Outlook Calendar items with ease.

Table of contents:

 1. How to Export Outlook Calendar? 2. How to Export Outlook Calendar? 3. How to Merge Outlook Calendar?
a. Export Outlook Calendar to Google Calendar a. Import Google Calendar to Outlook a. Combine multiple Calendars in Outlook
b. Export Outlook Calendar to Excel sheet b. Transfer Outlook Calendar to Google Calendar
c. Export Outlook Calendar to PST file

Export Outlook Calendar

If you are looking for a way to backup your Outlook Calendar items you can achieve it through exporting. Follow the below-mentioned methods to export your Outlook Calendar with ease.

Export Outlook calendar to Google Calendar

If you use a Calendar on both Gmail and Outlook, you might have set appointments differently on these applications. Sometimes it will be annoying for sure because it will be difficult to manage both calendars at a time.

If you make a decision to have all your Outlook Calendar items on Google Calendar, you can achieve it by following the below steps.

  • Open Outlook, click on Calendar
  • Now click on the File and Save Calendar
  • Specify the name and select the location where you want to save and click on Save

click on save calendar

 In case if you want to import your Outlook Calendar to Google Calendar refer to the importing section given below

Export Outlook Calendar to Excel sheet

Exporting Outlook Calendar to Excel sheet is another way of backing up your Outlook Calendar items, you can achieve it by following the below steps.

  • Open Outlook, click on the File
  • Go to Open & Export and click on Import or Export

open export&import

  • Select the Export to a file  and click on Next

click on export file

  • Select Comma Separated Values and click on Next

click on comma seperated file

  • Click on Finish and provide the Date Range.

Note: Mentioning the date range to export Outlook Calendar helps to prioritize the exporting process and saves your time else the process of exporting the Outlook Calendar to excel takes more time.

Do you know instead of struggling with these manual ways, you can make use of the automated process using Remo Outlook Backup and Migrate tool?

Remo Backup and Migrate for Outlook is an exclusive tool developed to ensure safe backup of Outlook data and swift transfer of the same across multiple devices and Outlook versions. The tool is a necessity against the manual method of moving Outlook data. Download this tool to backup and transfer your Outlook data in simple clicks.

Export Outlook Calendar to PST File

If you are looking for a way to export Outlook Calendar to PST file, follow the below-mentioned steps:

  • Click on File and go to Open & Export
  • Now go to Import or Export and click on Export to file and click on Next
  • Select Outlook data file (.pst) and click Next.

Outlook data pst

  • In the next window select the Outlook Calendar folder and click on next

calendar

  • Click on Browse to specify the location and name the file to be exported in the PST format
  • And click on the Finish button

That’s all you have successfully exported Outlook Calendar to a PST file. If you find any trouble with the PST file or find it damaged or corrupted, you can check out this article on how to repair PST file | corrupt, damaged, or not working.

Import Outlook Calendar

If you have multiple accounts or upgraded to a new Outlook version then you surely need importing,  as you probably want your old work to be in a new Calendar or on a new Outlook version. You can achieve it by following the below mentioned methods.

1. Import Google Calendar to Outlook

Before you begin with the steps of Importing, you need to have a backup in order to import the Google Calendar items. If you don't have a backup don't worry you can achieve it by following the below mentioned steps. Incase if you have already taken a backup you can move down to the Part B.

a. Export Google Calendar to Outlook.

  1. Firstly, Log in to your Gmail account, and then select Calendar
  2. Then choose my Calendar and go to Settings
    go to settings
  3. Then select Export
    export
  4. Now, select the location to save the extracted file and select Extract All

select file ending with Gmail

b.  Import google Calendar to Outlook

Now you have exported the Outlook Calendar to Google Calendar items, you can start with the steps of importing.

  1. Open Outlook profile, go to your Calendar
  2. Choose FILE then Open & Export and then select Import/Export
  3. In the import and export wizard, choose Import an icalendar(.ics) and click on Next
    click on ical
  4. Now Browse to where you have saved the extracted file, and then select the one that ends with gmail.com, and choose OK

choose file

 2. Transfer Outlook Calendar to Google Calendar

The process of exporting Outlook Calendar to Google Calendar can be divided into two parts, the first is exporting the items from Outlook Calendar and then importing the Calendar to Google Calendar.

Note: If you don't have a backup refer to Export Outlook Calendar to Google Calendar given in the above section.

Import Outlook Calendar to Google :

Now to import Outlook Calendar to Google Calendar follow the simple instructions mentioned below:

  • Open Google Calendar and click on Settings

click on settings

  • Select Import and Export

select import/export

  • Click on Select the file from your computer and now you can select the exported Outlook Calendar
  • Click on Import and that’s it you have successfully added exported Outlook Calendar to your Google Calendar

Merge Outlook Calendar

Many users often have access to multiple Calendars, some of which are shared by managers, or clients, etc. In this scenario, you may be required to merge multiple Calendars items, that way you can have access to all their items in one place.

Combine Multiple Calendars

Outlook provides two methods to Combine Multiple Calendars, which hardly takes a few minutes.

Follow the below-mentioned steps to Combine Multiple Outlook Calendars into one.

Method 1:

  • Open Outlook Calendar and select the Calendar events you like to merge
    select file
  • Click on the Calendar. And select the Calendar in which you like to merge data

Method 2:

  • Firstly switch the Calendar to the list view.

click on list

  • Select all the listed items in your Calendar you would like to copy.

select calendar

  • Now click the drop-down button and select the Calendar and click on OK.

Conclusion

All the above-mentioned methods will certainly help you to manage your Outlook Calendar. Amidst all the manual methods, the completely automated way of migrating Outlook is using Remo. It is the best-recommended method for a safe and swift backup and migration process.
Do let us know your thoughts on this article. And do make use of the comments section below if you have any queries.

How do I Export, Import, and Merge Calendars in Outlook? was last modified: October 26th, 2021 by John Harris

Leave a Reply

Your email address will not be published. Required fields are marked *

*