Wednesday, 18 December 2013

Adding multiple events to Google Calendar using a spreadsheet

Adding individual events to a Google Calendar can be annoying and time consuming. But there's a super easy way!

Using a simple spreadsheet in the form of a CSV file you can upload as many events at one time into any of the calendars that you manage. 

There is one big warning! Be careful when you set it up as there are only two ways to delete the events you put in, either delete the whole calendar or delete the events one at a time. In that regard I'd advise adding a new calendar to house all of your new events, or at least test the file in a temporary "Test Calendar".

Click here to download a copy of the CSV file

These are the basic instructions, there is also a step by step YouTube instruction video below.
  1. create a spreadsheet with the correct headers (as per example)
  2. export as a .csv file
  3. Go into calendar and click on the arrow next to My Calendars and click on Settings
  4. at the end of the list of your own calendars, click on 'Import Calendar'
  5. Choose the .csv file you created and choose the calendar it goes into and 'Import'

There is a second video at the bottom of this post that shows you how to set up the spreadsheet to accommodate multi day timetables (like a 6 day cycle) that don't stick to the days of the week. 

Hopefully this will save you quite a lot of time!