Guide · Office and email
How to import an Excel or CSV schedule into Outlook Calendar (new Outlook, classic, web)
By Blink Brief · Updated · How pages are made
New Outlook and Outlook on the web import an .ics file, not a CSV: Microsoft's Upload from file asks for an .ics. So paste your Excel or CSV rows into the free CSV to ICS converter, check the events in its preview, press Download .ics, then in Outlook go to Calendar › Add calendar › Upload from file. The same .ics file imports into classic Outlook for Windows and Outlook for Mac, each with its own steps below. Classic Outlook's Import and Export Wizard also reads CSV files, but the Microsoft pages we found document that route for contacts, not for calendar events.
Short answer
- First, every version: CSV to ICS › paste the rows › check the preview › Download .ics.
- New Outlook, Outlook on the web, Outlook.com: Calendar › Add calendar › Upload from file › Browse › choose the calendar › Import.
- Classic Outlook: File › Open & Export › Import/Export › Import an iCalendar (.ics) or vCalendar file (.vcs) › Open as New.
- Outlook for Mac: open Calendar, drag the .ics file onto the grid, click Import.
Which Outlook do you have?
- Outlook on the web or Outlook.com: Outlook in a browser tab. Microsoft's tip: with a personal Microsoft account you use Outlook.com; with a work or school account, Outlook on the web.
- New Outlook for Windows: the newer Windows app; its calendar import is the same as Outlook on the web's.
- Classic Outlook for Windows: the app with a File menu at the top left.
- Outlook for Mac: the Mac app.
Microsoft's advice when the steps don't match: "If the steps under this New Outlook tab don't work, you may not be using new Outlook for Windows yet." The versions side by side, for an .ics file, are in importing an .ics file into Outlook.
New Outlook and Outlook on the web: an .ics with Upload from file
1. Make the .ics from your rows
- In Excel, select the schedule with its header row and copy it; or keep the .csv file and use Choose a .csv file on CSV to ICS.
- Paste the rows into the box. Check What each column holds, Date order and Time zone, then read the preview: every event with its row number, day, times and place.
- Press Download .ics.
2. Import it in Outlook
Microsoft's steps for Outlook.com and Outlook on the web:
- Select Calendar in the navigation pane, then Add calendar.
- Select Upload from file, then Browse, choose the .ics file and select Open.
- Select the calendar you want the events imported to, then Import.
New Outlook for Windows has the same steps, with one limit on Microsoft's page: "Importing events from an .ics file is only supported for Microsoft 365 Exchange accounts." With an Outlook.com, Hotmail or Live account, sign in to Outlook.com in the browser and import there; the events then show in the app too. No Add calendar? Microsoft says the navigation pane is collapsed; expand it from the icon at the top of the calendar.
Microsoft on the result: "When you import an .ics file, your calendar doesn't refresh the imported events, even if the calendar's owner makes an update." Change the sheet, and you convert and import again.
Classic Outlook: import the .ics (Microsoft documents the CSV wizard for contacts only)
Classic Outlook's Import and Export Wizard (File › Open & Export › Import/Export) has two routes that matter here.
The .ics route, which Microsoft documents for calendars
- Make the .ics with CSV to ICS, as above.
- In classic Outlook, select File › Open & Export › Import/Export.
- Select Import an iCalendar (.ics) or vCalendar file (.vcs), then Next.
- Browse to the .ics file, select it, and select OK, then Open as New.
Open as New puts the events in a calendar of their own, which Microsoft says opens side by side with yours and is added under Other Calendars. That is also your undo: delete that calendar and the import is gone.
The CSV route: documented for contacts, not for calendars
The same wizard reads a CSV: Microsoft's steps are Import from another program or file › Next › Comma Separated Values › Next, choose the file and how to handle duplicates, then Select a destination folder. Microsoft writes those steps for contacts, where the folder is Contacts. Its overview "Import and export Outlook email, contacts, and calendar" lists CSV imports for contacts only, and calendars through a PST file. We found no Microsoft page that gives steps for a calendar CSV, and we haven't tried one, so this page gives none. The .ics route above is the one Microsoft documents.
Outlook for Mac
Microsoft's page "Import iCal items into Outlook for Mac" (Outlook for Microsoft 365 for Mac, Outlook 2024 and 2021 for Mac): open Calendar at the bottom of the navigation pane, drag the .ics file from the Finder onto the calendar grid or list, and click Import. With several accounts in Outlook, select the right calendar. Microsoft's Mac pages name .ics (iCal), .pst and .olm imports; it has no calendar CSV import, so make the .ics with CSV to ICS first. Calendar on the Mac imports the same file (File › Import): see opening an .ics file on a Mac.
Semicolons, dates and accents in the CSV
Three things in a CSV from Excel go wrong more than any other. CSV to ICS handles each before Outlook sees the file:
- Semicolons. Excel saves a CSV with semicolons where the comma is the decimal mark, as in Germany, France, Italy or Spain. The converter picks the separator itself (commas, semicolons, or the tabs of cells copied from Excel), and a value in quotes may hold a comma.
- Date order. 03/04/2026 is 3 April in most of Europe and March 4 in the US. The converter sets Date order from your rows when they leave no doubt, and asks you when every date could be read both ways.
- Accents. Microsoft's advice for its own CSV imports: "For best results, make sure that the CSV file has UTF-8 encoding." The converter reads a CSV that isn't UTF-8 as Excel's Windows encoding, and writes the .ics as UTF-8, as the iCalendar standard expects.
Headers can be in English, German, Spanish, French, Italian or Japanese (Subject or Title, Date, Start, End, Location, Description). A weekly class or shift needs one row with a column named Repeat weekly until; weekly is the only repeat the converter writes. A night shift that ends before it starts (22:00 to 6:00) ends the next day.
Check the first events, then undo if needed
An import adds every event at once, so give it a calendar of its own:
- Outlook.com and Outlook on the web: Calendar › Add calendar › Create blank calendar, name it and select Save, then choose it in Upload from file. To remove it, Microsoft says to select More options next to the calendar, then Remove.
- Classic Outlook: Open as New already makes a separate calendar under Other Calendars.
Then open the first and the last event in Outlook and compare their days and times with the sheet. The converter writes the time zone you pick in Time zone (it starts at your device's), or Floating (each calendar’s own zone), and the line above its preview says which. If the schedule came from an AI chat, check the dates and the year too: an AI can get a date or a time zone wrong.
The rows you paste are read in the browser tab and never uploaded; close the tab and they're gone. We tested CSV to ICS with our own sample rows and opened the .ics it wrote in the ICS viewer, in Chromium and WebKit. We had no Outlook to import into: the Outlook steps are Microsoft's own. The same schedule into Google: importing an Excel schedule into Google Calendar.
Questions
Can you import a CSV file into Outlook Calendar?
Not in new Outlook or Outlook on the web: Microsoft's Upload from file takes an .ics file. Turn the CSV into an .ics with the free CSV to ICS converter, then Calendar › Add calendar › Upload from file. Classic Outlook's Import and Export Wizard reads CSV files, but Microsoft's pages we found document it for contacts, not for a calendar.
How do I import an Excel schedule into Outlook Calendar?
Copy the rows with their header row, paste them into CSV to ICS, check the preview and press Download .ics. In Outlook on the web or Outlook.com: Calendar › Add calendar › Upload from file › Browse › choose the file and the calendar › Import. In classic Outlook: File › Open & Export › Import/Export › Import an iCalendar (.ics) or vCalendar file (.vcs).
Why is my CSV not importing into Outlook?
Most often the version: new Outlook and Outlook on the web don't take a calendar CSV at all, and new Outlook imports an .ics only into Microsoft 365 Exchange accounts. In a CSV, semicolons (from a German, French, Italian or Spanish Excel), a day-first date order or a file that isn't UTF-8 can also go wrong. CSV to ICS reads all three and writes one .ics file; import it with the steps for your Outlook above.
Sources
- Microsoft: Import or subscribe to a calendar in Outlook.com or Outlook on the web: Add calendar › Upload from file, an .ics file. Read on 9 November 2026.
- Microsoft: Share an Outlook calendar (new Outlook for Windows): "Importing events from an .ics file is only supported for Microsoft 365 Exchange accounts.". Read on 9 November 2026.
- Microsoft: Import and export Outlook email, contacts, and calendar: CSV listed for contacts; calendar through PST. Read on 9 November 2026.
- Microsoft: Import or export contacts in Outlook using a .csv file: the Import and Export Wizard's CSV steps, for contacts; UTF-8. Read on 9 November 2026.
- Microsoft: View your Google Calendar in Outlook: classic Outlook: Import an iCalendar (.ics) or vCalendar file (.vcs), Open as New. Read on 9 November 2026.
- Microsoft: Import iCal items into Outlook for Mac. Read on 9 November 2026.
- Microsoft: Add a calendar in Outlook.com or Outlook on the web: Add calendar › Create blank calendar; More options › Remove. Read on 9 November 2026.
- RFC 5545 (iCalendar). Read on 9 November 2026.