Guide · Office and email
How to import a CSV or Excel schedule into Apple Calendar on a Mac or iPhone (Calendar takes .ics, not CSV)
By Blink Brief · Updated · How pages are made
Apple Calendar can't read a CSV: Apple's Mac guide imports events from a calendar (.ics) file. So turn the rows into one first. Copy the cells from Excel or Numbers (or choose the CSV file) and paste them into the free CSV to ICS converter, check each event in the preview, and press Download .ics. On a Mac, open Calendar, choose File › Import, select the file, click Import, and pick an iCloud calendar so the events reach your iPhone. With only an iPhone, open the .ics in the ICS viewer and add the events one by one.
Short answer
- 1. CSV to ICS: paste the rows or choose the .csv, check the preview, Download .ics. Nothing is uploaded.
- 2. Mac: Calendar › File › New Calendar (in iCloud), then File › Import › the file › Import › that calendar › OK.
- 3. iPhone: the iCloud calendar syncs to it. No Mac: the ICS viewer's Add buttons, one event each.
- Undo: delete the calendar you imported into, and its events go with it.
Why Calendar won't take a CSV
Apple's "Import or export calendars on Mac" (macOS 27) describes two imports: "the events saved in a calendar (.ics) file", and a calendar archive (.icbu) that replaces all your calendars. Neither is a spreadsheet. The iPhone's guide has no file import with steps at all; its calendar-accounts page says only that you can "import an .ics file from Mail".
A CSV and an .ics hold the same facts in different shapes. A CSV is a table: one row per event, with columns for the title, date and times. An .ics is calendar text (the iCalendar standard, RFC 5545): one block per event, with its start, end and time zone written the way every calendar app reads them. The converter writes the second from the first.
CSV to ICS: rows to one .ics
- Open CSV to ICS. Paste the cells, header row included, into Paste rows from Excel, Google Sheets or an AI chat, or press Choose a .csv file.
- Check What each column holds: the converter guesses from the header words (Subject or Title, Date, Start, End, Location, All Day) and each column has a list to change the guess.
- Check the preview. Each event shows its row number, day, times and place, as Calendar will read it. A row it can't read is named above the list, with the reason.
- If the dates could be read two ways (03/04/2026), set Date order. Check Time zone: it starts at your device's zone.
- Press Download .ics.
A row with a date and no start time becomes an all-day event, and an End Date column makes it last several days. A row with a start and no end lasts an hour, or what you pick under Events with no end time last. For a weekly class or shift, add a column named Repeat weekly until with the last date: weekly is the only repeat it writes. An Excel workbook (.xlsx) can't be read; copy its cells or save it as CSV.
Tested here, in Chromium and WebKit: a comma CSV with English headers, all-day rows, a three-day break with an End Date, a timed evening event, a title with a comma inside quotes and an empty row (seven events, the empty row skipped); a German semicolon CSV (Betreff, Datum, Beginn, Ende, Ort with 16.11.2026 dates); and tab-separated rows as pasted from a spreadsheet, with 9:00 AM and 21:00 times. The first two .ics files, opened in the ICS viewer, listed the same events.
On a Mac: File › Import, into an iCloud calendar
Apple's steps for macOS 27, under "Import events from a calendar file":
- Open the Calendar app.
- If needed, create a new calendar for the events: File › New Calendar, name it, press Return.
- Choose File › Import, select the .ics file, then click Import. Apple says dragging the file into Calendar works too.
- Select the calendar to add the events to, then click OK.
Which calendar reaches the iPhone. Calendar's list groups calendars by account: iCloud, Google, Exchange, and On My Mac for calendars kept only on this Mac. Apple's page says that with an account such as iCloud, "your calendars are all automatically stored on the provider's servers", which "give you access to them across all your devices". So pick a calendar under iCloud (or under a Google account the iPhone also uses), not one under On My Mac. After you name a new calendar, look at which heading it sits under in the list before you import. Apple's guide says to set up the iPhone with the same account, "so that your calendars stay up to date across all those devices".
Apple adds: "Importing a calendar file removes the event's previous custom color." We haven't imported into Calendar for this page, as that would change a Mac's signed-in calendars; the steps are Apple's. After importing, open the first event and check its date and time. More on .ics files on a Mac, including what to do when a double-click opens the wrong app: open an .ics file on a Mac.
Only an iPhone
CSV to ICS works in Safari on the iPhone: paste the rows (or choose a CSV saved in Files) and press Download .ics. Apple gives no steps for importing that file on the phone, so there are three ways on:
- A few events: the ICS viewer. Press Open it in the ICS viewer under the preview, tap Choose an .ics file and pick the download. Each event has Add to Google Calendar and Add to Outlook, one event per button, into an account your iPhone's Calendar already shows. For Google, sign in to Google in Safari first. Google's button keeps a weekly repeat; Outlook's adds the first date only, and the event says so.
- Many events: a computer. Import the .ics into Google Calendar or Outlook in any computer's browser, in an account the iPhone already shows, and the events appear on the iPhone with that account's calendars. Or a Mac, as above.
- From Mail. Apple's page says you can "import an .ics file from Mail" without giving steps: adding an .ics file to iPhone Calendar has what iPhone users report, marked as untested.
When you press Add to Google Calendar or Add to Outlook, that one event's title, times, place and notes go to Google or Microsoft in the link that opens their calendar. The rows you paste into CSV to ICS, and the file you open in the ICS viewer, are read in the browser tab and never uploaded. We haven't tried these routes on an iPhone.
Undo: a separate calendar you can delete
Import into a calendar of its own, made for the file ("Shifts", "Season 2026"). If something is wrong (the year, the time zone, a column read as the wrong thing), delete that calendar and every imported event goes with it, then convert and import again. Apple's steps on a Mac: click the calendar's name in the calendar list, then choose Edit › Delete. Apple notes that some calendars can't be deleted, such as the last calendar of an account.
Imported into your main calendar instead? The events are mixed with your own, and Apple's iPhone guide moves events one at a time (tap the event, tap Calendar, choose another). The separate calendar saves that.
Numbers or Excel: save as CSV first
Copying the cells and pasting them is the shortest way. If you'd rather have a file, or the sheet is long:
- Numbers on a Mac: choose File › Export To › CSV. Apple: "Cell contents are shown as values separated by commas in the exported file", with a choice of one file per table, and the text encoding under Advanced Options.
- Excel: File › Save As, and choose a CSV type, such as CSV (Comma delimited) (*.csv), from Microsoft's page, or CSV UTF-8 for accented names. Excel in Germany, France, Italy or Spain saves with semicolons, which the converter reads too.
Then press Choose a .csv file in CSV to ICS. Give the first row column names, in English or in German, Spanish, French, Italian or Japanese; with no header row, the converter guesses from the cells. Dates are read as numbers with the year (2026-11-16, 11/16/2026, 16/11/2026, 16.11.2026); a date in words, such as Nov 16, isn't. Already in Google Calendar or Outlook rather than Apple's? Import an Excel schedule into Google Calendar has Google's import step by step.
Questions
Can you import a CSV into Apple Calendar?
Not directly. Apple's Calendar guide for the Mac imports events from a calendar (.ics) file, or a calendar archive, and names no CSV import. Turn the CSV into an .ics first: paste the rows or choose the file in the free CSV to ICS converter, check the preview, press Download .ics, then in Calendar on the Mac choose File › Import.
How do I add an Excel schedule to my iPhone calendar?
Copy the cells in Excel with the header row, paste them into CSV to ICS and press Download .ics. With a Mac, import that file into an iCloud calendar (Calendar › File › Import) and it reaches the iPhone through iCloud. With only the iPhone, open the .ics in the free ICS viewer in Safari and add the events one by one with Add to Google Calendar or Add to Outlook, into an account your iPhone's Calendar already shows.
Does it keep repeating events?
Weekly ones. Add a column named Repeat weekly until and give the row the last date: CSV to ICS writes the event once with a weekly repeat rule up to that date. It writes no other repeat; a monthly meeting needs one row per date.
Sources
- Apple: Import or export calendars on Mac (macOS 27): events from a calendar (.ics) file; File › Import; select the calendar, OK. Read on 11 November 2026.
- Apple: Add calendars and calendar accounts on Mac: File › New Calendar. Read on 11 November 2026.
- Apple: Delete or remove calendars on Mac: Edit › Delete. Read on 11 November 2026.
- Apple: Set up multiple calendars on iPhone (iOS 27): Add Calendar; Add Subscription Calendar. Read on 11 November 2026.
- Apple: Set up mail, contacts, and calendar accounts on iPhone (iOS 27): "or import an .ics file from Mail", no steps. Read on 11 November 2026.
- Apple: Export to other file formats in Numbers on Mac: File › Export To › CSV. Read on 11 November 2026.
- Microsoft: Create or edit .csv files: Excel: File › Save As › CSV (Comma delimited). Read on 11 November 2026.
- RFC 5545: iCalendar. Read on 11 November 2026.