How to Import ICS and CSV Events into Google Calendar

Transferring schedules, project timelines, and event rosters between different digital platforms is a routine necessity for productivity and event management. Whether you are moving meetings away from Microsoft Outlook or Apple Calendar, uploading an annual corporate conference itinerary exported from a registration database, or bulk-scheduling appointments from a spreadsheet, Google Calendar makes the transition simple through its native import engine.

Google Calendar natively supports both iCalendar (.ics) files—the universal standard for calendar data across macOS, iOS, Windows, and Linux—and Comma-Separated Values (.csv) files commonly generated in Microsoft Excel or Google Sheets. In this guide, you will learn how to import calendar events using both file types, understand the exact CSV column headers Google Calendar requires, assign imported entries to dedicated secondary calendars, and troubleshoot formatting discrepancies.

Understanding Supported File Formats

Google Calendar accepts two primary file formats during the import process:

  • iCalendar format (.ics): The industry-standard open format used by Apple Calendar, Microsoft Outlook, Yahoo Calendar, and most scheduling tools. ICS files retain rich event metadata, including recurrence rules, alarms, meeting descriptions, participant emails, and venue coordinates.
  • Comma-Separated Values format (.csv): Plain-text tabular files ideal for bulk uploads generated from spreadsheet programmes. To prevent import errors, Google Calendar requires strict formatting for event attributes such as dates, start times, and subject lines.

Note: Google Calendar enforces an import limit of 1 Megabyte (MB) per individual upload file. If your archive exceeds 1 MB, split the data into smaller chunks before importing.

Formatting a CSV File for Google Calendar Import

If you are assembling an event list in Microsoft Excel or Google Sheets, your table header row must follow Google Calendar’s exact specification. Any deviation in column nomenclature will cause the import parser to reject the file.

Create a spreadsheet containing the following mandatory and optional column headers in row 1:

  • Subject (Required): The title of the event (for example: Quarterly Financial Review).
  • Start Date (Required): The date the event commences, formatted as MM/DD/YYYY or DD/MM/YYYY depending on your account language locale (for example: 15/11/2026).
  • Start Time: The commencement time (for example: 09:30 AM or 14:00). Leave blank for all-day events.
  • End Date: The conclusion date of the event. If left blank, Google Calendar assumes the event finishes on the Start Date.
  • End Time: The concluding time (for example: 10:30 AM or 15:00). Leave blank for all-day events.
  • All Day Event: Enter True if the event lasts all day, or False for timed appointments.
  • Description: Additional notes, agendas, or web links associated with the event.
  • Location: The physical venue, room number, or digital meeting URL.
  • Private: Enter True to mark the event as private, or False to follow your default calendar privacy settings.

Once your rows are populated, export the sheet by selecting File > Download > Comma-separated values (.csv) in Google Sheets, or File > Save As > CSV (Comma delimited) (*.csv) in Excel.

Best Practice: Creating a Dedicated Calendar Before Importing

When importing dozens or hundreds of events, always consider creating a new, dedicated secondary calendar first rather than importing directly into your primary personal calendar. If your imported file contains errors or duplicates, deleting an entire secondary calendar takes one click, whereas removing hundreds of imported events from your primary calendar requires tedious manual deletion.

  1. Open Google Calendar in your desktop web browser.
  2. In the left sidebar, scroll down to Other calendars and click the + (Add other calendars) icon.
  3. Select Create new calendar.
  4. Enter a descriptive name (such as Imported Conference Schedule) and click Create calendar.

Step-by-Step: Importing Your ICS or CSV File

Follow these instructions to complete the file upload via Google Calendar on the web:

  1. On the Google Calendar main screen, click the Settings gear icon located in the top-right toolbar, then select Settings.
  2. In the left-hand navigation menu, click Import & export.
  3. Under the Import section, click Select file from your computer.
  4. Browse to your downloaded .ics or .csv file, select it, and click Open.
  5. Click the Add to calendar dropdown menu and choose the specific calendar destination (either your primary account calendar or the secondary calendar created earlier).
  6. Click the blue Import button.

Google Calendar will process the file and display a confirmation prompt detailing how many events were successfully processed (for example: “Imported 24 out of 24 events”).

Troubleshooting Common Calendar Import Errors

If Google Calendar reports an error or fails to display your imported entries, examine these common failure points:

  • “Could not parse file”: This error typically arises in CSV files with mismatched quotation marks, trailing commas, or incorrect column headers. Verify that your column titles match Google’s casing exactly (e.g., Start Date, not StartDate or Date).
  • Date and Time Formatting Mismatches: Ensure that the date format in your CSV corresponds to your Google Calendar regional settings. If your account uses UK English, input dates as DD/MM/YYYY. If using US English, format them as MM/DD/YYYY.
  • Events Appearing on Wrong Days (Timezone Shift): ICS files typically specify UTC timestamps (denoted with a trailing Z). If your Google Calendar primary timezone differs from the creator’s timezone, appointments may shift forward or backward by several hours. Adjust your timezone under Settings > Time zone.
  • Import File Size Limit Exceeded: Google Calendar rejects files larger than 1 MB. Open large CSV files in your spreadsheet editor, split the rows into multiple smaller files, and import each part sequentially.

Frequently Asked Questions

Can I import calendar files using the Google Calendar mobile app?

No. The Google Calendar mobile app for Android and iOS does not include an import interface. However, once you import your ICS or CSV file via Google Calendar on a desktop browser, all imported events automatically synchronise to your mobile app across all connected devices.

Can I undo an import if something goes wrong?

Google Calendar does not feature a single “Undo Import” button. However, if you imported the entries into a secondary calendar as recommended, you can simply delete or hide that secondary calendar in seconds. If imported into your primary calendar, you will need to delete unwanted entries individually or use Google Calendar search to locate and remove them.

Do imported events automatically notify invited attendees?

No. When you import events containing guest email addresses via ICS or CSV, Google Calendar imports the attendee list without sending automatic email invitations, preventing unexpected inbox flooding.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.