VisolvVisolv
BlogHow it worksPricingHonestyFor agencies
Visolv

Software for visa agencies, used under the agency's own name. Made in Dhaka by Easital Technologies Ltd.

HomeHow it worksPricingFor agenciesHonestyContactBlog RSS feed

Visolv is independent software for visa agencies. It is not a government site, an embassy, a visa centre, a visa agent or a law firm; it does not process or submit visas, gives no legal or immigration advice and cannot promise a visa: every decision is made by the visa authority. Figures in these posts come from the official and named sources each post links.

© 2026 Easital Technologies Ltd., DhakaTermsPrivacyAI policyHonesty promise
  1. Home
  2. Blog
  3. Visa application tracker: a spreadsheet layout that works
Playbooks

Visa application tracker: a spreadsheet layout that works

A visa application tracker spreadsheet for agencies: the columns, dropdowns, date checks and colour rules to use, and signs a spreadsheet is no longer enough.

By The Visolv team·Published 17 November 2026·10 min read

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

A visa application tracker layout (copy the columns in this order)
ColumnWhat goes in itFormat
A. File IDYour own number, such as 2026-0142, never reusedText
B. Group IDShared by family members or a group applying togetherText
C. Client nameAs printed on the passportText
D. Phone or WhatsAppThe number the client actually answersText, with country code
E. Passport (last 4)Last four characters only; the full number stays in the client's fileText
F. NationalityThe passport's countryDropdown
G. Country of residenceWhere the client lives and applies, which matters for expatriatesDropdown
H. RouteDestination and visa type, such as UK visitor or Schengen France short stayDropdown
I. OwnerThe caseworker responsibleDropdown of staff
J. StatusOne of your stagesDropdown
K. Waiting onClient, us, visa centre or embassyDropdown
L. Waiting sinceDate the status or waiting-on last changedDate
M. Days waitingCalculated from LFormula
N. Travel datePlanned departureDate
O. Return datePlanned returnDate
P. Passport expiryFrom the passport's data pageDate
Q. Passport checkA warning when the passport is too short for the routeFormula
R. AppointmentVisa centre date and timeDate
S. Submitted onDate the application went inDate
T. DecisionIssued, refused or withdrawnDropdown
U. Decision dateDate the decision arrivedDate
V. Fee statusPaid, part paid or unpaidDropdown
W. Next actionOne line starting with a verb: chase leave letter, book appointmentText
X. File linkWhere the papers liveLink

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:

  1. Enquiry: the client has asked; no fee agreed yet.
  2. Collecting papers: the checklist has gone out and papers are arriving.
  3. Checking: all papers are in and a caseworker is reviewing them.
  4. Ready: checked, letters approved, appointment booked.
  5. Submitted: the application and biometrics are done.
  6. 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. 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. 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. 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. 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. 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.

For visa agencies

Agencies: see how Visolv works

Visolv reads every paper in a client's file, flags edited or mismatched ones with the page they came from, writes the drafts from the papers and builds the upload pack in the visa centre's order. Your staff approve every step, under your agency's own name.

See how Visolv works

For applicants

Applicants: ask your visa agency

Visolv doesn't take applications from travellers. If you are applying, ask your visa agency whether it checks files with Visolv before submission: it reads each of your papers against the others and asks for the original whenever one looks edited. The decision always belongs to the embassy.

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.

What a tracker, and Visolv, will not do

A tracker records what your team tells it; it never checks a paper. Visolv checks papers but does not make, edit or backdate any of them, does not submit applications to any government portal, and does not predict decisions. If a client offers a paper that was "fixed" to match the form, the right entry in the next action column is: ask for the original.

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.

On this page

  1. What should a visa application tracker include?
  2. The column layout
  3. Which statuses and dropdowns should you use?
  4. Date checks that catch problems early
  5. How should the team use the tracker every day?
  6. Is a spreadsheet safe for client data?
  7. When does a spreadsheet stop being enough?
  8. Frequently asked questions

Keep reading

Playbooks

Documents for a visa for a business owner: the checklist

Documents for a visa for a business owner or self-employed client: trade licence, company and tax papers, what each embassy asks for, and how they must agree.

17 November 2026 · 9 min read

Playbooks

Visa document checklist template to send your clients

A visa document checklist template for visitor visa clients: six sections to copy, add-ons for the UK, Schengen and Canada, and how to send it so papers arrive.

17 November 2026 · 9 min read

Playbooks

Family visit visa documents: how to prepare a family file

Family visit visa documents for UK, Schengen and Canada files: one application each, children's consent letters, one funder for all, and the cross-checks.

17 November 2026 · 13 min read