Import events to Google Calendar
You can transfer your events from a different calendar application or Google Account to Google Calendar.
When you import an event, guests and conference data for that event are not imported.
Step 1: Export events
First, export your events as a file that you can import into Google. Choose one of these options:
Most calendar applications, like Outlook Calendar or Apple Calendar, let you export your events.
- Open the calendar application where your events are currently stored. It's often easier to do this from a computer than a phone or tablet.
- Look for an option to Export.
- If you're given the option to choose from different file formats, choose CSV. If you're using an Apple device, choose vCard.
For more help, look in your calendar application's help center or try using the words
export calendar in your search.
Your file will be saved on your computer where your downloads are usually saved, or the place you chose while saving. Now you can move on to the next section to import your calendar.
- On a computer, sign in to the Google Account that you want to export from. You can only export from a computer, not a phone or tablet.
- Follow the directions for exporting your calendar. You'll need to download an .ics file to your computer.
- Sign in to the Google Account where you want to import.
- To learn how to import, continue to the next step.
After you've exported your events, you can import them into Google Calendar. You can import ICS and CSV files on a computer.
- Open Google Calendar.
- At the top right, click Settings Settings.
- At the left, click Import & Export.
- Click Select file from your computer and select the file you exported. The file should end in "ics" or "csv."
- Choose which calendar to add the imported events to. By default, events will be imported into your primary calendar.
- Click Import.
If you have a .zip file, find it on your computer and open it. You'll find .ics files for each of your calendars. Take the individual files out of the .zip file, and import each .ics file individually.
Repeating events might not show up that way if you import them from a .csv file, but they'll be on your calendar as a series of one-time events.
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 an existing CSV file or create a new one using a spreadsheet editor like Google Sheets.
- The first row of your spreadsheet will include headers like
Start Date. The headers must be in English. See the list below for the correct headers.
- Each row below the header row represents an event. For example:
- When you're done, save the file as a .csv file. You can then import the file into Google Calendar using the directions above.
Format headers and 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 below. If any event details have commas (like the location example given), you can include them by using quotation marks around the text.
The name of the event, required.
The first day of the event, required.
The time the event begins.
The last day of the event.
The time the event ends.
All Day Event
Whether the event is an all-day event. Enter
Trueif it is an all-day event, and
Falseif it isn't.
Description or notes about the event.
50 multiple choice questions and two essay questions
The location for the event.
"Columbia, Schermerhorn 614"
Whether the event should be marked private. Enter
Trueif the event is private, and
Falseif it isn't.
The examples above would create the event "Final exam" on May 30, 2020 from 10:00 AM to 1:00 PM. The location would be "Columbia, Schermerhorn 614," the description would be "50 multiple choice questions and two essay questions," and it would be a private event.
- Open an .ics file or create a new one. You'll need to use a text editing application that can save .ics files.
- Format your file according to the guidelines below. You can export an .ics file from Google Calendar to use as an example.
- When you're done, save the file as a .ics file.
Format iCalendar files
The first line in an iCalendar file must always be the header
BEGIN:VCALENDAR. This must be followed by other header information, including
"PRODID:<[enter ID information here]>". The last line of the file must be the footer
END:VCALENDAR. Between these lines is where all the events in the calendar are entered. Each event must be between
If you need to manually edit an iCalendar file, make sure that each file contains the header and footer. If you're not sure where your header ends, just copy and paste the text until one line above
BEGIN:VEVENT, which is where your header ends and your event data starts.
Here's what an iCalendar file looks like. An iCalendar file can also have more information, but these are the required parts.
PRODID:< [enter ID information here]
(other header information goes here)