Applying to Many Jobs at Once: Build Your Own Job Tracker

How to build a simple job tracker in a spreadsheet: which columns to include, when to update it, and how to use the data to improve your job search.

Your phone rings from an unknown number. The caller says they are HR from a company you applied to and asks if you are still interested in the role. You say yes, but in your head you cannot remember which role it was, which version of your resume you sent, or what expected salary you gave. If you are applying to more than 5 places at once, this happens easily, and a job tracker is a fix that takes less than 30 minutes to set up.

What is a job tracker?

A job tracker is a table that records every application in one place, from the moment you find a listing to the final answer. Google Sheets, Excel, or Notion all work. The tool does not matter; what matters is recording every movement so you can answer HR immediately, never miss an appointment, and know where and when to follow up.

Columns to include

Basic information

• Company, role, and link to the listing
• Date applied and channel, such as a job board, direct email, or referral
• The resume version you sent, for example Resume_Marketing_v3
• Salary stated in the application (if any)

Follow-up information

• Status: interested, applied, interview booked, awaiting result, offer, rejected, withdrawn
• Contact name and channel
• Next action date and what the action is
• Notes, such as questions asked in the interview or information from HR

The next action date column matters most, because it turns the table into a to-do list rather than just a history.

Save the listing on day one

Many listings are removed once applications close. If you get an interview three weeks later, you may no longer have the JD to review. The simple fix is to copy the full JD into a separate file or tab and link it in the table. When you prepare for the interview, you can use the keywords and responsibilities from the real listing.

An update rhythm you can keep

• Every time you apply: add a new row right away; do not leave it for later
• Every time there is contact: update the status and next action date
• 15 minutes every week: sort by next action date and handle what is due

Example: on Monday you open the table and see that your interview with Company A was 7 days ago and there has been silence. The next action is a short email asking about progress. Company B has an interview on Thursday, so the next action is to open the saved JD and prepare. For how to write the follow-up email, see how to follow up after an interview without being pushy.

A good table does not help you remember more. It means you do not have to remember.

Read your table to improve your search

Once you have 15 to 20 rows, the table starts telling you things. Look at:

• Which channel gets you interviews most often. If referrals work better, spend more time on networking.
• Which resume version gets more replies.
• If you send many applications and nobody calls, the problem is likely your resume or role choice, not your interviewing.
• If you get interviews often but do not pass the first round, spend more time practising interviews.

This is your own data, not a market average, so it supports more accurate decisions than guessing from gut feeling.

What to avoid

• Making the table so detailed that you do not want to open it. 8 to 10 columns is enough to start.
• Deleting rejected rows. Keep them: they are data to learn from, and some companies reopen roles.
• Storing job site passwords in the table. Use a password manager instead.

Start today

1. Create a new spreadsheet with the columns above.
2. Go back through your email and job board history and add every application still open.
3. Set a next action date for every row.
4. Add a 15-minute calendar reminder every Monday to review the table.
5. Name your resume files with versions so you can reference them accurately in the table.

Once your tracking system is ready, the next step is making each application fit the role better. See how to tailor your resume without wasting time, then start filling the table with roles that suit you from job listings on Plants.work.