Overview
What is Guest Data Export?
Guest Data Export is a feature that allows you to download guest information collected during pre-check-in or check-in (such as name, address, ID verification images, etc.) in CSV format and image files.
Main Use Cases
Maintaining guest registers (for legal compliance)
Audit purposes
Managing identity verification information
Detail
How to Access
You can access the Guest Data Export feature using the following steps:
Click [Import & Export] from the dashboard menu.
Select [Export Guest Data].
Export Methods
Guest data can be exported using the following two methods:
Monthly Data
You can export guest data by month based on the check-in date.This is mainly used for record keeping and submission purposes.
Daily Data
You can export guest data by day based on the check-out date.This is useful when you want to quickly check recent guest data.
Usage Requirements (Plan / User Permissions)
The ability to export guest data depends on the export method and your plan or user permissions.
Daily Data Export requires:
AirHost ONE HMS Premium Plan
Administrator permissions
Make sure your plan and user role meet these requirements before attempting a daily export.
Method | Plan Requirement | User Permission Requirement |
Monthly Data | One of the following plans must be purchased and activated for the property: |
|
Daily Data | Both of the following conditions must be met: |
|
⚠️ Users with Staff, Cleaner, or Owner-Contract Viewing permissions cannot use this feature.
Export Monthly Data
You can export guest data on a per-month basis using the check-in date. This is mainly used for record-keeping or submission purposes.
Features:
Data for the previous month is generated on the first day of each month.
Data can be downloaded per property.
Includes CSV data as well as ID verification images, signatures, and other image data.
Current month’s data cannot be downloaded.
You can retrieve up to 3 months of data.
Note:
From a privacy and security perspective, the exportable period is limited to 3 months.
Please make sure to download the data within this period and store it securely.
Export Method
In the [Monthly Data Export] tab, click [Export Data] located to the right of the month and facility you want to export. The download will then start automatically.
|
Once the download is complete, a folder in .zip format will be saved to your device. |
 |
Inside the zip folder, you will find a CSV file containing the list of guest data, along with folders organized by check-in codes. |
 |
Inside each folder organized by check-in code, you will find image files such as guest identification documents and signatures. |
 |
Export Daily Data
Data is based on check-out date and includes guests who checked out the previous day.
Covers the past 30 days.
All facilities are included; you cannot filter by individual facility.
Data is generated around 3:00 AM JST daily. Any updates to guest information after generation will not be reflected; such changes appear in the monthly data.
How to export:
In the [Export Daily Data] tab, click [Export Data] displayed to the right of the check-out date you want to export. The download will then start automatically.
|
Once the download is complete, a CSV file will be saved. |
 |
