Step 1: Access the Template

1. 📋 Open Course Planner Template
2. Click File → Make a copy to create your own editable version

Step 2: Customize Your Course List

Replace the sample data with your own courses

✨ PLEASE NOTE: If you have fulfilled a course elsewhere (eg. CC, AP, IB, etc.), please don't include it in your course list or list it as a prerequisite/corequisite!

For each course, fill in:

1. Course Name & Number (e.g., "CS 101"):
2. Taken:
   • Write Not Assigned if you haven't taken it yet
   • Otherwise, use format like: "Fall, Year 1"
3. Prerequisites (courses that must be taken before this one):
   • List course numbers separated by commas
   • ⚠️: These must exactly match the course names elsewhere in the spreadsheet
4. Corequisites (courses that must be taken together):
   • List course numbers separated by commas
   • ⚠️: These must exactly match the course names elsewhere in the spreadsheet
5. Units: How many units the course is worth
6. Difficulty (optional):
   • 1 = easiest, 8 = hardest
   • If you're unsure, make them all 1

✨ Pro Tip: Put your most important courses at the top — the planner uses this order to prioritize!

Step 3: Export Your Data

1. In your Google Sheet, go to File → Share → Publish to web

2. In the dropdown menu, change from "Entire Document" to "TEMPLATE"

3. In the dropdown menu, change from "Web page" to "Tab-separated values"

4. Click Publish and copy the generated link

Step 4: Connect to Course Planner

1. Paste the copied link into the Load Course Data field

Important: Verify the link ends with output=tsv before submitting