The TM30 Excel file: how to fill it in so it's accepted
The columns, the rules and the common mistakes that make the immigration system reject your file.
What this file is
Immigration's online TM30 system uses the file Template-InformAccom-ImportExcel.xls to import many guests at once. Download it with the “Download Example File” button in the system.
Columns
| Column | Data | Required |
|---|---|---|
| A | First Name | ✓ |
| B | Middle Name | |
| C | Last Name | |
| D | Gender (M or F) | ✓ |
| E | Passport No. | ✓ |
| F | Nationality (3-letter code) | ✓ |
| G | Birth Date (DD/MM/YYYY, A.D.) | |
| H | Check-out Date (DD/MM/YYYY, A.D.) | |
| I | Phone No. |
Dates use the Western (A.D.) year, not the Thai Buddhist year. For an unknown day or month the template accepts 00, for example 00/00/1985.
Rules to follow
- Data must be on the first sheet, starting on row 2 (row 1 is the headers)
- No empty rows between guests, and at most 1,000 rows per file
- Gender must be M or F
- Nationality must be a code from the template's “Nationality” sheet. See TM30 nationality codes
- Don't rename the headers or delete sheets from the template
Common mistakes
- Country names instead of codes: use 3-letter codes such as GBR (United Kingdom), USA, CHN or JPN. German passports show “D” in the machine-readable lines, but the file needs DEU
- Leading zeros disappear: Excel often turns passport numbers into numbers. Format the cells as Text
- Typos in names: typing from each passport is error-prone. Always compare with the real passport
- Wrong file type: save as .xls or .xlsx, not CSV
Let TM30Auto fill it in
TM30Auto reads passport photos and fills columns A, D, E and F of immigration's template for you. It keeps passport numbers as text, converts nationality codes to match the template and checks for duplicates before you download. Everything is read in your browser and passport photos are never uploaded.
Stop typing passport details by hand
Upload passport photos and TM30Auto reads the name, gender, passport number and nationality, then gives you the Excel file in immigration's template. It runs on your device and photos are never uploaded. 5 free scans a day.
This article is general information for accommodation operators, not legal advice. Immigration rules and websites can change. Check the latest requirements with your local immigration office.