It is critical that they are spelled the exact same way in Outlook and Excel. Enter the categories into Excel and sort them alphabetically once you are finished entering them. You can add as many categories as you like, although, there are only 25 different colors in Outlook.

I would highly recommend renaming them something useful. The default categories are based on color. Click on the “Categorize” icon and a list of all of the categories that have been set up will appear. They can be found in Outlook by going to the calendar section and opening up a new appointment.

In cell E3, enter “Categories.' Starting in E4, enter all of the categories that you use in Outlook.

Highlight B4:B5, and in the “Name Box” in the upper left-hand corner of the screen and name that section “ADE.'

In cell B3, enter “All Day Event.' In cells B4 and B5, enter “Yes” and “No” respectively.

Rename one of the tabs “Control” by right-clicking on a tab and selecting “Rename.'.

Open a new workbook in Excel and save it as “Calendar Upload.xls.' It is vitally important to save it as an “Excel 1997 – 2003 Workbook” because Outlook can only update the.

The items are automatically imported into your calendar. Select the calendar file from your PC and select OK.

In Import and Export Wizard box, select Import an iCalendar (.ics)or vCalendar file (.vcs),and then Next. In Outlook, select File > Open & Export > Import/Export. Select the arrow to overlay the calendar if you want. Any calendar can be turned on/off in the Folder Pane. Your calendar items appear and will synchronize. Outlook asks if you would like to add this calendar and subscribe to updates. Paste the URL from your internet calendar and select OK. Open your Outlook calendar, select Add > From Internet.

Scroll down to Integrate calendar and copy the Secret address in iCal formatURL. In Google Calendar, select Options > Settings and sharing. You can add online calendars from Google and others right into Outlook.

How to import ical to outlook 365