Spreadsheet or system? When Excel stops working for foreign worker records

Most recruitment agencies start with a spreadsheet, and that is a sensible start. It costs nothing, everyone knows how to use it and it can hold a few dozen workers without trouble. The question is not whether a spreadsheet is bad. It is when it stops being enough.

What a spreadsheet does well

Be fair to the tool. A spreadsheet is good at:

• holding rows of facts that a person can read at a glance
• sorting and filtering by a date or an employer client
• being changed quickly by someone who knows the layout

For a small roster managed by one careful person, that is often all you need. Moving to a system too early adds work without adding much.

Signs that Excel has stopped working

The breaking point is rarely size alone. It is the combination of people, clients and documents. Look for these signs:

1. More than one person edits it. Two copies appear, or one person's changes overwrite another's. Nobody can say which file is current.
2. There is one workbook per employer client. A worker who moves between clients exists in two places, and the numbers no longer add up.
3. The documents live somewhere else. The sheet says a permit is on file, but the scan is in a shared drive folder, an email thread or a phone. Finding it costs ten minutes.
4. Dates are checked by eye. Someone scans the column each week. When that person is away, nobody does.
5. Nobody can say who last changed a cell. A correction and an error look the same.
6. Clients ask for a status and it takes a day. Building the answer means filtering, copying and checking against another file. A monthly status report for each employer client built from records answers most of those questions in advance.

One sign is normal. Three or more means the spreadsheet is now the slowest part of the operation.

What a system should add

Moving to software is only worth it if the new tool does things the sheet cannot. Check for these:

• One record per worker, with the documents attached to the facts they support.
• Dates as data, with warnings that reach a list before a deadline.
• A review step, so an upload is not treated as evidence until a person has looked at it.
• Reasons, so each item on the list says why it is there and where to fix it.
• History, so a correction or a renewed document keeps the earlier version.
• Scoped access, so a clerk sees assigned employer clients and a client contact sees only their own workers.
• Exports, so you can still produce an Excel file when someone asks for one.

If a tool cannot show why an item needs attention, it has only moved the guessing to a new screen.

One workspace, every employer client.

Choose an employer client and every view follows, from the Work Queue to Reports.

Book a DemoSee the solutions

How to move without losing a month

Switching does not mean retyping the roster.

1. Clean the spreadsheet first: one row per worker, one column per fact, dates as dates. The clean-up checklist covers the common problems.
2. Import the roster you already have from XLSX or CSV, then check the preview before confirming.
3. Attach the documents to each record as you work through the expiry list, starting with the soonest dates.
4. Keep the old file read-only for a short period, then retire it.

Mistakes to avoid when you switch

Three mistakes show up again and again. The first is moving a messy roster as it is, which only relocates the mess. Clean the file before you import it. The second is switching on a busy week, with no time to check the first imports. Pick a quieter period, and start with one employer client so your team can learn the tool on a manageable set. The third is leaving the old spreadsheet editable. Within a month there are two versions of the truth and nobody trusts either.

Decide on a date after which the old file is read-only, tell everyone, and hold to it. A short transition with one clear cut-over beats a long period where both are half in use.

Where Worker Vault fits

Worker Vault keeps recruitment and worker records in one workspace for several employer clients. Each worker has one record with documents, a person reviews uploads before they count, and a Work Queue shows what needs attention and why. You can import existing workers from XLSX or CSV and export Excel workbooks when someone needs a file.

It is not a replacement for good habits. A weekly review still belongs to a person. What changes is that the review works from one list that is built from the records.

If your agency is at three or more of the signs above, Book a Demo and we will show you how your own roster would look. You can also read about worker records and the Work Queue before you decide.