![import calendar to outlook format import calendar to outlook format](https://news.daypilot.org/image/big/2gn27zlnvjhpjpl6ocpuhfvhsm/asp.net-icalendar-export-outlook-google-calendar-mac-os-x.png)
Why do we import a Calendar from Microsoft Excel to Outlook?
#Import calendar to outlook format how to#
In this article, you will know about how to import a Calendar from Microsoft Excel to Outlook. Microsoft access can import data from Microsoft Excel and you can even export data to Excel. You can transfer data from Excel to Word with simple steps. By the way, if you do want two-way synchronisation from Outlook desktop to a Google or iCloud calendar (or contacts) there’s a very useful utility called “CalDavSync” but it doesn’t work here.One of the great features of Microsoft office suite is you can easily transfer data from one office product to another. Also there’s no button to force synchronisation so it’s all very difficult to test. There are lots of situations in which everything seems to work (success messages, no warnings or errors) but only some of the entries are imported, old entries are not replaced and future synchronisation doesn’t happen. If instead you try to synchronize direct from the desktop it downloads once but doesn’t synchronise in future and that tab doesn’t appear. In this case you can right-click on the desktop calendar, view Properties and see a “Synchronization” tab. If you then connect the desktop version of Outlook to the web account (using Exchange) the calendar will automatically show up on the desktop and synchronise properly to the original source.
#Import calendar to outlook format update#
Go to “Add calendar > Subscribe from web” and then everything seems to synchronise and update from the original source properly. What worked in the end was subscribing to the calendar using the web version of Outlook at. Sorry to bother you and I’ll explain how I did it below in case it helps anyone with a similar problem.
![import calendar to outlook format import calendar to outlook format](https://support.content.office.net/en-us/media/ab6de211-9944-4484-a303-96765a17c83d.png)
The ICAL_APPLE thing makes no difference. OK, I have good news – the problems are all at the Microsoft end (what a surprise!) so you don’t need to change anything. Possibly the X-APPLE-STRUCTURED-LOCATION values are tripping it up? On the web version of Outlook (I can go to “Calendar > Add Calendar > Subscribe from web”, enter the events.ics URL and I get a “success” message and the calendar appears in the sidebar but no events appear in the calendar view.Īll of the above tests work properly with other webcal feeds, for example – the problem is specific to Events Manager calendars.Īlso, I have successfully synchronised to Events Manager calendars using Google calendar ( ) so the information is there, it’s just not in the right format for Microsoft. The events have been “imported” but not “synchronised”. However they never update and if I right-click on the calendar name in the left sidebar and select “Properties” I don’t see the expected “Synchronization” tab. On the desktop version of Outlook, clicking “Add > From internet” in Calendar view opens a “New Internet Calendar Subscription” popup and I can enter the events.ics URL and events do appear in my calendar. I can’t find any way to report bugs so I’m posting here in the community forum – is that what I’m supposed to do? It initially appears to work but events are not importing or synchronising properly. Subscribing to an Events Manager iCal feed (e.g.