Import riders

Onboarding a new company? Upload one spreadsheet instead of typing 200 riders in by hand. Every row is checked before anything is created, so a bad file cannot half-import.

Back to riders

Download the template

An Excel file with the columns already set up

Fill in your riders

One row per rider. 500 rows per file.

Upload the file

We check every row before anything is created

Review and import

Fix what is flagged, then import in one go

What your file must look like

The template already contains this header row and three example riders — delete the examples before you upload

18 columns

Row 1 is the header row and must stay exactly as it is — do not rename, reorder or delete columns. Orange headers are required; grey ones can be left empty and filled in later. Rows 2 onwards are your riders, one per row.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Full name	Civil ID	Nationality	Date of birth	Mobile number	Join date	Delivery platform	Platform rider ID	Shift	Zone	Team	Supervisor	Vehicle plate	Licence number	Licence expiry	Residence expiry	Passport number	Emergency contact
2	Mohammed Aslam	289113400821	Bangladesh	14/03/1994	+96565128840	03/01/2025	Talabat	TLB-99201	Morning	Salmiya	Team A	Yousef Salem	KWT 44-2091	DL-2288104	10/11/2027	02/01/2027	AB4471902	+96599887766
3	Arun Prakash	290227100455	India	22/07/1996	+96566210934	07/02/2025	Talabat	TLB-99244	Morning	Hawally	Team A	Yousef Salem	KWT 29-8823	DL-2290117	04/06/2027	06/02/2027	N8842019	+96598776655
4	Zubair Ali	291004778120	Pakistan	09/11/1993	+96569447120	19/05/2026	Keeta	KTA-40118	Evening	Farwaniya	Team C	Hessa Al-Ajmi	KWT 61-4417	DL-2301882	18/03/2028	18/05/2028	AC9920184	+96597001122

Required — the row is rejected without it

Optional — can be added later

Scroll the sheet sideways to see all 18 columns

Every column explained

Same order as the template

Col	Field	Required	Format	Example	Notes
A	Full name	Required	Text, as printed in the passport	Mohammed Aslam	Given and family name in one cell.
B	Civil ID	Required	12 digits, no spaces or dashes	289113400821	Must be unique. Duplicates are rejected.
C	Nationality	Required	Country name in English	Bangladesh	Full name, not a code.
D	Date of birth	Required	DD/MM/YYYY	14/03/1994	Rider must be 21 or over.
E	Mobile number	Required	+965 and 8 digits	+96565128840	Used for escalation calls. No spaces.
F	Join date	Required	DD/MM/YYYY	03/01/2025	Can be in the future for a planned start.
G	Delivery platform	Required	Talabat, Keeta or Deliveroo	Talabat	Capitals ignored. One platform per row.
H	Platform rider ID	Optional	Text	TLB-99201	Add later if not issued yet.
I	Shift	Required	Morning, Evening or Night	Morning	Must match a shift you have set up.
J	Zone	Required	Operating zone name	Salmiya	Must match a zone in Settings.
K	Team	Optional	Team name	Team A	Created automatically if new.
L	Supervisor	Optional	Supervisor full name	Yousef Salem	Near-matches are suggested, not guessed.
M	Vehicle plate	Optional	KWT 00-0000	KWT 44-2091	Left unassigned if the plate is already taken.
N	Licence number	Optional	Text	DL-2288104	Kuwait driving licence.
O	Licence expiry	If used	DD/MM/YYYY	10/11/2027	Drives the renewal reminders.
P	Residence expiry	Required	DD/MM/YYYY	02/01/2027	Drives the Mandoob WhatsApp reminders.
Q	Passport number	Optional	Text	AB4471902	Stored encrypted.
R	Emergency contact	Optional	+965 and 8 digits	+96599887766	Used only for accidents.

Upload your file

Drop your .xlsx or .csv here

or browse your computer · up to 500 rows and 10 MB

Common mistakes

These account for almost every failed import

Read first

Dates written any other way

3/1/25, Jan 3 2025 and 2025-01-03 are all rejected. Use DD/MM/YYYY and format the column as Text so Excel stops rewriting it.

Civil ID with spaces, dashes or a leading apostrophe

Twelve digits and nothing else. Format the column as Text before you paste, or Excel drops leading zeros.

Mobile numbers without +965

Escalation calls will not connect. Include the country code, no spaces.

A title or logo above the headers

Row 1 must be the header row. Delete anything above it.

Merged cells

Unmerge everything. One value per cell.

Formulas instead of values

Copy, then Paste Special → Values before saving.

The same civil ID twice

The whole file is rejected until duplicates are removed — we will tell you which rows.

Extra sheets in the workbook

Only the first sheet is read. Name it Riders.

Need a hand?

Send the file to your Royah Labs contact and we will map it for you. Worth doing once for the first company you onboard — after that the template does the work.

Review before importing

A dry run of your file — this is what the system found

Not yet imported

Must be fixed — these rows cannot be imported3 rows

Row	Column	What is wrong	How to fix it
14	Civil ID	“2891134008” is 10 digits — 12 required	Correct it in your file and upload again
27	Residence expiry	“31/02/2027” is not a real date	Check the day and month are the right way round
91	Civil ID	Duplicate of row 44 — Suresh Babu	Remove one of the two rows

Needs a decision — we will handle these as described12 rows

Row	Column	What we found	What we will do
8	Vehicle plate	KWT 44-2091 is already assigned to Mohammed Aslam	Import the rider with no vehicle
55	Supervisor	“Yousef S.” not found — closest is Yousef Salem	Ask you to confirm before importing
102	Team	“Team D” does not exist yet	Create the team on import
118	Licence expiry	Expired on 04/02/2026	Import and flag the rider as non-compliant