Track USAJobs Applications: Spreadsheet Template and Tool Guide

Most veterans applying to federal jobs have no idea how many applications are actually open, how many closed without a referral, or how many are sitting in "Reviewed" limbo two months later. You apply, you get an auto-email, you move on. A month later you try to remember if you ever heard back from that GS-11 Logistics Management job at DLA and you can't.

That's the problem a tracking spreadsheet solves. Not a fancy tool. Not an app. A plain spreadsheet with the right columns will beat 90% of the federal job seekers out there because most of them are applying blind. I spent 1.5 years after leaving the Navy applying to federal jobs with zero callbacks. Part of what finally turned it around was the boring work of tracking every single application in a spreadsheet and actually reading the patterns. The patterns told me exactly what to fix.

This guide gives you the exact columns to track, how to map USAJobs status codes to real next actions, and how to use the data to spot which resumes are working and which aren't. You'll walk away with a ready-to-build tracking system you can set up in 20 minutes.

Why Track USAJobs Applications in a Spreadsheet at All?

USAJobs has a built-in application status page. It shows you every application you've submitted, the status, and the closing date. So why build a spreadsheet on top of that?

Because USAJobs shows you the "what" but not the "why." It tells you a job closed without referral. It doesn't tell you that you've now had four Logistics Management (0346) applications close without referral while your Supply (2003) series applications are getting referred 60% of the time. That pattern is the signal. A spreadsheet surfaces the signal. USAJobs buries it.

The other reason is timing. Federal hiring moves slow. A job closes in February, HR takes 4-6 weeks to rate applications, the cert goes to the hiring manager in April, interviews maybe happen in May, selection in June. If you're not writing any of that down, you will miss follow-up windows. You'll also forget which references you listed for which job, which is a real problem when someone actually calls one of them.

A spreadsheet also lets you spot which announcements are worth reapplying to. Some federal jobs post the same announcement quarterly. If you applied in Q1 and got "Referred but Not Selected," the same announcement in Q3 is worth another shot with a tailored resume. Without a tracker, you forget that job even existed.

What Columns Should You Track on a USAJobs Spreadsheet?

Here's the column list I use. It's not minimal and it's not bloated. Every column earns its spot because at some point I needed that data to answer a question about why things were or weren't working.

Build these in Google Sheets or Excel. Google Sheets is easier because you can access it from your phone when you're reviewing an announcement on lunch break.

The 14 Columns That Matter

Columns 3 (Series), 9 (Hiring Authority), 10 (Status), and 12 (Resume Version) are the ones you'll analyze most. Those four are the difference between "I've applied to 40 jobs and nothing is working" and "I've applied to 40 jobs and my Logistics resume is getting referred 3x as often as my Supply resume at the GS-11 level." One of those is a cry for help. The other is a plan.

A hiring official told Joe the resume is why they picked him.

"One of the hiring officials specifically mentioned that they reviewed my resume and selected me based on it."
Joe, O-3, Navy

Read their story

OPM data built in, goes beyond the job announcement Full 2-page federal format for USAJOBS Tailored to every GS position you apply for

Get My Free Resume

2 free tailored resumes, cover letters & LinkedIn optimization

How Do You Read USAJobs Status Codes?

The status field is where most federal applicants get confused. USAJobs uses a handful of standard statuses and each one has a specific meaning about where your application is in the process. If you don't know what each status means, you're just staring at words.

Here's the translation. I've covered the status meanings in more depth in the USAJobs application status guide, but here's what each one means for what you do next in your tracker.

Received

Your application was submitted successfully. That's it. It means nothing about quality. Every resume, good or bad, shows "Received" the moment it's in the system. Track the date, move on. If the announcement is still open, this is the only status you should expect.

Reviewed

HR looked at it. They're comparing it to the qualification requirements and the occupational questionnaire. This can take 2-6 weeks after the announcement closes. "Reviewed" does not mean "approved." It just means they've started looking. You'll either go to "Referred" or "Not Referred" from here.

Referred

HR qualified you and sent your resume to the hiring manager's certificate list. This is the first real checkpoint. You're in the pool of people who could actually get hired. Most federal jobs never get past this step for most applicants. When you see "Referred," it's time to pay attention to your email and phone.

Not Referred

