Onboard your whole team in minutes with spreadsheet import

Typing in employees one at a time is fine for a team of three. For thirty or three hundred, it is painful and error-prone. TeamCey lets you import your whole workforce from a spreadsheet, and with a little prep the upload is clean on the first try.

Why import instead of typing

• Bring in dozens or hundreds of records in one upload
• Reuse the employee data you already keep in Excel or Google Sheets
• Catch duplicate NIC or EPF numbers before they cause payroll errors
• Spend your time reviewing, not retyping

Prepare your spreadsheet

1. 1

   Create a clear header row

   Put one field name in each column header. TeamCey auto-maps common names such as First Name, Work Email, NIC, Basic Salary, Department, and Bank Account Number.

2. 2

   Fill the required columns

   First name, last name, work email, NIC / National ID, and basic salary are required. OT rate, join date, payout method, and bank details are optional but recommended.

3. 3

   Check your NIC formatting

   Keep NIC numbers consistent — either the old or new format, with no stray spaces. This is the single most common cause of failed rows.

4. 4

   Set salary fields as numbers

   Remove currency symbols and thousands separators. A salary cell should read 85000, not Rs. 85,000.

5. 5

   Save as CSV

   Export your sheet as a CSV file. That is the format the importer reads.

Required CSV columns

• First Name - the employee's given name
• Last Name - the employee's family name
• Work Email - unique email address used for the onboarding invite
• NIC or National ID - unique employee identifier; spaces are removed and letters are uppercased
• Basic Salary - monthly salary as a plain number, for example 85000

Optional CSV columns

• OT Rate - hourly overtime rate; leave blank to use 0
• EPF Number - optional, but must be unique if provided
• Personal Email and Phone - contact details stored on the employee profile
• Designation, Department, and Branch Location - department and branch are imported only when those company features are enabled
• Date of Joining - use YYYY-MM-DD; blank rows use the import date
• Payout Method - use bank or cash; it must match your company payroll mode
• Bank Account Number, Bank Name, Bank Branch, and Bank Account Holder - recommended for bank payroll

Run the import

1. 1

   Upload your CSV

   Open the import flow in the Employees section and select your file.

2. 2

   Map your columns

   Match each spreadsheet column to the matching TeamCey field. The importer remembers your mapping for next time.

3. 3

   Preview and validate

   TeamCey shows a preview and flags any rows with problems before anything is saved. Nothing is committed yet.

4. 4

   Confirm the import

   Once the preview has no flagged rows, confirm. TeamCey sends onboarding invites and creates active employee records.

After importing

• Check the imported count matches your headcount
• Fix and re-upload any rows that were flagged
• Ask employees to open the invite email and set their portal password
• Spot-check a few salary structures before your first payroll