Free TM30 Excel template for online filing

Download the Excel template that tm30.immigration.go.th imports with Import Excel (นำเข้า Excel), fill in your foreign guests on your own computer, then upload it. Free, no sign-up.

BaanHost is independent property management software. We are not the Thai Immigration Bureau and are not affiliated with it. Official TM30 reports are filed on the Immigration Bureau's own website, tm30.immigration.go.th. BaanHost never asks for your immigration account or password.

TM30-template.xlsx

The 9 columns of the immigration import template, with every cell already set to text so Excel cannot change passport numbers or dates. Opens in Excel, Google Sheets and Numbers. You fill it in on your own computer; nothing is sent to BaanHost.

Download the TM30 Excel template

How to fill it in so the upload is not rejected

Keep the 9 columns as they are
First name, middle name, last name, gender, passport number, nationality, date of birth, check-out date and phone, in the order of the immigration import template. Do not add, remove or move columns.
Keep every cell as text
The template is already set to text, so Excel cannot turn a passport number into a number or a date into a serial number. When you copy from another file, paste values only.
Names in English letters, exactly as in the passport
The first name is required; gender is M or F.
Dates as DD/MM/YYYY in the Western calendar
Not the Buddhist year: 1985, not 2528. Use 00 for an unknown day or month of birth.
3-letter nationality codes
The system only accepts its own codes, such as GBR, DEU or CHN. The full list is below.
One check-in date per file
Every guest in a file gets the check-in date you choose when uploading. Make one file per day and per accommodation.
At most 1,000 guests per file
All nationality codes the system accepts (267)
  • ALB THE REPUBLIC OF ALBANIA
  • ALD ALMADINAH
  • ASM AMERICA SAMOA
  • AGO REPUBLIC OF ANGOLA
  • AIA ANGUILLA
  • ATG ANTIGUA AND BARBUDA
  • EGY THE ARAB REPUBLIC OF EGYPT
  • ARG ARGENTINE REPUBLIC
  • ARM THE REPUBLIC OF ARMENIA
  • AWB ARUBA
  • AUS AUSTRALIA
  • AUT THE REPUBLIC OF AUSTRIA
  • AZE THE AZERBAIJANI REPUBLIC
  • BRB BARBADOS
  • BLR THE REPUBLIC OF BELARUS
  • BLZ BELIZE
  • BEN REPUBLIC OF BENIN
  • BMU BERMUDA
  • VEN BOLIVARIAN REPUBLIC OF VENEZUELA
  • BIH BOSNIA AND HERZEGOVINA
  • BWA THE REPUBLIC OF BOTSWANA
  • BVT BOUVET ISLAND
  • B13 BRITISH (HK)
  • B17 BRITISH COLONY
  • IOT BRITISH INDIAN OCEAN TERR.
  • BRN BRUNEI DARUSSALAM
  • BGR THE REPUBLIC OF BULGARIA
  • BFA BURKINAH FASO
  • BDI REPUBLIC OF BURUNDI
  • CMR REPUBLIC OF CAMEROON
  • CAN CANADA
  • CPV THE REPUBLIC OF CAPE VERDE
  • C04 CAROLINE ISLANDS
  • CYM CAYMAN ISLANDS
  • CAF CENTRAL AFRICA REPUBLIC
  • TCD REPUBLIC OF CHAD
  • CHL THE REPUBLIC OF CHILE
  • HKG CHINA-HONG KONG
  • CXR CHRISTMAS ISLAND
  • GUY CO-OPERATIVE REPUBLIC OF GUYANA
  • CCK COCOS (KEELING) ISLANDS
  • COL THE REPUBLIC OF COLOMBIA
  • BHS THE COMMONWEALTH OF THE BAHAMAS
  • DMA THE COMMONWEALTH OF DOMINICA
  • COG THE REPUBLIC OF THE CONGO
  • COK THE COOK ISLANDS
  • CRI THE REPUBLIC OF COSTA RICA
  • MNE CRNA GORA MONTENEGRO
  • HRV THE REPUBLIC OF CROATIA
  • CUB THE REPUBLIC OF CUBA
  • C15 CURACAO
  • CYP THE REPUBLIC OF CYPRUS
  • CZE CZECH REPUBLIC
  • D07 D'VOIKE
  • D02 DAITO
  • PRK THE DEMOCRALIC PEOPLE'S REPUBLIC OF KOREA
  • COD DEMOCRATIC REPUBLIC OF THE CONGO
  • STP THE DEMOCRATIC REPUBLIC OF SAO TOME AND PRINCIPE
  • LKA THE DEMOCRATIC SOCIALIST REPUBLIC OF SRI LANKA
  • DIM DINAMARCZ
  • DJI THE REPUBLIC OF DJIBOUTI
  • DOM THE DOMINICAN REPUBLIC
  • E01 EAST GERMAN
  • URY THE EASTERN REPUBLIC OF URUGUAY
  • ECU REPUBLIC OF ECUADOR
  • SLV THE REPUBLIC OF EL SALVADOR
  • GNQ REPUBLIC OF EQUATORIAL GUINEA
  • ERI ERITREA
  • EST ESTONIA
  • FRO FAEROES
  • FLK FALKLAND ISLANDS (MALVINAS)
  • ETH FEDERAL DEMOCRATIC REPUBLIC OF ETHIOPIA
  • NPL FEDERAL DEMOCRATIC REPUBLIC OF NEPAL
  • DEU THE FEDERAL REPUBLIC OF GERMANY
  • NGA FEDERAL REPUBLIC OF NIGERIA
  • YUG THE FEDERAL REPUBLIC OF YOGOSLAVIA
  • FSM THE FEDERATED STATES OF MICRONESIA
  • BRA FEDERATIVE REPUBLIC OF BRAZIL
  • FJI THE REPUBLIC OF FIJI
  • FIN THE REPUBLIC OF FINLAND
  • MKD THE FORMER YUGOSLAV REPUBLIC OF MACEDONIA
  • FXX FRANCE METROPOLITAN
  • FRA THE FRANCE REPUBLIC
  • GUF FRENCH GUIANA
  • PYF FRENCH POLYNESIA
  • ATF FRENCH SOUTHERN TERRIORIES
  • GAB GABONESE REPUBLIC
  • GEO GEORGIA
  • GHA REPUBLIC OF GHANA
  • GIB GIBRALTAR
  • LUX THE GRAND DUCHY OF LUXEMBURG
  • GRL GREENLAND
  • GRD GRENADA
  • GLP GUADELOUPE
  • GUM GUAM
  • GTM THE REPUBLIC OF GUATEMALA
  • GIN REPUBLIC OF GUINEA
  • N02 THE REPUBLIC OF GUINEA
  • GNB REPUBLIC OF GUINEA-BISSAU
  • HTI THE REPUBLIC OF HAITI
  • JOR THE HASHEMITE KINGDOM OF JORDAN
  • HMD HEARD AND MCDONALD ISLANDS
  • GRC THE HELLENIC REPUBLIC
  • HND THE REPUBLIC OF HONDURAS
  • HUN THE REPUBLIC OF HUNGARY
  • ISL THE REPUBLIC OF ICELAND
  • IND THE REPUBLIC OF INDIA
  • IDN THE REPUBLIC OF INDONESIA
  • IRQ THE REPUBLIC OF IRAQ
  • IRL IRELAND
  • COM THE ISIAMIC FEDERAL REPUBLIC OF THE COMOROS
  • GMB THE ISLAM REPUBLIC OF THE GAMBIA
  • IRN THE ISLAMIC REPUBLIC OF IRAN
  • MRT THE ISLAMIC REPUBLIC OF MAURITANIA
  • PAK THE ISLAMIC REPUBLIC OF PAKISTAN
  • AFG THE ISLAMIC STATE OF AFGHANISTAN
  • ITA THE ITALIAN REPUBLIC
  • JAM JAMAICA
  • JPN JAPAN
  • KAZ THE REPUBLIC OF KAZAKHSTAN
  • KEN REPUBLIC OF KENYA
  • BEL THE KINGDOM OF BELGIUM
  • BTN THE KINGDOM OF BHUTAN
  • KHM THE KINGDOM OF CAMBODIA
  • DNK THE KINGDOM OF DENMARK
  • LSO THE KINGDOM OF LESOTHO
  • MAR THE KINGDOM OF MOROCCO
  • NLD THE KINGDOM OF NETHERLANDS
  • NOR THE KINGDOM OF NORWAY
  • SAU THE KINGDOM OF SAUDI ARABIA
  • ESP THE KINGDOM OF SPAIN
  • SWZ THE KINGDOM OF SWAZILAND
  • SWE THE KINGDOM OF SWEDEN
  • THA THE KINGDOM OF THAILAND
  • TON THE KINGDOM OF TONGA
  • KIR KIRIBATI
  • KOR THE REPUBLIC OF KOREA
  • RKS REPUBLIC OF KOSOVO
  • KGZ THE KYRGYS REPUBLIC OF
  • LAO THE LAO PEOPLE'S DEMOCRATIC REPUBLIC
  • LVA THE REPUBLIC OF LATVIA
  • LBN THE LEBANON REPUBLIC
  • LBR REPUBLIC OF LIBERIA
  • LTU THE REPUBLIC OF LITHUANIA
  • MAC MACAO
  • MDG THE REPUBLIC OF MADAGASCAR
  • MWI THE REPUBLIC OF MALAWI
  • MYS MALAYSIA
  • MDV THE REPUBLIC OF MALDIVES
  • MLI REPUBLIC OF MALI
  • MLT THE REPUBLIC OF MALTA
  • MNP MARIANA
  • MHL THE REPUBLIC OF THE MARSHALL ISLANDS
  • MTQ MARTINIQUE
  • MUS THE REPUBLIC OF MAURITIUS
  • MYT MAYOTTE
  • MDA THE REPUBLIC OF MOLDOVA
  • MNG MONGOLIA
  • MSR MONTSERRAT
  • MOZ THE REPUBLIC OF MOZAMBIQUE
  • NAM THE REPUBLIC OF NAMIBIA
  • NRU THE REPUBLIC OF NAURU
  • ANT NETHERLANDS ANTILLES
  • NZL NEW ZEALAND
  • NCL NEWCALEDONIA
  • NIC THE REPUBLIC OF NICARAGUA
  • NER REPUBLIC OF NIGER
  • NIU NIUE
  • NFK NORFOLK ISLAND
  • PLW THE REPUBLIC OF PALAU
  • PLT PALESTINE
  • PAN REPUBLIC OF PANAMA
  • PNG PAPUA NEW GUINEA
  • PRY REPUBLIC OF PARAGUAY
  • BGD THE PEOPLE'S REPUBLIC OF BANGLADESH
  • CHN THE PEOPLE'S REPUBLIC OF CHINA
  • DZA THE PEPLE'S DEMOCRATIC REPUBLIC OF ALGERIA
  • PER REPUBLIC OF PERU
  • PHL THE REPUBLIC OF THE PHILIPPINES
  • PCN PITCAIRN
  • BOL PLURINATIONAL STATE OF BOLIVIA
  • POL THE REPUBLIC OF POLAND
  • PRT THE PORTUGAL REPUBLIC
  • P10 PRINCEBLE
  • AND THE PRINCIPALITY OF ANDORRA
  • LIE THE PRINCIPALITY OF LIECHTENSTEIN
  • MCO THE PRINCIPALITY OF MONACO
  • PRI PUERTO RICA
  • XXB REFUGEE (1951 CONVENTION)
  • XXC REFUGEE (OTHER)
  • TMP REPUBLIC EAST TIMOR
  • REU REUNION ISLAND
  • ROU ROMANIA
  • RUS THE RUSSIAN FEDERATION
  • RWA THE RWANDESE REPUBLIC
  • CIV Republic of Cote d’Ivoire
  • LCA SAINT LUCIA
  • VCT SAINT VINCENT AND THE GRENADINES
  • WSM THE REPUBLIC OF SAMOA
  • SMR THE REPUBLIC OF SAN MARINO
  • SCT SCOTLAND
  • SEN REPUBLIC OF SENEGAL
  • SRB SERBIA
  • SYC THE REPUBLIC OF SEYCHELLES
  • SLE REPUBLIC OF SIERRA LEONE
  • SGP THE REPUBLIC OF SINGAPORE
  • SVK THE SLOVAK REPUBLIC
  • SVN THE REPUBLIC OF SLOVENIA
  • LBY THE SOCIALIST PEOPLE'S LIBYAN ARAB JAMAHIRIYA
  • VNM THE SOCIALIST REPUBLIC OF VIETNAM
  • SLB SOLOMON ISLANDS
  • SOM THE SOMALI DEMOCRATIC REPUBLIC
  • ZAF THE REPUBLIC OF SOUTH AFRICA
  • SGS SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS
  • SSD REPUBLIC OF SOUTH SUDAN
  • S14 SPANISH SAHARA
  • UNA SPECIALIZED AGENCY OF UNITED NATIONS
  • SHN ST. HELENA
  • SPM ST. PEIRRE AND MIQUELON
  • KNA ST.CHRISTOPHER/NEVIS
  • BHR THE STATE OF BAHRAIN
  • ISR THE STATE OF ISRAEL
  • KWT THE STATE OF KUWAIT
  • QAT THE STATE OF QATAR
  • XXA STATELESS
  • SDN REPUBLIC OF THE SUDAN
  • OMN THE SULTANATE OF OMAN
  • SUR REPUBLIC OF SURINAME
  • SJM SVALBARD AND JAN MAYEN ISLANDS
  • CHE THE SWISS CONFEDERATION
  • SYR THE SYRIAN ARAB REPUBLIC
  • TWN TAIWAN
  • TJK THE REPUBLIC OF TAJIKISTAN
  • TLS TIMOR-LESTE
  • TGO REPUBLIC OF TOGO
  • TKL TOKELAU
  • TTO REPUBLIC OF TRINIDAD AND TOBAGO
  • T10 TRUST PACIFIC
  • TUN THE REPUBLIC OF TUNISIA
  • TUR THE REPUBLIC OF TURKEY
  • TKM TURKMENISTAN
  • TCA TURKS AND CAICOS ISLANDS
  • TUV TUVALU
  • UGA REPUBLIC OF UGANDA
  • UKR UKRAINE
  • MMR THE UNION OF MYANMAR
  • ARE THE UNITED ARAB EMIRATES
  • GBR THE UNITED KINGDOM OF GREAT BRITAIN
  • GBN UNITED KINGDOM OF GREAT BRITIAN AND NORTHERN IRELAND
  • MEX THE UNITED MEXICAN STATES
  • UNO UNITED NATION
  • UMI UNITED STATES MINOR OUTLYING ISLANDS
  • USA THE UNITED STATES OF AMERICA
  • TZA THE UNITED REPUBLIC OF TANZANIA
  • XXX UNKNOWN
  • UTO UTOPIA
  • UZB THE REPUBLIC OF UZBEKISTANS
  • VUT THE REPUBLIC OF VANUATU
  • VAT VATICAN CITY STATE THE HOLY SEE
  • VIS VIRGIN ISLANDS
  • WLF WALLIS AND FUTUNA ISLANDS
  • YEM THE REPUBLIC OF YEMEN
  • Y03 YEMEN REP.
  • ZAR ZAIRE
  • ZMB THE REPUBLIC OF ZAMBIA
  • ZIM THE REPUBLIC OF ZIMBABWE
  • ZWE THE REPUBLIC OF ZIMBABWE (ZWE)

Upload the file in three steps

  1. Log in at tm30.immigration.go.th and click Import Excel (นำเข้า Excel).
  2. Choose your accommodation and the check-in date (only today or yesterday can be chosen), choose the file and click Show data from Excel.
  3. If no row is red, click Save (บันทึก) and download the receipt straight away: after 7 days it can no longer be found.

First time? How to open an account and add your accommodation is explained step by step in our TM30 guide

Questions

Is this the official TM30 form?

No. The official TM30 system and forms belong to the Immigration Bureau. This template follows the layout of the Bureau's own Excel import file, so the online system reads it directly. The paper TM30 form you hand in at an immigration office is a different document.

Who has to file TM30, and how fast?

The owner or operator of the accommodation, within 24 hours of a foreign guest's arrival. Thai guests are not reported.

Does BaanHost see my guests' details?

No. You download an empty template and fill it in on your own computer. Nothing is sent to BaanHost.

Can I file late guests online?

No. The online system only accepts a check-in date of today or yesterday. Older stays have to be filed at the immigration office.

Tired of typing passports every day?

BaanHost reads passports with the phone camera, lists every foreign guest with the 24-hour deadline and makes this file in one tap. Free for 14 days, no card needed.

Try free