Importing a CSV file to Google Calendar

May 7th, 2012   Stephanie   Noteworthy   No Comments

To import your calendar to Google Calendar, you’ll need a comma separated value (CSV) file. You can create one by creating an Excel file and saving it as “CSV (Comma delimited) (*.csv)”.

According to Google Help, possible headers for the CSV file include: Subject, Start Date, Start Time, End Date, End Time, All Day Event, Description, Location, and Private

Some things to note:
Date and time cells have to be formatted appropriately (6/30/2010 and 12:00:00 AM, respectively)
Private – True/False value

Here’s an example of a CSV file:
Subject, Start Date, Start Time, End Date, End Time, All Day Event,Show time
as,Private,LocationAnniversary,10/8/2012,,,,TRUE,3,FALSE,
Training,10/10/2012,9:00 AM,10/13/2012,5:00 PM,TRUE,2,,5 School Ave
Surprise party,10/12/2012,7:00 PM,10/12/2012,11:00 PM,FALSE,2,TRUE,123 Restaurant
,,,,,,,,

For some reason, for events occurring over a few days, you need to take the ending date and add 1 (in my example, Training starts 10/10 and ends 10/12 so the End Date is 10/13). Otherwise, you’ll get the wrong end date.

Also, note that I’ve used the header ‘Show time as’. For that header, the value 3 is available, 2 is busy. Supposedly, there are more headers possible including Meeting Organizer, Required Attendees, Optional Attendees, Meeting Resources, Billing Information, Categories, Mileage, Priority, and Sensitivity. However, I haven’t been able to figure out how they work.

I’ve also read that reminders don’t work, but as a workaround, you can set up a default reminder enabled on the destination calendar.

Once you have your CSV file, log into your Google Calendar and follow these steps to upload your file to Google:

  • Click the down-arrow next to Other calendars
  • Select ‘Import calendar’
  • Click ‘Choose file’ and find the file that contains your events, then click ‘Open’.
  • Select the Google Calendar where you’d like to import events, then click ‘Import’.

This is what my calendar looked like after I imported my CSV file.

Good luck!

Got anything to say? Go ahead and leave a comment!

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>