Outlook does not import an Excel workbook into the calendar, and the new Outlook has no CSV import either. Upload your .xlsx here — a project plan, a training schedule, a team rota — and each row becomes an appointment in an .ics file that the new Outlook, Outlook on the web and classic Outlook all accept.
No exporting to CSV first and no template. The first sheet that holds a table is read, and the column headers decide what goes where.
The new Outlook and Outlook on the web take .ics files through Add calendar → Upload from file, so there is no need to switch back to classic Outlook.
The workbook itself is not uploaded. Only the rows of the sheet are sent, as plain text, to be turned into events.
Session | Date | From | To | Room Induction | 16/11/2026 | 09:00 | 12:00 | Training 1 Fire safety | 17/11/2026 | 13:00 | 14:00 | Training 2 Systems demo | 19/11/2026 | 10:00 | 11:30 | Online
Three Outlook appointments on 16, 17 and 19 November, each with its start time, end time and room.
Want a file to start from? Download the sample CSV, which also opens in Excel and Google Sheets.