A job application tracker is a single list with one row per application: company, role, link, date applied, status and the next step with a date. For up to about 30 active applications a spreadsheet does the job; beyond that, a board-style tracker or an AI assistant saves time, as long as you still decide what gets sent. The part that matters most is not the tool but the follow-up date: a row without a next step is a lost application.
This guide gives you the 8 columns worth keeping, a copy-and-paste follow-up routine, the formulas that flag overdue rows, an honest comparison of spreadsheets, job-search CRMs and AI assistants, and the privacy rules that apply when you upload your CV to a tracker.
What should a job application tracker contain?
Eight columns are enough. Every extra column is one more thing you will stop updating in week three, and a tracker you do not update is worse than none.
| Column | What goes in | Why it earns its place |
|---|---|---|
| Company | Name, plus the country if you apply abroad | Spot duplicates and sister companies |
| Role | Exact title from the ad | Interview prep and CV matching |
| Link | URL of the posting (ads get taken down) | Copy the text into a note on the day you apply |
| Date applied | dd.mm.yyyy or ISO date | Drives the follow-up date |
| Status | Applied, Replied, Interview, Offer, Rejected, Closed | Keep to a fixed dropdown, no free text |
| Follow-up date | Date applied + 7 days | The one column that actually saves applications |
| CV version | File name of the CV and letter you sent | You will be asked about it in the interview |
| Notes | Contact person, salary range, source, impressions | Keeps interview prep in one place |
Optional additions that are worth it for some people: source (job board, referral, company site), salary range and work mode. Skip priority stars and colour codes until you have 20+ rows.
How do you set up a tracker in a spreadsheet?
Create the eight columns above, add a dropdown to the status column (Data, then Data validation, then a list of the six statuses) and freeze the header row. Then add two formulas. They work in Google Sheets and Excel (in other interface languages the function names are translated).
- Follow-up date: with the column order above (A Company, B Role, C Link, D Date applied, E Status, F Follow-up date, G CV version, H Notes) enter in F2 =IF(D2="","",D2+7). Every new row gets its reminder date automatically.
- Overdue flag: select the table, add a conditional-formatting rule with the custom formula =AND($E2="Applied",$F2<TODAY()) and a red fill. Any application still on "Applied" past its follow-up date turns red.
- Reply rate: =(COUNTIF(E:E,"Replied")+COUNTIF(E:E,"Interview")+COUNTIF(E:E,"Offer")+COUNTIF(E:E,"Rejected"))/(COUNTA(E:E)-1) shows which share of your applications got any answer at all.
Worked example (assumed numbers, not a benchmark): 40 applications in six weeks, 11 answers (including rejections), 4 interviews. That is a reply rate of 27.5 % and 10 interviews per 100 applications. If the reply rate sits under 10 % after 20+ applications, the problem is usually targeting or the CV, not volume. Check the roles against the ads before you send more.
Job application tracker template: columns, statuses and an example row
You can build the template in five minutes in Google Sheets, Excel or Notion. Type the eight column names in row 1, fix the status list and fill the first row on the day you apply. Here is what a filled-in example looks like (fictional companies, dates in ISO format):
| Company | Role | Link | Date applied | Status | Follow-up date | CV version | Notes |
|---|---|---|---|---|---|---|---|
| Example Logistics GmbH | Project Manager | URL of the ad | 2026-11-03 | Applied | 2026-11-10 | CV_PM_v2_2026-11-03.pdf | Contact: Ms Sample; salary range 60-70k; found via career site |
| Sample Health AG | Data Analyst | URL of the ad | 2026-10-27 | Interview | 2026-11-12 | CV_DA_v1_2026-10-27.pdf | Interview 12 Nov, 10:00, video; prepare SQL example |
| Demo Retail SE | Marketing Manager | URL of the ad | 2026-10-06 | Closed | 2026-10-13 | CV_MM_v1_2026-10-06.pdf | Two follow-ups sent, no answer after day 28 |
Use exactly these six statuses, in this order: Applied, Replied, Interview, Offer, Rejected, Closed. "Closed" is for silence after day 28 or a role you withdrew from; "Rejected" is for a written no. Keeping the two apart lets you see later how many applications simply got no answer.
Google Sheets
- Type the eight headers in row 1, then View, Freeze, 1 row.
- Status column: Data, Data validation, Dropdown with the six statuses. Every new row can reuse it by dragging the cell down.
- Follow-up date: the formula from the section above. Add the red overdue rule under Format, Conditional formatting.
- Sheets saves automatically and opens on your phone, which is the main reason to prefer it over Excel for a tracker you update on the go.
Excel
- Select the headers and press Ctrl+T (Cmd+T on Mac) to turn the range into a table. New rows then copy the dropdown and formulas by themselves.
- Status column: Data, Data Validation, Allow: List with the six statuses separated by commas.
- Overdue flag under Home, Conditional Formatting, New Rule, Use a formula.
- A local file works offline. Keep it in a synced folder, otherwise the phone and laptop versions drift apart.
Notion
- Create a database (table view) with the properties: Company (title), Role (text), Link (URL), Date applied (date), Status (select, six options), Follow-up date (formula), CV version (text), Notes (text).
- Follow-up date as a formula property: dateAdd(prop("Date applied"), 7, "days"). An overdue flag works the same way, for example if(prop("Status") == "Applied" and prop("Follow-up date") < now(), "Overdue", ""). Check the exact syntax in Notion's formula editor, it differs slightly between versions.
- Add a board view grouped by Status and a table view filtered to "Follow-up date is before tomorrow" for your daily check.
- Notion is strong at views and weak at maths: the reply-rate formula from above is easier in a spreadsheet.
When is a spreadsheet enough, and when do you need a tool?
- Spreadsheet is enough if you have up to about 30 open applications, apply to a few roles per week and are happy to open the file once a day. This is a rule of thumb from our own use, not a measured threshold.
- Move to a job-search CRM or board if you juggle 30+ applications, want push reminders on your phone, or track several contacts per application.
- Add an AI career agent if your bottleneck is not the list but finding good roles and writing a tailored CV for each. Atlas Career is free and covers exactly that, and you can paste its results into the same template (see below).
How and when should you follow up?
Follow up once after 7 days and a second time after 14 days, then close the row. Two short messages cost you five minutes each and keep you from sitting on a dead lead for months. Do it by email to the named recruiter if the ad has one, otherwise to the general HR address.
- Day 7: "Hello [name], I applied for [role] on [date] and am still very interested. Is there anything else you need from me?" Two sentences, no pressure.
- Day 14: one line asking whether the role is still open, with the application attached again.
- Day 28 without reply: status to "Closed". It is not a verdict on you.
The last point has a basis. In an internal review reported in January 2025, the hiring platform Greenhouse found that 18 to 22 % of the postings on its platform were "ghost jobs" that employers did not intend to fill, and that nearly 70 % of its customer companies had posted at least one in the second quarter of 2024 (Entrepreneur, 13 Jan 2025). Silence after two follow-ups is often a dead posting, not a bad application. More ready-made follow-up wording is in our 75 prompts for job applications.
Spreadsheet, job-search CRM or AI assistant: which tracker fits you?
Pick by how many applications are open at the same time, not by the number of features. The three layers differ in how much they do for you.
| Tool type | Examples | Does for you | Best for |
|---|---|---|---|
| Spreadsheet or board | Google Sheets, Excel, Notion, Trello | Nothing. Full control, zero automation | Up to ~30 active applications, low budget |
| Job-search CRM | Teal, Huntr, Careerflow | Kanban board, one-click clipping of job ads, reminders, some AI CV help | 30+ parallel applications, several people to follow up |
| AI career agent | Atlas Career | Finds jobs, scores the fit, tailors CV and letter per role; you apply | Fewer, better-targeted applications |
| Auto-apply bots | LazyApply, Loopcv and similar | Sends applications in bulk | Rarely a good idea, see below |
Free tiers and their limits change often, so check the vendor page before you commit to a CRM. If you want a deeper look at the search side, our comparison of the best AI job search tools covers what is really free.
Where does AI help in a tracker, and where does it hurt?
AI helps with the repetitive work and hurts when it decides or sends for you. Used well it summarises long ads into must-haves, extracts keywords for your CV, drafts a first version of CV and letter, and suggests when to follow up. Used badly it produces identical applications for 200 postings, invents experience, or applies to roles you are not qualified for.
| Feature | Upside | Risk |
|---|---|---|
| Autofill | Saves time on repetitive fields | Copies one error into every form |
| Match score | Helps you focus on best-fit roles | Can miss potential; read the reasons, not only the number |
| Tailored CV and letter | Each application fits its ad | Must be checked for invented facts |
| Mass auto-send | Maximum volume with one click | Looks like spam, no record of what was sent where |
The last row is also a tracking problem: if a bot sends for you, your tracker does not know what happened. That is why we recommend AI that prepares and you who sends. See auto-apply: hype vs. reality and the 12 most common AI application mistakes.
Which free option covers search, documents and tracking?
Atlas Career is a free AI career agent with no limits, built by Sprad in Vienna. It searches 1.5M+ active jobs straight from employers' career sites, including 100,000+ in the DACH region, shows every role with a match score from 0 to 100 and the reasons behind it, and tailors a CV (and a cover letter on request) to each ad. Atlas sends nothing itself: you review everything, download the PDF and apply directly to the employer. The status of each application goes into the tracking.
In practice many people combine tools. Keep one master list for everything you send, including roles you found outside Atlas:
- Atlas for the ongoing search (new matches arrive by email; reply "part-time only" and the search adapts), the match score and the tailored documents.
- Your spreadsheet for the follow-up date, the CV version and your own notes. It is also your offline backup.
- A weekly 20-minute routine (see the graphic above) so the list stays true.
Fair limits: Atlas does not replace a Kanban board with team features, and it does not send applications for you. If you want a drag-and-drop pipeline with contacts and interview notes, a job-search CRM is the better fit; if your problem is finding the right roles and writing a proper application for each, Atlas covers that part at no cost. For the difference between an agent and a bot, read what an AI career agent is.
What do recruiters see on their side?
Recruiters see your output, not your tools. Many employers filter and rank applications with software, and the EU AI Act classes AI systems used to filter or evaluate applications as high-risk (Regulation (EU) 2024/1689, Annex III, point 4). That does not mean a robot "auto-rejects" you at random; it means generic, keyword-stuffed and mass-produced applications are easy to rank low and hard to remember. What stands out: you name the role and one concrete detail from the ad, you show the skills that match with an example, and you follow up once, politely, on day 7. For the format side, see our guide to ATS resume checks.
Is it safe to upload your CV to an application tracker?
It is safe if the provider is transparent and you share only what an application needs. Your CV is personal data. Under the GDPR you have the right of access (Art. 15), the right to erasure (Art. 17) and, for data you provided under consent or contract, the right to receive it in a structured, machine-readable format (Art. 20), which is your protection against lock-in.
- Share only what is needed: contact details, education, work history. No ID numbers, no bank details, no confidential project data.
- Check where data is processed and whether the provider trains models on it. Atlas is hosted in the EU, GDPR-compliant, never sells data, does not train third-party AI models on it and lets you delete it at any time.
- Keep one offline copy of every CV and letter you sent, named by date and company.
- Never let AI invent experience. Check every number and title before you send.
- Be calm about AI use: if asked, say you used it as a helper and checked the final version yourself.
Three typical tracker mistakes
- Logging a week later. By then you have forgotten which CV version you sent. Log the same day, in 60 seconds.
- Free-text status. "Waiting", "pending" and "no news" cannot be counted. Use the dropdown.
- Never closing rows. A list of 80 "Applied" rows hides the five that need action. Close after day 28.
Conclusion
Start with the eight columns and the follow-up date. Move to a CRM when the list outgrows a spreadsheet. Use AI to find roles and draft documents, but let a human, you, send every application. If you want the search and documents part for free, try Atlas and keep your own list next to it.
Frequently Asked Questions (FAQ)
What is a job application tracker?
A tool or list that records every application with company, role, date, status and next step. It can be a spreadsheet, a Kanban board or an app. An AI job application tracker adds help with search, match scores or drafting documents.
What should I track for each application?
Company, role, posting link, date applied, status, follow-up date, CV version and notes. Save the text of the ad as well, because postings are often removed.
Is a spreadsheet enough?
Yes, up to roughly 30 active applications. Beyond that, reminders, contact notes and a board view start to pay off.
How soon should I follow up on an application?
After 7 days, then once more after 14 days. If there is still no answer after about four weeks, close the row and move on.
Are there free job application trackers?
Yes: Google Sheets, Excel and Notion are free, many job-search CRMs have a free tier with limits that change, and Atlas Career is free without limits for search, match scores and tailored documents.
Do AI trackers apply to jobs for me?
Some bots do, which we advise against. Atlas prepares the documents but sends nothing; you apply directly to the employer.
Is it safe to put my CV into a tracker?
If the provider is transparent about processing and you share only necessary data, yes. You have rights of access, erasure and portability under the GDPR.
What do I do when employers never answer?
Follow up twice, then close the row. Some postings are never filled; the Greenhouse figure above is 18 to 22 %.
Jürgen Ulbrich
Jürgen Ulbrich has more than a decade of experience in developing and leading high-performing teams and companies. As an expert in employee referral programs as well as feedback and performance processes, Jürgen has helped over 100 organizations optimize their talent acquisition and development strategies.
