CSV File Guide
You may download a sample CSV file as a reference to help you create the file for upload.
The file to be uploaded should be in comma-separated values (CSV) file format (i.e., files with a .csv extension). Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The value of a field can be enclosed in double quotes. CSV files can be viewed and manipulated through a spreadsheet application or text editor.
The first row of the CSV file is the column headings. Each subsequent row corresponds to one record.
Example:
Full Name,Phone,Nationality,MyKad/MyPR/NRIC,Passport #,Date of Birth,Gender ADAM IBRAHIM,0120123456,ID,900114123456,,14/01/1990,1 ZARA ALI,0160123456,SG,,C01234567,10/06/1995,2
Col | Header | Required | Description |
---|---|---|---|
A | Full Name | Yes | The name as printed on MyKad/MyPR or on passport. |
B | Phone | No | The mobile phone number registered in Malaysia, without IDD country code and space, e.g., 0120123456 . |
C | Nationality | Yes | Two-letter alpha-2 country code, e.g., MY for Malaysia and ID for Indonesia. Please refer to Wikipedia for complete list of codes. |
D | MyKad/MyPR/NRIC | Yes for Malaysians Optional for non-Malaysians |
MyKad for Malaysian, MyPR for permanent residence; with or without dashes, e.g. 900112-01-3456 or 900112013456 . |
E | Passport # | Yes for non-Malaysians | Passport number is required for non-Malaysians, except for permanent residence with MyPR card. |
F | Date of Birth | No | Date format is dd/mm/yyyy . E.g., 02/05/1980 for 2nd of May, 1980. |
G | Gender | No | The value for male can be 1 , M , or L ; for female: 2 , F , or P . |