How to merge Outlook calendars and how to overlay and import new ones.

Overlaying Outlook Calendars

These days, it’s not uncommon for people to have multiple calendars. You might have one for family, sports teams, schools, organizations or travel plans. In many cases, you don’t want to combine your main calendar with your favorite sports team.

Rather than displaying the calendars in a side-by-side view which can be difficult to spot differences, Outlook allows you to overlay the calendars. Each calendar has its own tab, but the color coded consolidated view better reveals conflicts and opportunities.

How to overlay Outlook calendars,

  1. Open Outlook
  2. Click Calendar in the Navigation pane.
  3. Check two or more calendars you’d like to see.
  4. Right-click one of the checked calendars.
  5. Select View in Overlay Mode from the menu.


(Note: The menu will switch between Overlay mode and Side-by-Side mode based on which one you’re viewing.)

Merging Outlook Calendars

Sometimes, I want to combine two Outlook calendars. One reason is some syncing programs fail to sync multiple calendars to my phone. Another reason is some calendars are “read-only” and I can’t edit the information. For example, I like to combine my travel calendar feed from a 3rd party service into my main calendar.

Microsoft Outlook doesn’t provide a menu option that will merge or combine calendars. The workaround is to export the secondary calendar and import it into your main calendar. This process works well for calendars you create, but you should verify none of the calendars are internet calendars or published calendars. Removing shared calendars will impact updates.

You can verify if you have any of these calendar types by going to File | Data Management. There are tabs for each of these items. Even though my travel calendar is an internet calendar, I’m comfortable removing it after the merge because I don’t anticipate any changes. In my case, I could always resubscribe to it.

listing of Outlook calendar types

To Export an Outlook Calendar,

  1. From the File menu, select Import and Export…
  2. In the Import and Export Wizard, select Export to a file.
  3. Click Next
  4. In the Export to a File panel, select Comma Separated Values (DOS).
  5. Click Next.
  6. In the Select folder to export from section, select your secondary calendar file. It may show in a different area like Internet Calendars.
  7. Click Next.
  8. Note the exported file name and path.
  9. Click Next.
  10. Because we’ll be importing this file back into Outlook, you can skip Map Custom fields….
  11. Click Finish.
  12. Provide a data range for the exported calendar.
  13. Click OK.

The above process exported your secondary calendar to a CSV file. The remaining part is to import this file into your main calendar. As you might expect the process is similar.

To Import a file into your main Outlook Calendar,

  1. From the File menu, select Import and Export…
  2. In the Import and Export Wizard, select Import from another program or file.
  3. Click Next.
  4. In the Select file type to import from panel, select Comma Separated Values (DOS).
  5. Click Next.
  6. In the File to import: section, make sure the CSV file you just exported shows. If not, browse to the file.
  7. In the Options: section, select the radio button that suits you needs.
  8. Click Next.
  9. Select the Destination for this file. (In my case, I’m importing this file into the Calendar that is in my Personal Folders.)
  10. Click Next.
  11. Confirm the listed action and click Finish.
  12. Review your main calendar to make sure it shows entries from both.

The last step is to delete your secondary calendar. If you’re not comfortable with deleting it, uncheck it so it doesn’t display in Microsoft Outlook.

How do I...?

  1. I am not able to login, what should I do?
  2. How do I change the leave type which is selected by default when requesting leave?
  3. As an Employee how do I cancel a leave request?
  4. As an Administrator how do I cancel a leave request?
  5. I am not receiving emails from LeaveWizard
  6. Employees are not able to enter Sickness
  7. Public Holidays are not showing on the calendar
  8. How do I hide certain employees from lists and charts?
  9. Can we use our own logo?
  10. How do I de-activate employees (end of employment)
  11. How do I re-activate employees?
  12. Employee X can't see anyone's sick days (or other event type) in any of the views
  13. I cannot delete an event type because it has previously been used to record leave events. Where do I see the events of this type?
  14. How do I restrict leave over a certain period - e.g. Christmas
  15. How do I set up an event type that is bookable on weekends?
  16. We have integrated Outlook however events seem to disappear after some time. Can we get these back?
  17. How do I remove the restriction on the allowance of a leave type?
  18. A leave type is included in the monthly allowance report but it should not be. How can I remove it?
  19. I am seeing some regional language in the calendar , How do i get it in English?
  20. I am not able to see public holidays in my leave calendar, What should I do?
  21. How do I restrict staff to only request holidays for the current holiday year?
  22. My events do not deduct overlapping Public holidays. How do I fix this?”
  23. How do I assign a PA for applying leave on someone's behalf?
  24. How do I assign an admin account to be an approver?
  25. How do I let employees know their login and how to access leavwizard?
  26. My allowances seem wrong, what could the problem be?
  27. How do I create paternity leave in the system
  28. How to restrict Paternity Leave" to specific individuals
  29. How to change employee from full-time to part-time
  30. How do I create Maternity Leave in the system
  31. How to merge Outlook calendars and how to overlay and import new ones.
  32. How do i set a minimum notice period in the system.
  33. What is a CSV file?

Feedback and Knowledge Base