---
title: Guest Profile Import
slug: guest-profile-import
createdAt: 2021-07-15T06:19:21.000Z
---

## Data Requirements

- CSV
- UTF-8
- Separator ; (Semicolon)
- Record Spacer \n (New Line)
- Escape \ (Backslash)
  e.g. \\; will escape a contained semicolon
- Quotes: **no**
- First record as header: **yes**

## Fields

| **Field Name** | **Description**                                                                                                                                                                                            |
| -------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ID             | unique identifier - if another import contains the same ID, the record will be updated                                                                                                                     |
| guestProfileId | in case you want to reference a specific guestProfile in the hotelsoftware to be updated (use hotelsoftware internal guest profile IDs only in this field)                                                 |
| company        |                                                                                                                                                                                                            |
| profession     |                                                                                                                                                                                                            |
| title          |                                                                                                                                                                                                            |
| firstName      |                                                                                                                                                                                                            |
| lastName       |                                                                                                                                                                                                            |
| gender         | anything that starts with "m" or "M" will be considered **Male**<br />anything that starts with "f", "F", "w" or "W" will be considered **Female**<br />all other values will be considered **Undeclared** |
| nationality    | ISO 2-character country code                                                                                                                                                                               |
| language       | ISO 2-chracter language code                                                                                                                                                                               |
| birthDate      | any valid date (unparsable dates will be skipped on import)                                                                                                                                                |
| comment        |                                                                                                                                                                                                            |
| street         |                                                                                                                                                                                                            |
| city           |                                                                                                                                                                                                            |
| zipCode        |                                                                                                                                                                                                            |
| countryCode    | ISO 2-character country code                                                                                                                                                                               |
| email          |                                                                                                                                                                                                            |
| phone          | preferably in international format (e.g. +43 660 737 88 90)                                                                                                                                                |
| mobile         | preferably in international format (e.g. +43 660 737 88 90)                                                                                                                                                |
| fax            | preferably in international format (e.g. +43 660 737 88 90)                                                                                                                                                |
| newsletter     | values of (case insensitive) "true", "y", "t", "on" or "yes" will be considered **true**                                                                                                                   |
| categories     | **DO NOT USE**                                                                                                                                                                                             |
| relationships  | **DO NOT USE**                                                                                                                                                                                             |

### Valid Date Formats

- dd.MM.yyyy
- dd/MM/yyyy
- yyyy-MM-dd
- dd-MM-yyyy