CAD Job Application Tracker (Spreadsheet)

CAD Job Application Tracker (Spreadsheet)

I have reviewed hundreds of job searches, and the ones that go wrong have one thing in common: nobody knows what is going on. Applications are scattered across email, three job boards and a notebook. A recruiter calls, and the candidate cannot remember which resume they sent. A follow-up that should have happened on day seven happens on day thirty, or not at all.

A tracker fixes that, and it does not need to be fancy. This guide gives you a free Excel tracker with five sheets, explains how to use it and shows how to read your own numbers so that you can fix the part of your search that is actually broken.


The Short Answer

  • Download the tracker: CAD Job Application Tracker (Excel). It has sheets for applications, a summary, interviews, contacts and a 90-day plan.
  • Record every application the day you send it. Employer, role, source, resume version and status are the minimum.
  • Follow up after seven days. The tracker calculates the follow-up date and turns it red when it is due.
  • Read your response rate and interview rate after about 20 applications. Small numbers mislead, and large ones show where the problem is.
  • Fix one thing at a time: targeting, documents, interview preparation or skills.

Download the Tracker

Download the CAD Job Application Tracker (Excel)

About the download: the file is a plain Excel workbook (.xlsx) that also opens in Google Sheets and LibreOffice. Everything stays on your computer. It is free for your own use.

SheetWhat it does
Read meShort instructions
ApplicationsOne row per job, with dropdowns for source, work mode and status, and an automatic follow-up date
SummaryCounts by status, response rate and interview rate, calculated automatically
InterviewsA log of every interview: questions, what went well, what to improve, thank-you sent
ContactsPeople you meet: who they are, when you last spoke, when to contact them again
90-Day PlanA week-by-week checklist with a Done dropdown. See 90-Day Plan to Land a CAD Job

The Columns, and Why Each One Exists

If you prefer to build the tracker yourself, copy these columns.

ColumnWhy it matters
Date appliedDrives the follow-up date
Employer and job titleObvious, but write the exact title from the ad
SourceShows which channel works. See Best Job Sites and Employer Sources for CAD, BIM and GIS Jobs in Canada (Ranked)
City / province and work modeHelps you compare on-site, hybrid and remote roles
Posted payCompare with the official median. See CAD Salary Calculator by Role and Province
Job linkAds disappear. Save the text or a PDF as well
Resume versionShows which version gets replies
Portfolio sentShows whether the portfolio affects replies
StatusThe core of the tracker
Follow-up dueDate applied plus seven days while the status is Applied
Next step and notesWhat you promised, and what they said

The Status Dropdown

StatusMeaning
SavedYou found the job but have not applied
AppliedYou submitted the application
ScreeningA recruiter or manager contacted you for a first call
InterviewYou have an interview scheduled or done
Practical testYou have a drawing, modelling or technical test
OfferYou received an offer
RejectedThe employer said no
WithdrawnYou withdrew
No replyYou followed up and heard nothing after a reasonable time

Move a row through these statuses as the process advances. Do not delete rejected rows: they contain data.


An Example Row

This row is fictional.

Date appliedEmployerTitleSourceWork modeResume versionPortfolioStatusFollow-up due
2026-11-03Example Engineering Ltd.Civil DrafterEmployer siteHybridCivil v2YesApplied2026-11-10

On 2026-11-10, you send a short follow-up message. If you hear nothing after a second try, change the status to No reply and move on.


How to Read Your Numbers

The Summary sheet calculates two rates:

  • Response rate: the share of submitted applications that got a reply, positive or negative (screening, interview, test, offer or rejected).
  • Interview rate: the share of submitted applications that reached an interview, a test or an offer.

These rates are for your own diagnosis. I do not have an official benchmark for what is normal, and rates vary widely by market and season, so compare yourself with your own earlier numbers.

What you see after about 20 submitted applicationsLikely problemWhat to try
Very few replies of any kindTargeting or documentsRe-read the ads, match the keywords, and check your resume. See How to Write a CAD Resume That Passes ATS: Keywords, Format and Examples
Replies, mostly rejections, few interviewsFit or evidenceApply to better-matched roles and strengthen the portfolio. See CAD Portfolio Guide: Structure, Examples, Template and Checklist
Interviews but no offersInterview or test performanceUse the interview guides and the workbook. See CAD Interview Prep Workbook
Offers but not the right onesTargetingTighten your target list and use direct applications. See How to Apply Directly to Engineering and Architecture Firms: A Step-by-Step Guide
Some channels reply, others never doChannelSpend more time on the channels that reply

Habits That Make It Work

  1. Update it daily. Five minutes at the end of the work session.
  2. Save the ad. Copy the text into a note or save a PDF.
  3. Name your resume versions consistently, for example “Civil v2”.
  4. Set a weekly review. Look at the Summary and the follow-ups due.
  5. Log every interview while it is fresh.
  6. Add contacts as you meet them, with the next contact date.
  7. Keep it private. It may contain candid notes.

Common Mistakes

  • Tracking only applications you are proud of. Track all of them.
  • No follow-up. A short, polite message costs nothing.
  • Counting saved jobs as applied. Keep them separate.
  • Reading too much into five applications. Wait for a larger sample.
  • Never closing the loop. Mark rows Rejected or No reply, so that the numbers mean something.

Frequently Asked Questions

Can I use it in Google Sheets? Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. Dropdowns and most formulas carry over, but conditional colouring may differ.

How many applications should I send? It depends on the market and the fit. Quality of fit matters more than volume. See How to Find a CAD Job in a Slow Construction Market: Job Search Playbook.

Is seven days the right follow-up time? It is my default. Adjust it if the ad states a closing date or a timeline.

Does the tracker store my data online? No. It is a file on your computer.

Can employers use it? It is designed for job seekers. Employers can find tools in the employer section of this site.


Sources

  • The tracker, its statuses and its diagnostic table are the author’s own, based on professional experience. No official benchmark for application response rates was used.

A search you can see is a search you can improve.