How to import a CSV file to Google Calendar

excel csv

One of the easiest medium for importing and exporting is a CSV file. These files have each attribute value separated by comma and hence called Comma Separated Value File. Calendar, tasks and contacts applications commonly use these files. However, a small syntax mismatch can cause the error during importing and exporting.

Google is very strict with the CSV format, especially the header. For successful import of the file, you must have at least two header labels:

Subject & Start Date – Minimum amount of header information.

With the above limited information, Calendar will mark all day long event for the start date on the said subject.

Now to create a CSV file, open MS Excel or Google Spreadsheet and make Subject and Start Date as two column headers. More information can be added for convenience under the headers Start time, End date, End time, All day event, Description, Location and Private. Use this shown file as a sample.

excel csv

Some important points to note –

#. Time should be entered in the 12 hour xx:yy AM/PM format.

#. Date should be entered in mm/dd/yyyy format.

#. All day event and Private can be blank, true or false. If you leave it blank, Google will assume the default values for the event.

For Example: Dinner, 05/31/2011, 6:00 PM, 05/31/2011, 10:00 PM, False, Don’t forget gift, La Tamaz, True

import calendarOnce all the entries are done in subsequent rows under following headers, click file –> Save as and select file format as CSV. You file is now read to import to Google Calendar.

Did you find this article useful -

Filed under Google Calendar. Posted by Abhishek on 13th September 2011.

Leave a Comment:

Your email address will not be published. Required fields are marked *


Get Google Updates

Every Sunday, we send out "Google This Week" newsletter which covers all the latest and important updates from Google. First, we curate information from authentic and verified sources and then write the newsletter in an easy to understand format with images and summary for each update. View Sample ›

Join 9000+ subscribers following their favorite company in a simpler and easier way. Join Now ›