List the appointments in a sheet with these fields: Subject, StartDate, EndDate, StartTime, EndTime, Location and Description, the first two fields are needed at least.ģ. In sometimes,you may need to create appointments in Outlook calendar, but have you ever tried to list appointments in Excel worksheet, then import them to Outlook calendar as below screenshot shown?Ĭreate appointments from Excel sheet to Outlook calendarįirstly, you need to save the sheet as CSV(Comma Delimited) file.ġ. How to create appointment from Excel sheet to Outlook calendar?