Question 1

Can the new Outlook import a CSV file into the calendar?

Accepted Answer

No. Importing calendar events from a CSV exists only in classic Outlook for Windows, through File → Open & Export → Import/Export. The new Outlook and Outlook on the web import .ics files, which is what this page gives you.

Question 2

How do I import the file into the new Outlook or Outlook on the web?

Accepted Answer

Open Calendar, choose Add calendar, then Upload from file. Select the .ics file, pick the calendar the events should go into and confirm. All the events are added at once.

Question 3

How do I import it into classic Outlook for Windows?

Accepted Answer

Choose File → Open & Export → Import/Export → "Import an iCalendar (.ics) or vCalendar file" and select the file. When Outlook asks, choose Import to add the events to your own calendar; "Open as New" keeps them in a separate calendar instead.

Question 4

Does it work with a work or school account?

Accepted Answer

Yes. The events go into whichever calendar you pick when you upload the file, including a Microsoft 365 work or school calendar. Nothing here connects to your account: you upload the file to Outlook yourself.

Question 5

Can I use a CSV that was exported from Outlook?

Accepted Answer

Yes. A calendar exported from classic Outlook as CSV — Subject, Start Date, Start Time, End Date, End Time and so on — is read like any other spreadsheet, which makes this a way to move an old Outlook calendar into the new Outlook.

Question 6

What columns does my CSV need?

Accepted Answer

A title and a date at minimum. Start time, end time, location and description are optional. The header names do not have to match a template: "Subject", "Event", "Start", "Begins at" and similar are recognised.

Question 7

How many rows can I import at once?

Accepted Answer

Hundreds of rows in one file. Each row becomes its own event in a single .ics file, so the whole list goes into Outlook in one upload.

CSV to Outlook Calendar — Works with the New Outlook

One file for every Outlook

No field mapping

Start and end times kept

How to import a CSV into the Outlook calendar

Example CSV

Frequently Asked Questions

More spreadsheet converters