You didn't make the cert. Could be a qualifications gap, could be a resume that didn't show the qualifications you actually have. This is the status that teaches you the most if you track it. Four "Not Referred" in the same series tells you the resume isn't showing what the series needs. The fix might be finding and using the right USAJobs keywords from the announcement.

Selected

You got the job. Mark it, celebrate, move on to onboarding. In your tracker, note what resume version and hiring authority got you there. You'll want to replicate it.

Not Selected

You made the cert, interviewed or were considered, but someone else got it. This one stings but it's not bad news for your system. It means your resume is getting you into the room. If you're seeing "Not Selected" more than "Not Referred," your resume is working. The fix is interview prep, not resume overhaul.

Hiring Complete

The announcement closed and someone was selected. You may or may not have been on the cert. If USAJobs shows "Hiring Complete" without ever showing "Referred" for you, you weren't on the cert.

Should You Use Google Sheets, Excel, or a Purpose-Built Tool?

People ask this a lot. Short answer: Google Sheets. Longer answer depends on what you already use.

Google Sheets wins for most veterans because it's free, it syncs to your phone, and you can share it with a spouse or career coach if you want another set of eyes on it. Excel is fine if you already live in Office 365 and prefer the interface. The specific tool matters far less than actually using it.

Purpose-built tools like Huntr, Teal, and Simplify do exist. They're great for private-sector job tracking where you have job links and company pages. For federal jobs, they're overkill and most of them don't map cleanly to USAJobs status codes. I've covered the free tracking tools veterans actually use if you want a pre-built option instead of building your own spreadsheet.

Whatever you pick, commit to one. Tracking across three apps means you track in none of them. I've seen veterans start spreadsheets in four different places and then tell me they "have a system." They don't. They have chaos with extra steps.

How Do You Set Up the Spreadsheet in 20 Minutes?

Here's the build sequence. Open a blank Google Sheet and do these in order.

That's it. Twenty minutes of setup. After that, every time you apply to a job you fill in one row. Every week, you update the status column. Every month, you look at the summary tab and decide what's working.

How Do You Use the Data to Fix What's Not Working?

This is the part most people skip. They build the tracker, they fill it in, and they never actually use it to change anything. The tracker is useless without the review rhythm.

Do a monthly review. Block 30 minutes on a Sunday. Open the summary tab and ask three questions.

Question 1: What's my referral rate by series? If you've applied to 10 jobs in 0346 and been referred to 3, that's a 30% referral rate. That's healthy. If you've applied to 10 jobs in 2003 and been referred to 0, that's the series where your resume isn't translating. You either need a different resume for that series or you need to stop applying in that series.

Question 2: Am I getting stuck at "Not Referred" or "Not Selected"? These have different fixes. "Not Referred" means your resume isn't showing the qualifications. Fix the resume. The federal resume template mistakes that get veterans ranked lower article covers the most common reasons this happens. "Not Selected" means your resume is working but your interview isn't. Different problem, different fix.

Question 3: Which hiring authority is getting me the most traction? If most of your referrals are coming through VEOA, lean into that. If you're eligible for 30% or More Disabled hiring and you've never used it, start. The hiring authorities for veterans guide walks through each one.

The spreadsheet is a diagnostic tool. You're the doctor. The data gives you the symptoms. You change the treatment based on what the data shows.

When Should You Follow Up on a USAJobs Application?

The tracker tells you when a follow-up makes sense. Most applicants either never follow up or follow up way too early and annoy HR. Neither helps.

Here's the rule I use based on the status and days-since-submission column.

If the announcement is still open or just closed: Don't follow up. HR hasn't started reviewing yet. You'll look desperate and you won't get a useful answer.

If you've been in "Received" for more than 30 days after the closing date: A polite email to the HR contact listed on the announcement is fine. One sentence: "Following up on announcement [number], applied [date], wanted to confirm receipt and check on the review timeline." That's it.

If you've been in "Referred" for more than 30 days: This is where a follow-up actually matters. The cert is with the hiring manager. A note to the hiring manager or HR contact asking about interview timeline is reasonable. Keep it short.

If you've been in "Reviewed" for more than 60 days: Something is probably wrong with the announcement. Sometimes agencies pause or cancel certs. An email to HR asking for status is appropriate. Half the time you'll get no response and that tells you something too.

