The starting point
Decide which source is authoritative, map fields deliberately and reconcile the result before retiring the old process. Do not assume Crewzy accepts a particular spreadsheet import format.
1. Find the records and choose an owner
List the spreadsheets, folders and other systems that hold employee information. Identify who maintains each source, when it was last checked and which records overlap. Choose an owner to resolve disagreements rather than allowing two different versions of the same fact to migrate.
Separate current employees from former staff, candidates and other contacts. Decide the intended scope before moving data. Keep information only for a defined business purpose and apply your access and retention policies. The ICO guidance below explains the UK employment-record responsibilities that should inform those decisions.
2. Clean the source and map the meaning
Use an internal employee reference to find duplicates. Check names, start dates, teams and managers with the responsible owner. Ambiguous dates deserve particular attention: 03/04 can mean different things in different formats. Agree an unambiguous representation and check the destination's accepted format.
The following is an illustrative mapping exercise, not a Crewzy CSV specification. Verify the supported destination fields and the available setup method before preparing an import file or arranging manual entry.
| Source issue | Decision to document |
|---|---|
| Two rows for one person | Which internal employee reference and source record are authoritative |
| Department names differ | The agreed team names and how old labels map to them |
| Manager listed by first name only | The correct manager's employee reference |
| Dates use mixed formats | The checked date and the destination's required format |
| Document paths point to private folders | Who can transfer the evidence and verify access |
| Leave balance has no effective date | The date and adjustments behind the opening balance |
3. Test a small, representative group
Choose a small group that includes the differences your process must handle: for example, different teams, a manager relationship and an employee with existing documents. Use authorised records and transfer them through the agreed method. Confirm that a successful transfer means the information is usable, not merely that a screen reported completion.
Check each selected record against the agreed source. Verify the employee reference, relationships, dates and document access. Ask the people who maintain the information to review the result. Resolve mapping problems in the source or process before repeating the transfer for the remaining group.
4. Reconcile the full transfer
Compare the number of expected records with the number created, but do not rely on counts alone. Two duplicate records can hide a missing employee. Reconcile by employee reference and inspect exceptions. Record which items need follow-up and who owns them.
Set a clear handover point after reconciliation. Explain where new changes should be made and who can edit the old files. Preserve or dispose of the original material according to your retention policy; do not leave a second writable master in circulation by accident.
- Scope, record owner and authoritative sources are agreed.
- Duplicates and ambiguous fields are resolved.
- Supported fields and the transfer method are confirmed.
- A representative pilot has been checked by the record owner.
- Records reconcile by employee reference, not just total count.
- Document and role access have been reviewed.
- Outstanding exceptions have owners and next actions.
- The handover date and treatment of old files are communicated.
5. Maintain the record after migration
Assign ownership for future corrections and establish how employees can report inaccurate information. Review the first few changes after the handover: a new joiner, a manager change or a document update can reveal a process gap that a bulk count misses.
Keep access proportionate to each person's responsibilities. A shared HR workspace does not mean every user should see every employee's information. Review the actual role controls and your team's working practices together.
Explore this workflow in Crewzy
Crewzy provides connected employee records, documents and HR workflows. Discuss your current data and required transfer method before planning a migration; this guide does not claim a bulk spreadsheet importer or an automatic transfer from your existing HR system.
Further reading
Prepared by Crewzy. Worked examples are illustrative and do not describe customers or guarantee an outcome. Check current official guidance and your own requirements before applying them.