Generate CSVs from calendar events

To generate CSVs from calendar events, you’ll need to extract details like event title, date, time, location, and description from your calendar and save them in a .csv file format. Here’s a step-by-step overview of how to do this for common platforms, along with a sample CSV format:

✅ 1. Google Calendar

Method A: Manual Export

1. Go to Google Calendar.

2. Click the gear icon → Settings.

3. In the left sidebar, click Import & export.

4. Under “Export,” click Export. This downloads a .zip file containing .ics files.

5. Convert the .ics file to .csv using:

   • Online tools (search for “ICS to CSV converter”)

   • Python script (see below)

Method B: Python Script (Google Calendar API)

You can programmatically pull events using the Google Calendar API and convert them to CSV.

python
CopyEdit
from google.oauth2 import service_account
from googleapiclient.discovery import build
import csv
from datetime import datetime

SCOPES = ['https://www.googleapis.com/auth/calendar.readonly']
SERVICE_ACCOUNT_FILE = 'credentials.json'  # from Google Cloud Console

credentials = service_account.Credentials.from_service_account_file(
    SERVICE_ACCOUNT_FILE, scopes=SCOPES)
service = build('calendar', 'v3', credentials=credentials)

calendar_id = 'primary'
events_result = service.events().list(calendarId=calendar_id, timeMin='2025-01-01T00:00:00Z',
                                      timeMax='2025-12-31T23:59:59Z', singleEvents=True,
                                      orderBy='startTime').execute()
events = events_result.get('items', [])

with open('calendar_events.csv', 'w', newline='', encoding='utf-8') as file:
    writer = csv.writer(file)
    writer.writerow(['Summary', 'Start Date', 'Start Time', 'End Date', 'End Time', 'Location', 'Description'])

    for event in events:
        start = event['start'].get('dateTime', event['start'].get('date'))
        end = event['end'].get('dateTime', event['end'].get('date'))
        start_dt = datetime.fromisoformat(start)
        end_dt = datetime.fromisoformat(end)

        writer.writerow([
            event.get('summary', ''),
            start_dt.date(),
            start_dt.time(),
            end_dt.date(),
            end_dt.time(),
            event.get('location', ''),
            event.get('description', '')
        ])

✅ 2. Outlook Calendar

Manual Export

1. Go to Outlook calendar → File → Open & Export → Import/Export.

2. Choose Export to a file → Select CSV format.

3. Choose the Calendar folder and export.

Programmatic (Microsoft Graph API)

For automation, use Microsoft Graph API to pull event data and save to CSV.

✅ 3. Apple Calendar (macOS)

1. Open Apple Calendar.

2. File → Export → Export → Save .ics file.

3. Use a converter tool or script to convert .ics to .csv.

✅ Sample CSV Format

pgsql
CopyEdit
Summary,Start Date,Start Time,End Date,End Time,Location,Description
Team Meeting,2025-06-01,10:00,2025-06-01,11:00,Zoom,Weekly sync-up
Project Deadline,2025-06-05,00:00,2025-06-05,23:59,,Final project submission
Conference,2025-06-10,09:00,2025-06-10,17:00,Convention Center,Annual Tech Conference

Let me know if you want a tool-free or mobile method, or a script to handle .ics files directly.