Fields Included in the CSV Output
The data output in the CSV file differs between monthly data and daily data.
Please refer to the table below for details.
Item | Description | Monthly Data | Daily data |
AirHost Booking ID | AirHost reservation number | 〇 | 〇 |
Listing ID | AirHost Facility ID | 〇 | 〇 |
Listing Name | AirHost Facility Name | 〇 | 〇 |
Room# | Room type name #room name | 〇 | 〇 |
Booking ID | Reservation number | 〇 | 〇 |
Checkin Date | Check-in date | 〇 | 〇 |
Check-in Time | Check-in time | 〇 | 〇 |
Checkout Date | Checkout date | 〇 | 〇 |
Checkout Time | Checkout time | 〇 | 〇 |
Number of nights to stay | Number of nights | 〇 | 〇 |
The settings in the guest form "Defined items" | Defined items (Examples: address, phone number, email address, passport number, etc.) | 〇 | 〇 |
The settings in the guest form "Optional item" | Custom fields (Examples: car license plate number, whether or not pets are brought along, etc.) | 〇 | ✖ |
About Country Codes in “Nationality”
In the downloaded CSV file, the “Nationality” column uses country codes.
Below is a list of country names corresponding to each country code.
* Click “▶” to display the full list.
Country Code & Country Name List
Country Code & Country Name List
Country code | Country name (in Japanese) | Country name (in English) |
国コード | 国名（日本語） | 国名（英語） |
AF | アフガニスタン | Afghanistan |
AL | アルバニア | Albania |
DZ | アルジェリア | Algeria |
AD | アンドラ | Andorra |
AO | アンゴラ | Angola |
AG | アンティグア・バーブーダ | Antigua and Barbuda |
AR | アルゼンチン | Argentina |
AM | アルメニア | Armenia |
AU | オーストラリア | Australia |
AT | オーストリア | Austria |
AZ | アゼルバイジャン | Azerbaijan |
BS | バハマ | Bahamas |
BH | バーレーン | Bahrain |
BD | バングラデシュ | Bangladesh |
BB | バルバドス | Barbados |
BY | ベラルーシ | Belarus |
BE | ベルギー | Belgium |
BZ | ベリーズ | Belize |
BJ | ベナン | Benin |
BT | ブータン | Bhutan |
BO | ボリビア | Bolivia |
BA | ボスニア・ヘルツェゴビナ | Bosnia and Herzegovina |
BW | ボツワナ | Botswana |
BR | ブラジル | Brazil |
BN | ブルネイ | Brunei |
BG | ブルガリア | Bulgaria |
BF | ブルキナファソ | Burkina Faso |
BI | ブルンジ | Burundi |
CV | カーボベルデ | Cabo Verde |
KH | カンボジア | Cambodia |
CM | カメルーン | Cameroon |
CA | カナダ | Canada |
CF | 中央アフリカ共和国 | Central African Republic |
TD | チャド | Chad |
CL | チリ | Chile |
CN | 中国 | China |
CO | コロンビア | Colombia |
KM | コモロ | Comoros |
CG | コンゴ共和国 | Congo |
CD | コンゴ民主共和国 | Democratic Republic of the Congo |
CR | コスタリカ | Costa Rica |
CI | コートジボワール | Côte d'Ivoire |
HR | クロアチア | Croatia |
CU | キューバ | Cuba |
CY | キプロス | Cyprus |
CZ | チェコ | Czechia |
DK | デンマーク | Denmark |
DJ | ジブチ | Djibouti |
DM | ドミニカ国 | Dominica |
DO | ドミニカ共和国 | Dominican Republic |
EC | エクアドル | Ecuador |
EG | エジプト | Egypt |
SV | エルサルバドル | El Salvador |
GQ | 赤道ギニア | Equatorial Guinea |
ER | エリトリア | Eritrea |
EE | エストニア | Estonia |
SZ | エスワティニ（スワジランド） | Eswatini |
ET | エチオピア | Ethiopia |
FJ | フィジー | Fiji |
FI | フィンランド | Finland |
FR | フランス | France |
GA | ガボン | Gabon |
GM | ガンビア | Gambia |
GE | ジョージア | Georgia |
DE | ドイツ | Germany |
GH | ガーナ | Ghana |
GR | ギリシャ | Greece |
GD | グレナダ | Grenada |
GT | グアテマラ | Guatemala |
GN | ギニア | Guinea |
GW | ギニアビサウ | Guinea-Bissau |
GY | ガイアナ | Guyana |
HT | ハイチ | Haiti |
HN | ホンジュラス | Honduras |
HU | ハンガリー | Hungary |
IS | アイスランド | Iceland |
IN | インド | India |
ID | インドネシア | Indonesia |
IR | イラン | Iran |
IQ | イラク | Iraq |
IE | アイルランド | Ireland |
IL | イスラエル | Israel |
IT | イタリア | Italy |
JM | ジャマイカ | Jamaica |
JP | 日本 | Japan |
JO | ヨルダン | Jordan |
KZ | カザフスタン | Kazakhstan |
KE | ケニア | Kenya |
KI | キリバス | Kiribati |
KW | クウェート | Kuwait |
KG | キルギス | Kyrgyzstan |
LA | ラオス | Laos |
LV | ラトビア | Latvia |
LB | レバノン | Lebanon |
LS | レソト | Lesotho |
LR | リベリア | Liberia |
LY | リビア | Libya |
LI | リヒテンシュタイン | Liechtenstein |
LT | リトアニア | Lithuania |
LU | ルクセンブルク | Luxembourg |
MG | マダガスカル | Madagascar |
MW | マラウイ | Malawi |
MY | マレーシア | Malaysia |
MV | モルディブ | Maldives |
ML | マリ | Mali |
MT | マルタ | Malta |
MR | モーリタニア | Mauritania |
MU | モーリシャス | Mauritius |
MX | メキシコ | Mexico |
MD | モルドバ | Moldova |
MC | モナコ | Monaco |
MN | モンゴル | Mongolia |
ME | モンテネグロ | Montenegro |
MA | モロッコ | Morocco |
MZ | モザンビーク | Mozambique |
MM | ミャンマー | Myanmar |
NA | ナミビア | Namibia |
NP | ネパール | Nepal |
NL | オランダ | Netherlands |
NZ | ニュージーランド | New Zealand |
NI | ニカラグア | Nicaragua |
NE | ニジェール | Niger |
NG | ナイジェリア | Nigeria |
NO | ノルウェー | Norway |
OM | オマーン | Oman |
PK | パキスタン | Pakistan |
PW | パラオ | Palau |
PA | パナマ | Panama |
PG | パプアニューギニア | Papua New Guinea |
PY | パラグアイ | Paraguay |
PE | ペルー | Peru |
PH | フィリピン | Philippines |
PL | ポーランド | Poland |
PT | ポルトガル | Portugal |
QA | カタール | Qatar |
RO | ルーマニア | Romania |
RU | ロシア | Russia |
RW | ルワンダ | Rwanda |
SA | サウジアラビア | Saudi Arabia |
SN | セネガル | Senegal |
RS | セルビア | Serbia |
SG | シンガポール | Singapore |
SK | スロバキア | Slovakia |
SI | スロベニア | Slovenia |
ZA | 南アフリカ | South Africa |
KR | 韓国 | South Korea |
ES | スペイン | Spain |
SE | スウェーデン | Sweden |
CH | スイス | Switzerland |
TH | タイ | Thailand |
TR | トルコ | Turkey |
UA | ウクライナ | Ukraine |
AE | アラブ首長国連邦 | United Arab Emirates |
GB | イギリス | United Kingdom |
US | アメリカ | United States |
Frequently Asked Questions (FAQ)
Q. Can I export data after the 3-month retention period has passed?
A. Yes, it is available for a fee, limited to data within the past 1 year.
Price:
¥ 3,300 (10% tax included) / 1 month
If you would like to request restoration, please contact support via chat and provide the following information:
Year and month you want to restore
Property name you want to restore
*Data older than 1 year cannot be restored.
* Discounts are not available.
Q. Can I export guest data after unlinking from an OTA?
A. You can only export data for OTA reservations that were still linked at the time the data was generated.
When the OTA connection is removed, the reservations are deleted from AirHost.
Therefore, if the OTA is already unlinked at the time the guest data is generated (e.g., on the first day of the month for monthly data), reservation data from that OTA will not be included in the export.
However, data that has already been generated will not be deleted, even if the OTA connection is removed afterward.