Getting started

Import your people from a CSV file

Add a whole team from a spreadsheet, with pay and bank details if you like: the columns, the checks and the most common errors.

Where to find it

Open People and choose Import CSV. Save your spreadsheet as CSV (in Excel: File → Save as → CSV UTF-8). The first row must be the header.

Columns

Only a name is needed. Column names are not case-sensitive, and spaces count as underscores, so Employee number works as well as employee_code.

  • first_name and last_name, or one name column (also read: full name)
  • phone (also mobile): local or international format. We add the country code.
  • email, employee_code (also employee number, employee no, employee id), job_title
  • location: the name of a location you already added (capitals do not matter)

Optional pay and bank columns

If you run pay in TopTimesheets, add these and skip typing them one by one later. You need pay access (owner or payroll admin) to import them.

  • pay_type: monthly or hourly (monthly when empty)
  • pay_amount (also basic salary, salary, rate): the basic salary per month, or the rate per hour
  • housing (also housing allowance): a monthly housing allowance
  • pay_from: the date the pay starts, as YYYY-MM-DD (the 1st of this month when empty)
  • iban, bank_code (also routing code)
  • national_id (also iqama, emirates id)
  • mohre_person_id (also wps id, labour card): UAE only, the 14-digit MOHRE person ID

Download a template with pay and bank columns on the import screen gives you a file with the main pay and bank columns in place.

Check, then import

  1. Choose the file and press Check file. Nothing is saved yet.
  2. The preview shows each person with their phone, employee number, pay, bank and ID.
  3. If a row has a problem, the screen lists it as “Row 7: …”. Fix the rows in your spreadsheet and choose the file again.
  4. When no problems are found, press Import.

Common errors

  • unknown location … add it first: add the location under Locations, or fix the name in the file.
  • Invalid IBAN: check the country letters and the length. Spaces are fine.
  • bank_code must be the 9-digit WPS routing code in the UAE: use the routing code of the person's bank or exchange house, not the bank's name.
  • pay_amount is required with pay_type, housing or pay_from: a row with pay details needs an amount.

Next

Send everyone their clock-in link from People → Share all links. See Clock-in links and Your first payroll file.

Checked against the product on 17 November 2026

Was this article helpful?

Still stuck?

Write to us and tell us which screen you are on and what you expected to happen.

See our contact details

Working for a company that uses TopTimesheets? Your manager can fix your hours and your clock-in link.

Part of the MeWeBe network · Backed on MeWeBe