How to Track Grant Applications in Excel
Most small nonprofits track grants the same way: a funder name and a deadline in someone's head, plus the application file in someone's email. That works until the deadline moves, the contact changes, or the person leaves. A simple spreadsheet with the right columns prevents all of it. Here are the columns that actually matter.
The columns you need
- Funder — the foundation, government program, or corporate donor.
- Program / stream — many funders run several programs with different rules. Record which one you are applying to.
- Deadline — the hard cutoff, not the "we should start" date. Add a separate "internal draft due" column if you want one.
- Amount requested — what you asked for, so you can compare it later with what was awarded.
- Stage — researching, drafting, submitted, under review, awarded, declined. One word per row, kept current. This column is the whole point of the tracker.
- Decision date — when you expect to hear back. Without it, submitted applications quietly go stale.
- Reporting deadline — awarded grants come with reports. Log the reporting dates at the same time you log the application, while you still have the guidelines open.
- Owner — the one staff member or volunteer responsible for this application. Every row needs a name, or nobody is responsible.
- Document links — where the application, budget, and guidelines actually live (a shared-drive link, not "on Sarah's laptop").
Example table
One row shows the pattern. Every application your organization touches gets a row like this:
| Funder | Program | Deadline | Amount requested | Stage | Decision date | Reporting deadline | Owner | Documents |
|---|---|---|---|---|---|---|---|---|
| Ontario Trillium Foundation | Seed Grant | 2026-11-04 | $75,000 | Drafting | 2027-03-15 | 2027-09-30 | M. Dubois | drive/…/otf-seed |
Want the finished spreadsheet? Get the Grant Application Tracker →
Common mistakes
- Only tracking deadlines. A deadline list tells you when to panic. A stage column tells you where every application stands — the thing your board actually asks about.
- No owner on a row. "The team" owns nothing. One name per row.
- Forgetting reporting deadlines. Winning a grant and then missing its first report is the fastest way to lose a funder. Log reporting dates when you apply, not when you win.
- Documents scattered across inboxes. If the application, budget, and guidelines are not linked from the tracker row, they effectively do not exist when the funder calls with a question.
- Never recording declined applications. A declined row is not failure — it is next year's starting point, with the funder's feedback attached.
Related guides
- Grant Tracking Spreadsheet (free deadline tracker) — a tiny tool to keep funder deadlines sorted by urgency.
- Nonprofit Administration Checklist — where grant deadlines fit in your yearly admin cycle.