Flavio's app supportAll guides · Sign in

← All guides

How to use Calendar CSV Importer

Calendar CSV Importer

Import a schedule spreadsheet saved as CSV into a new calendar in Calendar, check every row first, and undo the import with one click.

Bought Calendar CSV Importer? Sign in with the email you bought it with to download the latest version or ask me a question.

On this page

Install

Calendar CSV Importer requires macOS 14 Sonoma or later, on Apple silicon or Intel. Download the ZIP from the order page or your Creem receipt. Unzip it and move the app to Applications.

The app checks for updates once a day. When a new version is ready, click Install and Relaunch. To check anytime, choose Calendar CSV Importer → Check for Updates….

Allow Calendar access

The app needs full access to Calendar to create the new calendar, add the events and check for duplicates. The first time, click Allow Calendar Access… in the sidebar, then Allow Full Access in the dialog macOS shows.

Without access you can still choose a file and preview it. Duplicates are then checked only within the file, and the Import button stays off. You can turn access on later in System Settings → Privacy & Security → Calendars.

Prepare the spreadsheet

Save the sheet as CSV from Excel, Numbers or Google Sheets. The app doesn’t open .xlsx or .numbers files.

Each row is one event. Two columns are required: a title and a start date. These are optional: start time, end date, end time, duration, all day, location and notes. Column names don’t matter, but common names are matched for you, including the Google Calendar (Subject, Start Date, Start Time…) and Outlook CSV layouts. A schedule with Date, Start and End columns, where Start and End hold only times, works too.

Choose the file

Click Choose CSV File… or Choose…, or drop the file on the drop zone. The sidebar shows the file name, the number of rows and the text encoding. A file that isn’t a CSV gets “This doesn’t look like a CSV file. Save the spreadsheet as CSV and try again.”

The New calendar name is filled from the file name: school-term-schedule.csv becomes “School Term Schedule”. Under it, Account says where the calendar is created (like On My Mac) and Duplicates says where to look for duplicates: all calendars, one calendar, or none.

Match the columns

Under Columns, each field has a picker with the spreadsheet’s columns, like D · Event. Fields marked with * (Title and Start date) are required. Set a field to Not used to ignore a column. Hover over a field to see what it takes.

Turn off First row has column names when the first row is already an event.

Columns the app can’t use, like Repeat, Attendees, Reminder or Time zone, are listed in a note above the preview as not imported.

Dates and times

The app remembers the date order, the month names and the default length.

What it reads:

KindExamples
Dates2026-09-01, 01/09/2026, 9/1/26, 01.09.2026, 1 Sep 2026, Tuesday, September 1st, 2026
Times9:00, 09.30, 9am, 9:30 PM, 21h30, 1530, noon
Ranges in one cell9:00-10:30, 9-11am
Durations90 (minutes), 1:30, 1h 30m, 1.5 hours, 45 min
Timestamps2026-09-01T09:00:00Z, 2026-09-01T09:00:00+02:00, converted to the chosen zone

A bare 1.5 as a duration is rejected as ambiguous: write 1.5 hours or 90.

Read the preview

Click Preview. The pills at the top count the rows that are ready, duplicates and can’t be imported, and show the date order and time zone used. Use All rows, Ready, Duplicates and Problems to filter, and Select All Ready or Select None to change the ticks.

Each row has its spreadsheet row number, the title, the date and time as Calendar will have it, the location and a status:

Grey notes explain what the app decided, like “Ends the next day.” or “No end time: it lasts 1 hour, the default length.”

The rules behind the preview:

Fix problem rows in the spreadsheet, save, and click Preview Again.

Calendar CSV Importer previewing club-fixtures-us.csv in America/Chicago: four ready rows including an all-day two-day tournament, Awards night marked Can't import because it ends before it starts, and a repeated U12 vs Riverside FC row marked Duplicate and left unticked

Import

The bottom bar says what will happen, like “Creates 7 events in a new calendar, “School Term Schedule” · In On My Mac.” If the button is off, it says why: no rows ticked, no calendar name, or no Calendar access.

Click Import N Events. The done screen lists the events that were added. Open Calendar opens Calendar, and Import Another File starts over.

Every import makes a new calendar. Events get the title, start, end, location and notes from the file. The app never adds attendees, alerts or repeat rules, so no invitations are sent. If Calendar refuses any event, the new calendar is removed and nothing stays.

Undo an import

Click Undo Import on the done screen. The app removes the events it added and the calendar. If you added other events to that calendar, the calendar stays with them. Events you already deleted by hand are counted in the message.

Older imports are in File → Past Imports… (Shift-Command-I), also linked under the Preview button. Each import shows its calendar, the number of events, the source file and the date, with an Undo button, or an Undone label.

The CSV file is never changed.

Limits

Everything happens on your Mac. The app uses the internet only to check for updates.

Calendar CSV Importer is $20, a one-time purchase.