College Supplemental Essay Tracker Spreadsheet

College Supplemental Essay Tracker Spreadsheet

Track supplements by the job each prompt does, not by school. Sort your prompts into types (why us, why major, community, activity, short answer) and a long list collapses into a few core drafts plus one why us answer per college. The template below is free to copy into any spreadsheet.

A school-by-school list hides the overlap. Ten colleges can ask four versions of "why this major" and three versions of "tell us about a community," and a tracker sorted by school shows them as seven separate essays. Sorted by job, they are two drafts to adapt. The one exception is the why us answer, which has to be written fresh for each college. When a draft is ready, you can check it against GradPilot's why-us supplement rubric.

The Common App grid and every college page quoted below were checked on October 30, 2026. Copy each prompt from the college's own page in the week you start it, because prompts and limits change.

Get the real prompt list first

Start with dates, then prompts.

Dates. Common App's 2026-27 first-year requirements grid ("Updated: 09-25-2026") lists each member's ED, EDII, EA, EAII, REA and RD deadlines. Here are eight rows from it:

Even in eight rows, "the January 1 deadline" is really January 1 to January 4. Put each college's own date in your tracker. For a full deadline map, see our college application deadlines for 2026-27.

Prompts. Don't use the grid to decide which colleges ask for essays. The grid has a "Supplements, Writing" column, and its note says it "Indicates if the college requires a writing supplement." In the file we downloaded on October 30, 2026, that column was blank in every row we checked, including Columbia, Duke and Tufts. All three publish required questions on their own pages. So copy prompts from each college's own admissions page, word for word, with the date you copied them. Our list of colleges with no supplemental essays covers the ones that ask nothing extra.

Our view: never fill your tracker from someone else's prompt list. A list compiled last summer may carry last cycle's prompt or a wrong limit, and you will not see the error until you paste the answer into a box that cuts it off.

The countercase: a list from your counselor that links each prompt to the college's page and dates the check is a fine starting point. Open each link and paste from the source anyway.

The tracker columns

Eleven columns. Each one prevents a specific mistake.

To fill the limit column, see the required supplemental words at 27 colleges.

The source column matters most for why us answers. A why us answer is only as good as its facts, and the tracker is where you prove each one is current. Our guide to researching a college for a why us essay covers where to look.

Copy the template

Paste this header line into a plain-text file, save it as tracker.csv, and open it in any spreadsheet program. The columns are in the same order as the table above. Add one row per prompt, so a college with three prompts gets three rows.

School,Plan and deadline,Prompt,Limit,Job,Reuse group,Evidence used,School facts and source,Draft status,Review status,Submitted

The template is blank on purpose. Prompts in a pre-filled tracker go stale, and a stale prompt is worse than an empty cell.

From 25 prompts to four core drafts

Constructed example, written by us, not a real applicant's list. The ten colleges are invented, and so are their prompts and limits. The counts are our arithmetic.

Two rows of that tracker, filled in (constructed):

• Ashby College, row 1. Plan and deadline: RD, Jan 4. Prompt: "What draws you to your intended major?" Limit: 250 words. Job: why major. Reuse group: A. Evidence used: creek-testing project, statistics class. School facts and source: field-methods course, catalog page, checked Nov 9. Draft status: draft.
• Ashby College, row 2. Plan and deadline: RD, Jan 4. Prompt: "Why Ashby?" Limit: 150 words. Job: why us. Reuse group: none. Evidence used: newspaper editing. School facts and source: first-year writing seminar, catalog page, checked Nov 9. Draft status: not started.

The why us row has no reuse group. That is the rule: the material can repeat across colleges, but the paragraph can't. Our guide to reusing a why us essay shows how to adapt the evidence without reusing the text. For which other prompt pairs share enough of the task to reuse, see the supplemental essay reuse matrix.

Colleges say reuse of material is fine. Penn's writing page says: "We understand that you may be writing responses for different schools and you may want to reuse material, but be sure to read through your response to make sure it is relevant to the prompt." Northwestern's 2026-27 supplement says you "should feel free to repurpose essays you've written for other applications" if "they tell the story you'd most like to share." Both put the burden on you to answer their question, which is what the Job column checks.

A schedule from November 2 to January 1

This plan runs from Monday, November 2, 2026, to Friday, January 1, 2027. It works for Regular Decision and Early Decision II deadlines in the first week of January.

Why this order. The longest college-specific essays need the most research and the freshest attention, so they go first. Core drafts come next because each one feeds several answers. Short answers go last because they are fastest to write and easiest to adapt.

If your deadline is November 1 or 2. All eight ED deadlines in the table above fall on Sunday, November 1 or Monday, November 2, 2026. If you are reading this with two days left, skip the tracker. Use our plan to finish college essays in one week, compressed. Then build the tracker for your remaining colleges.

Questions about supplemental essay trackers

Should I use a tracker with the prompts already filled in?

No. Pre-filled prompts are someone else's copy of a page that may have changed. Paste each prompt yourself from the college's page and record the date.

Does the Common App grid tell me which colleges require supplements?

Not reliably. Its "Supplements, Writing" column was blank in every row we checked on October 30, 2026, including colleges that publish required questions. Check each college's own page.

How many reuse groups should I have?

As many as the job types in your list. Our constructed example has four groups plus the why us answers; your count depends on your colleges. The what each supplement type asks guide describes the common types.

Can one why us answer serve several colleges?

No. Each one has to name things only that college offers and answer that college's prompt. Share the evidence bank, not the paragraph. For Virginia Tech, track four answers, not one: the Ut Prosim Profile guide lists them.

Get a free review of your supplemental essay

Get a free Quick Review of your supplemental essay against GradPilot's why-us supplement rubric, one prompt at a time. Paste the college's prompt and its limit with the answer. For your reuse-group drafts, use the why-major supplement rubric or the personal short-answer rubric, or start from the Common App essay review page.

More supplemental essay guides:

• Supplemental essays 2026-2027: what each type asks: the genres your Job column uses.
• How to research a college for a why us essay: how to fill the source column.
• Can you reuse a why us essay?: what carries over and what doesn't.
• All Common App and supplemental essay guides.

Sources

Retrieved October 30, 2026, except where noted.

• Common App, 2026-27 First-year deadlines, fees and requirements ("Updated: 09-25-2026"): deadline columns for the eight rows above; note 6, "Supplements, Writing: Indicates if the college requires a writing supplement."; the blank Writing column in the downloaded file.
• Columbia University, Columbia-Specific Application Questions (2026-2027); Duke University, Apply (2026-27); Tufts University, Short Answer Questions (Class of 2031): each publishes required questions.
• University of Pennsylvania, Writing (2026-27): the line on reusing material.
• Northwestern University, Application Materials (2026-27 writing supplements): "feel free to repurpose essays."