📄️ How do I install the add-in?
You can find the add-in in the Microsoft AppSource Marketplace by searching for Excelendar.
📄️ How do I set up Excelendar?
Once you have installed the add-in, open the Excelendar tab in the ribbon bar and click on the "Open Taskpane" button. Once the taskpane is opened, you will need to authenticate with your Microsoft account. The add-in will request the following permission scopes: Calendar.ReadWrite and Mailbox.ReadSettings.
📄️ Importing your first Calendar into Excel
When working with Excelendar, it is important to know that the add-in operates by assigning Calendars in Outlook to Excel Worksheets 1:1. This means that you cannot have multiple calendars in the same sheet.
📄️ Exporting to Outlook Calendar
When you have imported a Calendar into a worksheet and made changes in Excel, you can apply those changes to the calendar in Outlook by using the provided export functionality. Press the "Export" button in the taskpane for changes to be applied in Outlook Calendar.
📄️ How to import changes from Outlook Calendar into Excel
Once your chosen calendar has been imported into your desired Excel sheet, you can import changes made in Outlook into Excel without re-importing the whole calendar from scratch, which can save a lot of time depending on the calendar size. Press on the "Import Changes" button in the taskpane to import changes from Outlook.