免费 TM30 Excel 模板,网上申报直接用
下载 tm30.immigration.go.th 用 นำเข้า Excel / Import Excel 能直接导入的 Excel 模板,在自己电脑上填好外国客人再上传。免费,无需注册。
BaanHost 是独立的住宿管理软件,不是泰国移民局,也和移民局没有任何关系。TM30 的正式申报在移民局自己的网站 tm30.immigration.go.th 上完成。BaanHost 不会向您索要移民局系统的账号或密码。
TM30-template.xlsx
下载 TM30 Excel 模板9 列和移民局导入模板一致,每一格都已设成文本,Excel 不会改动护照号码和日期。Excel、Google 表格、Numbers 都能打开。在你自己的电脑上填写,什么都不会发给 BaanHost。
怎么填,上传才不会被退回
- 保持官方 9 列不动
- 名、中间名、姓、性别、护照号码、国籍、出生日期、退房日期和电话,顺序与移民局导入模板一致。不要增加、删除或移动列。
- 每一格保持文本
- 模板已经把每一格设成文本,Excel 不会把护照号码变成数字,也不会把日期变成序号。从别的文件复制时,只粘贴数值。
- 名字用英文字母,和护照一致
- 名必须填;性别填 M 或 F。
- 日期用 DD/MM/YYYY 公历
- 不是佛历:写 1985,不写 2528。不知道出生的日或月就写 00。
- 国籍用三字母代码
- 系统只认自己的代码,比如 GBR、DEU、CHN。完整列表在下面。
- 一个文件对应一个入住日期
- 上传时选的入住日期会用于文件里的所有客人。每天、每个住宿各做一个文件。
- 每个文件最多 1,000 位客人
系统接受的全部国籍代码 (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)
三步上传文件
- 登录 tm30.immigration.go.th,点 นำเข้า Excel / Import Excel。
- 选住宿和入住日期(只能选今天或昨天),选文件,点 แสดงข้อมูลจาก Excel / Show data from Excel。
- 没有红色的行,就点 บันทึก / Save,并马上下载回执:7 天后就查不到了。
第一次用?注册账号、添加住宿的详细步骤见 TM30 指南
常见问题
这是官方的 TM30 表格吗?
不是。TM30 的官方系统和表格属于移民局。这个模板照移民局自己的 Excel 导入文件格式做,所以网上系统能直接读取。到移民局办公室交的纸质 TM30 表格是另一份文件。
谁要申报 TM30,多久内?
住宿的房东、经营者或管理人,在外国客人入住后 24 小时内申报。泰国籍客人不用申报。
BaanHost 看得到我的客人资料吗?
看不到。你下载的是空白模板,在自己电脑上填写,什么都不会发给 BaanHost。
晚了的客人能在网上补报吗?
不能。网上系统只接受今天或昨天的入住日期。更早的要到移民局办公室申报。
每天手打护照,累不累?
免费试用BaanHost 用手机摄像头扫护照,列出每位要在 24 小时内申报的外国客人,一键生成这个文件。免费试用 14 天,不用绑卡。