Import Recurring Events to Google Calendar

0.md

One method of quickly creating a lot of events in google calendar is to import a CSV file. However, there is no support for directly adding "recurring" events (birthdays, anniversaries, etc). Here's the workarond.

Summarized steps

1. create csv file with events (no recurring)
2. import csv into a new, temporary google calendar
3. export temporary google calendar to an ics file
4. edit ics file to change events into recurring
5. import ics file into a new, permanent google calendar.
6. delete temporary google calendar

Detailed steps

1. create csv file with events (no recurring)

The CSV format can be found at https://support.google.com/calendar/answer/37118?hl=en

2. import csv into a new, temporary google calendar

3. export temporary google calendar to an ics file

4. edit ics file to change events into recurring

4a. manually by adding RRULE:FREQ=YEARLY between each set of VEVENT begin/close statements. For example:

BEGIN:VEVENT
DTSTART;VALUE=DATE:20180520
DTEND;VALUE=DATE:20180521
RRULE:FREQ=YEARLY
...
END:VEVENT

or

4b. automatically by running this python

import icalendar
import os

def make_recurring():
    directory = os.path.dirname(__file__)
    with open(os.path.join(directory, 'noRecur.ics'), 'r') as fr:
        data = fr.read()

    cal = icalendar.Calendar.from_ical(data)
    for event in cal.subcomponents:
        if 'RRULE' not in event.keys():
            event.add('rrule', {'freq': ['YEARLY']})

    with open(os.path.join(directory, 'withRecur.ics'), 'wb') as fw:
        fw.write(cal.to_ical())

5. import ics file into a new, permanent google calendar.

6. delete temporary google calendar

csv.png

The code below is ready to use requiring you to add the path of the noRecur.ics file in __file__ (the one exported from the temp calendar)

Code

import icalendar
import os
__file__ = "" # paste full path of the noRecur.ics file here within the double quotes
# the directories can be separated using //
# EXAMPLE - C://Users//apa//OneDrive//Documents//[email protected]//noRecur.ics


def make_recurring():
    directory = os.path.dirname(__file__)
    with open(os.path.join(directory, 'noRecur.ics'), 'r') as fr:
        data = fr.read()

    cal = icalendar.Calendar.from_ical(data)
    for event in cal.subcomponents:
        if 'RRULE' not in event.keys():
            event.add('rrule', {'freq': ['WEEKLY']}) # /!\ Change frequency of recurrence as per requirement here in all caps
# WEEKLY, YEARLY and MONTHLY are valid not so sure about DAILY

    with open(os.path.join(directory, 'withRecur.ics'), 'wb') as fw:
        fw.write(cal.to_ical())


make_recurring()

Running the code

Once the code is saved on your system, say as test.py, open sh or cmd and type -

python test.py

Thanks @Hsad1644 !

I'll eventually try out your suggested version and update the gist accordingly 👍

Thanks @Hsad1644 !

I'll eventually try out your suggested version and update the gist accordingly 👍

Its pretty much the same thing
I just added some comments and that one line to call make_recurring() 😃

Aimed at python amateurs. That's all.

Much thanks for this. I'm trying to incorporate it into a web app which will be useful for preparing a timetable from an .xlsx file for students in my university.

Great work, thanks!

@Hsad1644
Just ran the python code - thank you. it works.

@dzigner i think running
pip install icalendar
will fix this

https://pypi.org/project/icalendar/

@sdolenc
I have updated my comment - thanks

Thank you for the code, it help me a lot!! One question, I've tried different ways but I didn't get it to work with recurring UNTIL. I always get an error stating that I should use datetime, but it does not work.

Thank you

Greetings! I needed to bulk upload a lot of annual events to the Google calendar. Your code worked great. Thanks a lot!

Why waste time with python? Just open the .ics in a text editor and find/replace all

END:VEVENT

with

RRULE:FREQ=YEARLY
END:VEVENT

Done in 2 seconds.

Yeah I lost that script to my cache memory xP (so thanks for your comment since you led me back to it). This is what i do now. alt + D on vscode helps a bunch because I use this for making my semester's weekly schedule.

The script was more like a solution to add to an app that I have planned to make for our uni.