Lei Yu

I am responsible for updating my church’s fellowship schedules on the church website. We were using google sheet to share the schedules. But I recently added embedded google calendars to the page to replace the google sheets, I believe that it is a much more elegant solution. But with this change I need a faster way to create events to google calendar. And I have found a way to allow me to create google calendars in bulk. The steps are written below. You can see the web page showing the fellowship schedules here.

Method

Add your calendar event in this Google Sheet Template. You probably need to make your own copy to be able to edit it. To do that, click File → Make a Copy. Below is an example is an event of how you would want to fill in the columns.

After adding your calendar events, export as .csv file (File → Download → Comma Separated Values).

Go to Google Calendar. Click on the gear icon on the top right. Go to Settings. Then on the right click on Import & export. Or simply use this link if you are logged in to the right account.

Then, under Import select the CSV file that you exported. And select the calendar that you want to bulk add the event to. Finally, press the Import button.

And your calendar events should be created on to the calendar that you selected.

If there is any errors that came up when you’re importing the CSV file. Check out the doc. Make sure that your headings are set correctly and the required fields are set.

Format of the CSV File

If you want more details on how Google Calendar parses the csv file, read the doc.