Academic Student Planner Spreadsheet
Category: Planners / Student Planners
Know what is due, how your grades stand and what comes next: a 16-tab student planner for Google Sheets and Excel with dashboard, GPA and 20 charts.
Walk into every class knowing exactly what is due, how your grades stand and what comes next. This student planner spreadsheet keeps your assignments, exams, grades and study time in one calm place, so nothing sneaks up on you. Sunday planning becomes a quick look at your dashboard instead of a hunt through apps and sticky notes. Made for high school and college students, it is an all-in-one academic planner for Google Sheets and Excel.
WHAT'S INCLUDED (3 files, instant download)
• Quick Start Guide (PDF, 10 pages) with your 2 Google Sheets links: Blank and Example (click, then Make a copy)
• Academic Student Planner - Blank (Excel .xlsx)
• Academic Student Planner - Example (Excel .xlsx, filled with sample data so you can explore first)
16 CONNECTED TABS
• Start Here: 3-step setup and links to every tab
• Settings: your name, semester dates, up to 10 subjects, grade scale and every dropdown list
• Dashboard: 8 live numbers (due in the next 7 days, overdue, % done, GPA, study hours, next exam, attendance, money left), next-up list, upcoming exams and 4 charts
• Assignments: assignments, exams, quizzes and projects with priority, status, due date, days left, grade % and letter
• Calendar: pick any month; every due date appears on its day, exams marked with a star
• Classes: each class meeting with day, time, room and instructor, plus class hours per week
• Timetable: a color-coded weekly timetable that builds itself from your classes
• Grades: weighted grade per subject, letter, GPA points, targets, credit-weighted GPA, final-exam calculator and GPA history
• Exam Prep: topics for every exam with 3 review rounds and a readiness chart
• Study Log: study sessions with hours by subject, day, week and method
• Habits: monthly habit tracker with a daily completion chart and a per-habit chart
• To-Do: everyday tasks with category, priority and due date
• Budget: money in and out, monthly budget per category (sorted by income or expense) and 3 charts
• Reading: textbooks and readings with page progress
• Attendance: present, late, absent or excused, with your rate per subject
• Contacts: instructors, teaching assistants, advisors and classmates
WHY IT WORKS
• Type once: the dashboard, calendar, timetable, grades and 20 charts update by themselves
• Works in Google Sheets and in Excel 2010 or newer, not only Excel 365
• Calm pastel colors that are easy on the eyes, with clear blue (type here) and green (automatic) headers
• Dropdowns and date cells keep everything tidy
• Blank and Example versions plus a step-by-step guide
PERFECT FOR
• College and university students
• High school students
• Homeschool teens, online and part-time students
• Working students who juggle classes and shifts
• Start of a new semester, weekly planning and exam season
HOW TO USE
1. Download the files from your Etsy purchases page.
2. Google Sheets: open the PDF guide and click Make a copy. Excel: open the .xlsx file and click Enable Editing.
3. Add your semester dates and subjects in Settings, then your classes.
4. Add assignments and exams as they come. Everything else fills in for you.
REQUIREMENTS
• Google Sheets: a free Google account (works on computer, phone and tablet)
• Excel: Excel 2010 or newer on Windows or Mac, or Excel for the web
• A computer is easiest for the first setup
PLEASE NOTE
• This is a digital download. Nothing will be shipped.
• Colors may look slightly different on different screens.
• Designed by Printivora: an exclusive design for our shop, built from our own original ideas and prompts, with the help of AI tools.
• For personal use only. Please do not share, resell or redistribute the files or the Google Sheets links.
• Grades, GPA and budget figures are estimates for planning, not official or financial advice.
• Google Sheets and Microsoft Excel are trademarks of their owners. This planner is not affiliated with Google or Microsoft.
Questions before you buy? Send us a message. We are happy to help.