import from Excel dates into apple Calendar

Hi there,

Perhaps through Google first?

Advanced: Create or edit .csv or iCal files before you import

Create or edit a .csv file

You can import .csv (comma separated values) files into Google Calendar. If you get an error when you import a .csv file, you might be able to fix the formatting.

Open a .csv file or create one with a spreadsheet editor like Google Sheets.

The first row of your new spreadsheet includes headers like “Subject” and “Start Date.” To import into Google Calendar, the headers must be in English. For the correct headers you need to import into Calendar, go to the list below.

Each row below the header row represents an event. For example:

SubjectStart dateStart timeFinal exam05/30/202010:00 AM

When you're done, save the file as a .csv file. Then, to import the file into Google Calendar, follow the steps in “Import events into Google Calendar.”

Format headers & events in .csv files

Only the first 2 headers in this list are required. The rest are optional.

Important: The headers must be in English as shown in this article. If any event details have commas (like the location example given), you can include them with quotation marks around the text.

• Subject
• (Required) The name of the event
• Example: Final exam
• Start Date
• (Required) The first day of the event
• Example: 05/30/2020
• Start Time
• The time the event begins
• Example: 10:00 AM
• End Date
• The last day of the event
• Example: 05/30/2020
• End Time
• The time the event ends
• Example: 1:00 PM
• All Day Event
• Whether the event is an all-day event. 
  • If it’s an all-day event, enter True. 
• If it isn’t an all-day event, enter False.
  • Example: False
• Description
• Description or notes about the event
• Example: "50 multiple choice questions and two essay questions"
• Location
• The location for the event
• Example: "Columbia, Schermerhorn 614"
• Private
• Whether the event should be marked private.
  • If it’s private, enter True.
• If it isn’t private, enter False.
  • Example: True

These examples would create the following event:

• Event: "Final exam" on May 30, 2020 10:00 AM–1:00 PM 
• Location: "Columbia, Schermerhorn 614" 
• Description: "50 multiple choice questions and two essay questions"
• Private: Private event

Import events to Google Calendar - Computer - Calendar Help