If you see "Hiring Complete" without ever being referred: Don't follow up. The decision was made. Instead, review your resume against the announcement requirements and figure out what didn't translate. This is where the military job series equivalent research pays off if you've been applying outside your actual qualifying series.

What Are the Common Spreadsheet Mistakes That Make It Useless?

I've looked at a lot of veteran tracking spreadsheets. Most have the same handful of issues that make them useless after a few weeks.

Mistake 1: Not using a status dropdown. If you type "referred" once and "Referred" another time and "REFERRED" a third time, your filters and counts break. The data validation dropdown in setup step 2 prevents this.

Mistake 2: Logging the resume as "my resume" every time. If you have one resume for every job, fine. Most veterans tailor. You need to know which resume version got which result. Without that, you can't replicate what worked.

Mistake 3: Skipping the series column. The series is the most important analytical field in the whole tracker. Skipping it because you "already know" what series each job is in means you lose the ability to count by series later.

Mistake 4: Never updating the status. If you log applications but never come back to update the status, you have a submission log, not a tracker. Block 10 minutes every Sunday night to check USAJobs and update every row that changed.

Mistake 5: Tracking too much detail per row. If each row takes 15 minutes to fill out, you'll stop logging applications. Keep it fast. Announcement number, job title, series, grade, dates, status, resume version. That's 80% of the value. Notes field catches everything else.

How Does This Connect to Your Resume Strategy?

The whole point of tracking is to improve the resume. The tracker shows you which series your current resume works for. If you're getting referrals in one series and nothing in another, you have two options: apply only where the current resume works, or build a second resume for the other series.

Federal resumes are 2 pages max. That's not negotiable under current OPM guidance. So when I say "build a second resume," I mean a different 2-page resume focused on different qualifications, not a longer resume that tries to cover everything. One resume per series you're serious about.

BMR's Federal Resume Builder handles the tailoring automatically. Paste the announcement, get a resume written for that specific series and grade. Built by veterans who've been on both sides of the federal hiring process. The free tier gives you two tailored resumes, which is enough to test whether a second resume in a different series actually moves your referral rate.

If you want more background on the platform overall, the USAJobs 2026 review walks through how the whole USAJobs experience has changed recently and what that means for how you approach applications.

What Should You Do in Your First Week of Tracking?

Most veterans I talk to have already been applying for weeks or months before they start a tracker. That's fine. You don't need to go back and recreate every application. Start from today.

Here's the first-week plan.

Day 1: Build the spreadsheet using the 5 setup steps. Don't add any data yet.

Day 2: Log the last 5-10 applications you can remember clearly. Don't worry about perfect data for old ones. Include the series and the resume version you used.

Day 3-7: Log every new application as you submit it. Update statuses on the old ones by checking USAJobs.

End of week 1: Look at what you have. If you have 10+ rows, you can start seeing patterns. If you have 3 rows, you need more data before analysis matters. Either way, the habit is what counts at this stage.

After four weeks of tracking, you'll have enough data to run the three diagnostic questions from earlier. After eight weeks, you'll have enough to know whether a strategy change actually moved the numbers. The tracker isn't magic. It's just the minimum level of discipline required to tell the difference between bad luck and a broken resume.

What's Next After You Have a Month of Data?

Four weeks of tracking with 15-25 applications logged is when the tracker stops being overhead and starts paying you back. At that point you have real answers.

If your referral rate is above 20% in any series, keep doing what you're doing in that series. Maybe increase the volume. If your referral rate is below 10% across every series, the resume is the problem. Fix the resume before you fix anything else. The USAJobs resume builder walkthrough covers each field and where most veterans miss qualifications they actually have.

If you're getting referrals but no selections, the interview is the problem. Not the resume. Stop rewriting the resume and start preparing for panel interviews.

If you're seeing "Hiring Complete" after 3+ months stuck in "Reviewed," the agency is slow, not your resume. Keep applying, those certs do eventually move.

Tracking USAJobs applications isn't glamorous. Nobody wants to spend Sunday nights updating a spreadsheet. But I spent 1.5 years applying blind and getting nowhere. Twenty minutes of setup and ten minutes a week of maintenance would have saved me most of that time. The spreadsheet is the cheapest tool in the federal job search and it's the one most veterans skip. Don't be one of them.