folioV

How to Track Job Applications Without a Spreadsheet Mess

A practical way to track job applications: the few fields worth recording, a simple status flow, and a weekly review that keeps you on top of it.

By folioV Labs · · 5 min read

Reviewed by Deepak, founder of folioV
Share

You send an application on Monday. By Friday you have sent six more, and you cannot remember which version of your CV went where, whether you were told to expect a reply, or who that recruiter was who emailed you yesterday. This is how good opportunities quietly die: not through rejection, but through being forgotten.

The fix is not a cleverer spreadsheet. It is recording less, in a consistent way, and looking at it once a week. Here is how to track job applications so the system survives the busy weeks.

Why most trackers fall apart

People usually start with an ambitious spreadsheet: twenty columns, colour coding, a tab for each month. Within a fortnight they stop updating it, because every new application means a chunk of admin.

A tracker only works if adding an entry takes under a minute. If it takes longer, you will skip it on exactly the days you need it most, when you are applying in bulk or juggling interviews. So the goal is the smallest set of information that lets you act, not a complete archive.

The fields actually worth recording

You need about eight pieces of information per application. Anything beyond that is usually decoration.

  • Company and role title. Copy the title exactly as advertised. You will want it when a recruiter rings and asks which position you applied for.
  • Link to the advert. Adverts get taken down. Save the text itself, or a PDF, as well as the link, so you can revisit what they asked for before an interview.
  • Date applied. This anchors everything else, including when to follow up.
  • Where you found it. A job board, a referral, the company site. Over time this tells you which sources are worth your hours.
  • Which CV and cover letter you sent. If you tailor your applications, note the version. Nothing is worse than being invited to interview and not knowing which claims you made.
  • Contact. A name and email if you have one, even if it is only the recruiter who posted the role.
  • Status. Covered in the next section.
  • Next action and date. This is the most useful field of all. Not what happened, but what you will do next and when.

Notes can live in a free-text column or a separate document. Salary range, interview questions, impressions of the team: keep them, but do not let them clutter the main view.

A status flow of five stages is plenty

Most trackers die from too many statuses. You do not need "awaiting feedback from hiring manager, second round" as a category. Five will do:

  1. Saved. Interested, not yet applied. This stops you leaving twenty browser tabs open.
  2. Applied. Submitted, waiting.
  3. Interviewing. Any live conversation, from a phone screen to a final round. Put the round in your notes rather than creating a new status for each.
  4. Offer. Something is on the table.
  5. Closed. Rejected, withdrawn, expired or no reply after your follow-ups. Add a short reason so you can spot patterns later.

The discipline here is moving things to Closed rather than letting them hang. A role you applied to six weeks ago with no word is, in practice, dead. Marking it closed is not pessimism, it is housekeeping, and it keeps your Applied column honest about what is genuinely live.

Give every application an expiry date

Here is a habit that changes how a tracker feels: when you log an application, decide how long you will wait before treating it as cold. Ten working days is a sensible default for many roles, though larger employers can be slower and some countries have a slower hiring rhythm, so adjust to what you see locally.

Write that date next to the entry. On that day you do one of two things: send a short, polite follow-up, or close it. Either is fine. What you are avoiding is the vague limbo where you neither chase nor let go.

A follow-up does not need to be clever. Two or three sentences will do: you applied for the role on a given date, you remain interested, and you would be glad to answer any questions. If you have the name of a person, address them directly.

The weekly review: fifteen minutes, same time each week

This is the habit that holds everything together. Pick a slot, say Friday afternoon or Sunday evening, and run through the same short routine:

  • Clear the Saved column. Apply to the ones still worth your time, delete the rest.
  • Check every next-action date. Anything due this week gets done now or scheduled.
  • Chase or close. Anything past its expiry date gets a follow-up or moves to Closed.
  • Update the live ones. For anything in Interviewing, write down what you know: who you met, what they asked, what you promised to send.
  • Look at the sources. Are your responses coming from referrals, direct applications, or boards? Spend next week's effort accordingly.
  • Set a target for the week ahead. A number you can realistically hit, not an aspirational one.

It is worth glancing at the market too, so your targets stay realistic. In folioV's weekly Job Market Pulse, 5,708 roles from 617 companies were tracked this week, and 31.8% of them were remote. You can read the detail in the latest Job Market Pulse. Numbers like these will not decide anything for you, but they remind you that the market is large enough to keep a steady, organised pace rather than panic-applying to everything.

Keep it light enough to survive a bad week

A few small rules protect the system when life gets in the way:

  • Log the application immediately after sending it, before you open the next tab.
  • Never rely on your email inbox as your tracker. Searching for "application received" is not a system.
  • Resist adding columns. If you want a new field, first ask whether you will genuinely act on it.
  • Do not use the tracker to judge yourself. A long Closed column is not failure, it is the normal shape of a search.

If a spreadsheet works for you, use one with the fields above and nothing more. If you would rather not maintain one, a board-style tool does the same job with less upkeep. folioV's Job Tracker puts every application on a board, gives each an expiry date, and nudges you when it is time to follow up, which covers the two things people forget most. Whatever you choose, the principle is the same: few fields, five statuses, one weekly review.

Start small this week

You do not need to rebuild your whole search today. Take the applications you have in motion, give each the eight fields and a status, set an expiry date on each, and book your first fifteen-minute review. By next week you will know what is live, what is stale and what to do next, and that clarity is worth more than any elaborate dashboard.

Share

More in Job search