A college spreadsheet is a single document where you track every school you’re considering, from basic stats like acceptance rate and cost to personal details like deadline dates and whether you’ve submitted your essays. The best version has columns for school research, finances, application status, and your own fit criteria, all in one place. Here’s how to build one from scratch.
Start With Your Column Categories
Open a new spreadsheet in Google Sheets or Excel and dedicate each row to a single school. Your columns will fall into four broad groups: general info, finances, application tracking, and personal fit. Setting up all four groups from the start saves you from rebuilding the sheet later when you realize you forgot to track something important.
Before filling anything in, create a header row across the top and color-code or group your columns by category. A light blue for general info, green for money, yellow for deadlines, and orange for personal preferences works well. This visual separation makes the sheet scannable when you have 15 or 20 schools listed.
General Info Columns
These are the factual basics you’ll reference constantly. Include columns for:
- School name
- Location (city and state)
- Website URL (link directly to the admissions page so you’re one click away)
- School size (total undergraduate enrollment)
- Acceptance rate
- Average admitted GPA
- Middle 50% test scores (SAT or ACT range for admitted students)
- Student-to-faculty ratio
- Setting (urban, suburban, rural)
You can pull most of this data from each school’s Common Data Set, its admissions website, or the College Scorecard tool run by the U.S. Department of Education. Fill in the stats as you research each school rather than trying to complete every row at once.
Financial Columns
Cost is where spreadsheets earn their keep, because sticker price and what you’ll actually pay are rarely the same number. Set up columns that let you compare the real bottom line across schools:
- Published cost of attendance (tuition, fees, room, board, books)
- Net price calculator result (every college is required to have one on its website; run it and record the estimate)
- Merit scholarship availability (yes/no, plus any automatic awards tied to GPA or test scores)
- Gift aid offered (grants and scholarships that don’t need to be repaid)
- Self-help aid offered (loans and work-study, which do cost you money or time)
- Out-of-pocket cost (cost of attendance minus all gift aid)
- FAFSA/CSS Profile required?
- Financial aid deadline
The distinction between gift aid and self-help aid matters more than the total aid package number. A school offering $30,000 in aid sounds generous until you realize $20,000 of it is loans. Your out-of-pocket cost column, which subtracts only grants and scholarships from the total cost, gives you the honest comparison. You won’t be able to fill in the aid columns until offers arrive in the spring, but building the columns now means you have a ready-made comparison tool the moment letters come in.
Application Tracking Columns
This section turns your spreadsheet into a project manager. For each school, track:
- Application plan (Early Decision, Early Action, Regular Decision, or Rolling)
- Application deadline
- Application platform (Common App, Coalition, school-specific portal)
- Application fee (and whether you’ve requested a fee waiver)
- Main essay status (not started, drafting, submitted)
- Supplemental essays required? (note how many and their word counts)
- Supplemental essay status
- Letters of recommendation (who you’ve asked, whether they’ve submitted)
- Transcript requested?
- Test scores sent?
- Application submitted? (date)
- Portal login created?
- Decision received? (date and outcome)
Use a simple status system for essay and document columns. “Not started,” “in progress,” and “done” work fine. If you want to get slightly more sophisticated, use dropdown menus in Google Sheets (Data > Data Validation) or Excel (Data > Data Validation > List) so you can filter your sheet to see, for example, every school where your supplemental essays are still in progress.
Early Decision deadlines typically fall around November 1, Early Action around November 1 or November 15, and Regular Decision around January 1, though schools vary. Sort your spreadsheet by deadline at least once a month so nothing sneaks up on you.
Personal Fit Columns
This is where your spreadsheet becomes more than a data table. Add columns for the qualitative factors that will shape your day-to-day experience:
- Major/program strength (does the school offer your intended major, and is the department well regarded?)
- Campus visit notes (a short impression from tours or virtual sessions)
- Career services and job placement
- Extracurriculars that matter to you (club sports, research opportunities, Greek life, whatever you care about)
- Weather/climate
- Gut feeling rating (1 to 5)
U.S. News has recommended that students also track academic offerings and the academic profile of admitted students when comparing schools. The “gut feeling” column might sound unscientific, but when you’re staring at a list of eight acceptances in April, that quick emotional snapshot from months earlier can break a tie that the numbers can’t.
Building a Scoring System
Once your spreadsheet has data in it, you can add a simple weighted scoring system to help rank your options. Pick five to seven criteria that matter most to you, like cost, academic fit, location, campus culture, and career outcomes. Assign each criterion a weight from 1 to 5 based on how important it is to you personally. Then score each school from 1 to 5 on each criterion.
In a new set of columns, multiply each school’s score by the weight for that criterion, then sum the results. A school that scores a 4 on cost (weight: 5) and a 3 on location (weight: 2) gets 20 + 6 = 26 for those two factors. The totals won’t make your decision for you, but they highlight which schools consistently rank high across the things you care about and which ones are being carried by a single strong category.
Keeping the Sheet Useful
A spreadsheet only works if you actually update it. Set a weekly reminder, maybe Sunday evening, to open the file and update any columns that changed: essays you finished, scores you sent, new schools you added. Freeze the top row so your headers stay visible as the list grows. Use conditional formatting to make overdue deadlines turn red automatically (in Google Sheets: Format > Conditional Formatting, then set a rule for dates before today).
Keep one tab as your master comparison sheet and add a second tab for login credentials (school portal usernames and the emails you used to create accounts). A third tab can hold your recommendation letter tracker with columns for each recommender’s name, which schools they’re sending letters to, and whether each one has been submitted. Splitting these into separate tabs prevents your main sheet from becoming 30 columns wide and impossible to read on a laptop screen.
If you’re applying to more than 10 schools, add a “tier” column to your master sheet and label each school as a reach, match, or safety based on how your GPA and test scores compare to admitted student averages. Filtering by tier gives you a quick check that your list is balanced. Most counselors suggest having at least two schools in each tier.