Union Technology
Grievance Software vs. Spreadsheets, Shared Drives and Email
A spreadsheet can be a useful starting point. The decision to move should depend on how reliably your union can manage responsibility, deadlines, evidence and access—not on the size of the feature list.
LaborNexa Systems, Inc. · Updated October 26, 2026
When a spreadsheet can work well
A small team handling a limited number of matters may be able to maintain a shared workbook effectively. A stable case ID, concise status, assigned representative, next action and reviewed due date can provide a practical overview. A spreadsheet is familiar, flexible and easy to adapt as the team learns what it needs.
It still needs an owner, a protected storage location, controlled access and a consistent update routine. Decide which copy is authoritative. Avoid passing separate versions around by email. Keep a change history if the tool supports it, and agree who may alter formulas, dropdown values or the structure of the workbook.
Recognize the limits before they become a crisis
A row can summarize a case, but the full record often lives elsewhere: documents in folders, notes in email and deadlines on individual calendars. The risk is not simply that a workbook is “old technology.” It is that the relationships between those records become unclear.
Watch for repeated questions about which document was filed, why a due date changed or who is covering an absent steward. Other warning signs include duplicate case IDs, conflicting status values, broad access to sensitive notes and reporting that takes hours of manual cleanup. These are workflow problems a dedicated system may help address.
Compare the work, not just the tools
| Need | Shared spreadsheet | Dedicated case software |
|---|---|---|
| Case overview | Flexible rows and filters; depends on consistent entry. | Structured statuses, assignments and case views. |
| Evidence | Usually links to separate files and folders. | May connect documents and notes directly to the case. |
| Deadline history | Requires a deliberate log of calculations and changes. | May support steps, triggers, adjustments and task ownership. |
| Access | Often governed at the file or sheet level. | May offer role- or record-based controls; verify the actual product. |
| Reporting | Formulas and pivots work when source data stays consistent. | Can use structured records, but still depends on data quality. |
Capabilities vary by product and configuration. A software label does not guarantee the permissions, export options or deadline behavior your organization needs.
Count the work behind the subscription
Compare total effort, not just the monthly price. Include setup, data cleanup, training, ongoing administration and the time required to reconstruct a record when someone is away. Also consider what happens when the person who built the workbook leaves office.
A new system has its own costs: representatives must learn it, records need consistent entry and someone must own configuration. Software cannot resolve an unclear grievance procedure or an undefined assignment process. Fix those decisions as part of the transition.
Test a realistic fictional matter
Use the same fictional case when evaluating alternatives. Take it from intake to an assigned next action, add evidence, record a procedural deadline, change representatives and close it with follow-up still due. Ask a second person to find the current status without help from the original author.
Check a restricted role as well as an administrator account. Verify what the representative can see, what is excluded from reports and how records can be exported. Ask how configuration changes are handled and what support is available. Avoid entering confidential member or case information into a demonstration environment.
Move records in a controlled sequence
Inventory your current fields and decide which values to standardize. Remove duplicate identifiers carefully, reconcile active matters against source documents and identify which dates still need review. Preserve the original files according to your retention rules before changing the working record.
- Map a small sample of fictional or appropriately approved records.
- Confirm member links, statuses, documents and deadline values.
- Have representatives review the result using their normal workflow.
- Agree on a cutover date and which system becomes authoritative.
- Reconcile active matters after the transition and keep a documented correction process.
Do not assume imports can interpret a formula, attachment link or informal abbreviation correctly. Keep the source of each important value traceable.
Choose a tool the team can sustain
Stay with a spreadsheet if your process is reliable and the team can maintain its controls. Consider dedicated software when linked records, handoffs, permission boundaries and reporting have become difficult to manage consistently. Document the reasons for your choice so the decision can be reviewed later.
LaborNexa Cases supports union-focused case and representation workflows. Whichever tool you use, start with a clear grievance tracking process. Procedures and deadlines depend on the applicable CBA, policy, statute and jurisdiction; verify them independently of the tool.
Decide what each tool will own
A spreadsheet is useful for a small, consistently maintained register. A shared drive holds source files, while email records correspondence. Their limits become visible when the same fact is copied into several places: an updated deadline in the workbook, an older date in the email and a settlement version whose filename does not show whether it was signed.
Dedicated grievance software can connect those relationships, but it still needs clear ownership and reviewed data. Decide which record is authoritative, who may update it and what a handoff must include. Do not migrate merely to reproduce an unclear process in a different interface.
Evaluate a connected grievance workflow using one fictional matter. Compare how each option handles a changed deadline, an absent representative and a final remedy still awaiting delivery. For commercial scope, use the union software cost guide.