The short answer
A visa application tracker is one row per applicant per application, with the client, route, owner, status, who the file waits on and since when, trip and passport dates, and the next action. Build it in Google Sheets or Excel with dropdowns and date checks. It stops being enough once staff need to check papers, not just status.
Key takeaways
- Use one row per applicant per application, so a family of four applying together is four rows sharing one group ID.
- Dropdowns for status, owner, route and "waiting on" keep the sheet sortable; free text in those columns breaks every filter.
- Two dates do most of the work: when the file started waiting, and the passport expiry set against the return date.
- Google and Microsoft both say sheet protection is not a security feature, so keep full passport numbers and bank details out of a shared tracker.
- A tracker records status; it cannot tell you that the papers in the file disagree with each other.
A visa application tracker is the sheet your team opens every morning to see which files need action today: who is waiting on a client, which appointment is next week, which passport runs out too soon. Most agencies start with one in Google Sheets or Excel, and a well-built one carries a small team a long way.
This playbook gives a column layout you can copy, the dropdowns and date checks that keep it honest, a daily routine, and the signs that a spreadsheet has stopped being enough. If you came here to check the status of an application already submitted, use that country's official tracking page instead; for UK files, our UK visa tracking guide shows where to look.
What should a visa application tracker include?
One row per applicant per application, with enough columns to answer three questions at a glance: what stage the file is at, who it is waiting on and since when, and what happens next. Everything else is detail. A family of four applying together is four rows with a shared group ID, because each person's passport, papers and decision are separate.
Keep it on one tab, freeze the header row, and never merge cells, because merged cells break sorting and filters. Move closed files to an archive tab at the end of each month, so the working list stays short enough to read on a phone.
The column layout
| Column | What goes in it | Format |
|---|---|---|
| A. File ID | Your own number, such as 2026-0142, never reused | Text |
| B. Group ID | Shared by family members or a group applying together | Text |
| C. Client name | As printed on the passport | Text |
| D. Phone or WhatsApp | The number the client actually answers | Text, with country code |
| E. Passport (last 4) | Last four characters only; the full number stays in the client's file | Text |
| F. Nationality | The passport's country | Dropdown |
| G. Country of residence | Where the client lives and applies, which matters for expatriates | Dropdown |
| H. Route | Destination and visa type, such as UK visitor or Schengen France short stay | Dropdown |
| I. Owner | The caseworker responsible | Dropdown of staff |
| J. Status | One of your stages | Dropdown |
| K. Waiting on | Client, us, visa centre or embassy | Dropdown |
| L. Waiting since | Date the status or waiting-on last changed | Date |
| M. Days waiting | Calculated from L | Formula |
| N. Travel date | Planned departure | Date |
| O. Return date | Planned return | Date |
| P. Passport expiry | From the passport's data page | Date |
| Q. Passport check | A warning when the passport is too short for the route | Formula |
| R. Appointment | Visa centre date and time | Date |
| S. Submitted on | Date the application went in | Date |
| T. Decision | Issued, refused or withdrawn | Dropdown |
| U. Decision date | Date the decision arrived | Date |
| V. Fee status | Paid, part paid or unpaid | Dropdown |
| W. Next action | One line starting with a verb: chase leave letter, book appointment | Text |
| X. File link | Where the papers live | Link |
Which statuses and dropdowns should you use?
Six statuses cover most visa files, and each should mean one thing everyone on the team agrees on:
- Enquiry: the client has asked; no fee agreed yet.
- Collecting papers: the checklist has gone out and papers are arriving.
- Checking: all papers are in and a caseworker is reviewing them.
- Ready: checked, letters approved, appointment booked.
- Submitted: the application and biometrics are done.
- Decision: the outcome is in and recorded.
Make status, owner, route, "waiting on", decision and fee status dropdowns, so nobody types "submited" or a nickname into a column you filter on. In Google Sheets, select the column and choose Insert, then Dropdown (Google help); in Excel, choose Data, then Data Validation, and allow a List (Microsoft support). Keep the lists on a separate tab, so a new route or staff member is added in one place. Our post on visa agency CRM stages sets out what each stage should require before a file moves on.
Date checks that catch problems early
Dates are where a spreadsheet earns its keep. These formulas work in both Google Sheets and Excel; change the column letters if your layout differs.
- 1
Days waiting
In M2, enter
=IF(L2="","",TODAY()-L2)and fill down. Sort by this column each morning, and update column L whenever the status or "waiting on" changes, or the number means nothing. - 2
Passport check for Schengen
The Schengen Visa Code requires the passport to be valid at least three months after the intended date of departure and to have been issued within the previous ten years (Regulation 810/2009, Article 12). In Q2:
=IF(P2<EDATE(O2,3),"Passport too short",""). Check the issue date by eye. - 3
Passport check for the UK
GOV.UK says the passport or travel document must be valid for the whole of the stay (GOV.UK). For UK rows:
=IF(P2<O2,"Check passport",""). - 4
Earliest and latest application dates
For a UK visit, the earliest you can apply is three months before travel,
=EDATE(N2,-3), and GOV.UK says a decision usually comes within three weeks. Schengen applications go in no more than six months ahead and, as a rule, no later than 15 calendar days before the trip, which is=N2-15. - 5
Colour the rows that need action
Use conditional formatting with a custom formula (Google help), such as
=AND($K2="Client",$M2>3)to shade files that have waited on the client for more than three days, and=$Q2<>""to shade passport warnings.
How should the team use the tracker every day?
- Each morning, every caseworker filters by their own name and sorts by days waiting. Anything waiting on "us" is today's work.
- Whenever a status changes, the person who changed it updates "waiting since" and the next action in the same minute.
- Each week, the manager filters for files waiting on the client for more than a week and decides whether to chase, pause or close them.
- On every decision, record the outcome and the date and keep the refusal letter in the file, so refusals can later be counted by route.
Before a file moves to Ready, have a second person run the visa file check before submission. The tracker tells you a file is ready to be checked; it does not tell you the file passed.
Is a spreadsheet safe for client data?
Only if you keep sensitive data out of it. Google's help page on protecting sheets says protection shouldn't be used as a security measure, and that people can still print, copy, paste, import and export copies of a protected spreadsheet (Google help). Microsoft says worksheet level protection isn't intended as a security feature (Microsoft support).
- Keep only the last four characters of the passport number in the sheet, and no bank details, ID numbers or scans.
- Share the sheet with named staff accounts, never with anyone who has the link.
- Give each sub-agent a separate sheet of their own clients rather than access to yours, because protecting a range does not hide the other rows.
- Remove access on the day someone leaves the agency.
When does a spreadsheet stop being enough?
When the questions you need answered are about the papers, not the status. A spreadsheet can say a file is in Checking; it cannot say that the salary on the employer letter is not the salary arriving in the bank account. These are the usual signs you have outgrown it:
- Two people edit the same row and overwrite each other, and nobody can say which status is right.
- Papers live in WhatsApp chats and personal phones, and the file link column points to half of them.
- Days waiting keeps climbing because chasing clients is a manual job nobody owns.
- Sub-agents or branches need to see their own clients and nothing else.
- You want refusal reasons by route, caseworker or source of the client, and the decision column is too messy to count.
- The sheet says Ready, but nobody checked the papers against each other before submission.
The first four point to a CRM, which our travel agency CRM guide compares. The last two point to visa file software. Visolv, which we make, reads every paper in the file and checks names, dates, money and the trip against each other with the page behind each finding, chases clients on WhatsApp for what is missing and files what they send, and shows each file's status and who it is waiting on, with reports of approvals by route, staff and waits. Our buyer's guide to visa agency software covers the rest, and the client document checklist template is worth using whichever way you go.
Build the tracker in an afternoon, use it every morning, and keep every column meaning one thing. When it starts to strain, move the busiest routes first, and keep the sheet running until the new system has handled a full month of files.
Frequently asked questions
What columns should a visa application tracker have?
At minimum: file ID, client name, phone, route, owner, status, who the file is waiting on, the date it started waiting, travel and return dates, passport expiry, appointment, submission date, decision and next action. Add nationality and country of residence if you serve expatriates. Keep full passport numbers and bank details out of the sheet and in the client's file.
Is Excel or Google Sheets better for tracking visa applications?
Either works. Google Sheets is easier to share live with several staff working at once; Excel suits an office that already works in Microsoft 365. Both support dropdowns, date formulas such as EDATE and TODAY, and conditional formatting. Pick the one your team already opens every day, and share it only with named staff accounts, never through an open link.
How do I track visa application deadlines in a spreadsheet?
Add date columns for travel, return, passport expiry and appointment, then formulas that warn you. For Schengen, the passport must be valid at least three months after departure, so compare the expiry with EDATE of the return date plus three months. For UK visitor files, the earliest you can apply is three months before travel. Colour the rows that need action with conditional formatting.
When should a visa agency stop using a spreadsheet?
When the questions you need answered are about the papers, not the status: whether the bank statement supports the trip, whether the employer letter matches the form. Other signs are staff overwriting each other, papers scattered across WhatsApp chats, and sub-agents needing their own view. At that point a CRM, visa file software or both will save more time than another column.
Can I share a visa tracker spreadsheet with sub-agents?
Give each sub-agent a separate sheet with only their clients, rather than access to yours. Google says sheet protection shouldn't be used as a security measure and that people can still copy and export a protected sheet; Microsoft says worksheet protection isn't intended as a security feature. Keep passport numbers and bank details out of any sheet you share.
Should a family applying together be one row or several?
Several: one row per applicant, linked by a shared group ID. Each person has their own passport, papers, biometrics and decision, and members of the same family can receive different outcomes. Separate rows show whose papers are missing and whose passport is too short, while the group ID keeps the family together when you filter or sort.
The Visolv team
Editorial team, Easital Technologies Ltd. (Dhaka)
Visolv is software for visa agencies, made in Dhaka by Easital Technologies Ltd.: it reads and checks every paper in a client's file, writes the drafts and builds the upload pack under the agency's own brand. We write about what we see in real visa files from Bangladesh.