Convert class schedules into Google Calendar

To convert class schedules into Google Calendar, follow these steps:

Step 1: Prepare Your Class Schedule

First, make sure you have the following details for each class:

• Class Name

• Location

• Start and End Time

• Days of the Week

• Start and End Dates for the Semester

Step 2: Use Google Calendar Interface (Manual Method)

1. Go to Google Calendar.

2. Click Create > Event.

3. Fill in:

   • Title: Class name

   • Location

   • Time

   • Select “Does not repeat” and change to Custom for recurring days (e.g., Mon/Wed/Fri)

   • Set the start and end dates

4. Click Save

5. Repeat for each class.

Step 3: Use CSV File (Bulk Import Method)

1. Create a CSV File using Excel or Google Sheets. Use the following column headers:

   sql
   CopyEdit
   Subject, Start Date, Start Time, End Date, End Time, Description, Location, All Day Event
   

2. Fill in your class schedule.

   • Dates in MM/DD/YYYY

   • Times in HH:MM AM/PM

3. Save the file as .csv

Example Row:

swift
CopyEdit
Math 101,08/26/2025,09:00 AM,08/26/2025,10:15 AM,Prof. Smith,Room 204,False

4. Go to Google Calendar:

   • Click the gear icon > Settings

   • Click Import & Export

   • Choose Import, select your CSV, and import it to the correct calendar.

Step 4: Use Google Sheets + Google Apps Script (Optional Automation)

If you’re familiar with coding:

1. Input your schedule in Google Sheets.

2. Use this script in Extensions > Apps Script:

javascript
CopyEdit
function addClassEvents() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var calendar = CalendarApp.getDefaultCalendar();
  var data = sheet.getDataRange().getValues();
  
  for (var i = 1; i < data.length; i++) {
    var title = data[i][0];
    var startDate = new Date(data[i][1]);
    var startTime = data[i][2];
    var endTime = data[i][3];
    var location = data[i][4];
    
    var start = new Date(startDate.toDateString() + " " + startTime);
    var end = new Date(startDate.toDateString() + " " + endTime);
    
    calendar.createEvent(title, start, end, {location: location});
  }
}

Adjust column references if your spreadsheet format differs.

Let me know if you’d like a ready-to-edit template (CSV or Google Sheet format) tailored to your specific schedule.