In this tutorial, I’ll show you how to create Outlook appointments from a few Excel records. SEE: The Complete Microsoft Office Master Class Bundle (TechRepublic Academy) For efficiency’s sake, I’d choose the latter! To make the data more useful, you could manually enter each record as a new appointment into Outlook, or you can import the Excel data directly into Outlook as appointments. But if you use Outlook to keep up with your obligations, a list in Excel isn’t all that helpful. It’s not unusual to receive an Excel sheet with a list of appointments or tasks.

For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Learn how to quickly import Excel data into Outlook appointments after converting the data into a comma-delimited file. Make a separate calendar in Outlook by right-clicking on Calendar in the left Navigation Pane and choose ‘New Calendar’.Īdd calendar items as usual.Learn how to import Excel records into an Outlook Calendar Multiple calendars can be viewed side-by-side or overlaid into a single view with your own calendar. Rather than share your personal calendar, make a separate or sub-calendar. Share CalendarĪn entire calendar can be shared with other people.

A single calendar that everyone in the family can see.īirthdays are usually managed within Contacts but could be added to a shared calendar as well. Moving house, anniversaries of relatives/friends, school terms. Product Launch, moving head office, take over, arrival of important staff/managers.Įven families could use a shared calendar to track major events. In an organization, a shared calendar could remind staff of important anniversaries. Add an event for the original date/time plus reminders for each year, 5 years or decade after that. Most shared calendars are for current appointments but there’s a less well-known use as reminders of historical events.

How to add event to outlook calendar