Before you move from Excel to HR software
Five things to clean up in your list before you bring it over.
Excel is a good tool, it just was not made to be an HR ledger. If you have decided to move, the slow part is not setting up software but cleaning your list. Check these five things first.
1. One row, one person
Is the same person on two rows? Are there merged cells? Does every column heading fit on one row? Import tools read rows and do not care how a sheet looks. Keep one row per person and the heading at the top.
2. Write the same thing the same way
"Human Resources", "HR" and "human resources" read as three different units. Sort the unit and job title columns alphabetically and spelling differences stand out.
3. Use one date format
What looks like a date in a cell may be text. If one column mixes day-month-year and month-day-year, fix it by hand. A wrong hire date means wrong service and leave figures.
4. Turn formulas into values
A formula linked to another file breaks when the file moves. In the copy you import, convert formulas to values. Leave your original file as it is.
5. Separate sensitive columns
Salary and national ID should not sit in a file sent to everyone. Decide up front who runs the import, and delete the copy when done.
Then what?
In biik you upload your list, map the columns, see faulty rows before importing and undo the import if it goes wrong. If you do not have a list yet, start with our employee list template.
This post is for information only and is not legal advice.