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_nameandlast_name, or onenamecolumn (also read:full name)phone(alsomobile): local or international format. We add the country code.email,employee_code(alsoemployee number,employee no,employee id),job_titlelocation: 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:monthlyorhourly(monthly when empty)pay_amount(alsobasic salary,salary,rate): the basic salary per month, or the rate per hourhousing(alsohousing allowance): a monthly housing allowancepay_from: the date the pay starts, asYYYY-MM-DD(the 1st of this month when empty)iban,bank_code(alsorouting code)national_id(alsoiqama,emirates id)mohre_person_id(alsowps 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
- Choose the file and press Check file. Nothing is saved yet.
- The preview shows each person with their phone, employee number, pay, bank and ID.
- If a row has a problem, the screen lists it as “Row 7: …”. Fix the rows in your spreadsheet and choose the file again.
- 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.
17 नवंबर 2026 को प्रोडक्ट से मिलाकर जाँचा गया