Get Appointments from Outlook

calendar_to_csv.py

import pandas as pd     # pip install pandas
import win32com.client  # pip install pywin32
import datetime as dt

def get_calendar(begin, end):
    """ Source: https://pythoninoffice.com/get-outlook-calendar-meeting-data-using-python """
    
    outlook = win32com.client.Dispatch('Outlook.Application').GetNamespace('MAPI')
    calendar = outlook.getDefaultFolder(9).Items
    calendar.IncludeRecurrences = True
    calendar.Sort('[Start]')

    restriction = "[Start] >= '" + begin.strftime('%m/%d/%Y') + "' AND [END] <= '" + end.strftime('%m/%d/%Y') + "'"
    calendar = calendar.Restrict(restriction)
    return calendar

if __name__ == "__main__":

    start = dt.datetime(2021, 6, 1)
    end = dt.datetime.today()

    calendar = get_calendar(start, end)
    
    df = pd.DataFrame({
        "subject": [appointment.subject for appointment in calendar],
        "start": [appointment.start for appointment in calendar],
        "end": [appointment.end for appointment in calendar],
    })
    
    df["start"] = df["start"].dt.tz_convert(None)
    df["end"] = df["end"].dt.tz_convert(None)
    
    df.to_csv("calendar.csv")