---
title: Reservation Import
slug: reservation-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**
- decimal separator: **dot**

## Fields

| **Field Name**        | **Description**                                                                                                                                                                                           |
| --------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ID                    | unique identifier - if another import contains the same ID, the record will be updated<br />**recommended**                                                                                               |
| reservationId         | in case you want to reference a specific reservation in the hotelsoftware to be updated (use hotelsoftware internal room reservation IDs only in this field)<br />**DO NOT USE**                          |
| guestProfileId        | only populate with hotelsoftware internal guest profile ID if you want to associate this reservation with a specific guest profile<br />**DO NOT USE**                                                    |
| travelAgentId         | only populate with hotelsoftware internal guest profile ID if you want to associate this reservation with a specific travel agent profile<br />**DO NOT USE**                                             |
| title                 |                                                                                                                                                                                                           |
| firstName             |                                                                                                                                                                                                           |
| name                  | last name                                                                                                                                                                                                 |
| street                |                                                                                                                                                                                                           |
| zipCode               |                                                                                                                                                                                                           |
| city                  |                                                                                                                                                                                                           |
| countryCode           | ISO 2-character country code                                                                                                                                                                              |
| phone                 | preferably in international format (e.g. +43 660 737 88 90)                                                                                                                                               |
| email                 |                                                                                                                                                                                                           |
| nationality           | ISO 2-character country code                                                                                                                                                                              |
| language              | ISO 2-character language code                                                                                                                                                                             |
| birthDate             | any valid date (unparsable dates will be skipped on import)                                                                                                                                               |
| requestExpirationDate | any valid date (unparsable dates will be skipped on import)                                                                                                                                               |
| arrivalDate           | any valid date<br />**required**                                                                                                                                                                          |
| departureDate         | any valid date<br />**either departureDate or numberOfNights is required**                                                                                                                                |
| numberOfNights        | any valid date (will only be used if no departureDate is set)<br />**either departureDate or numberOfNights is required**                                                                                 |
| roomType              | hotelsoftware internal room type ID (will only be used if no roomNumber is set)<br />**either roomNumber or roomType is required**                                                                        |
| roomNumber            | if neither roomNumber nor roomType is set - we will default it to a random room type<br />**either roomNumber or roomType is required**                                                                   |
| ratePlan              | hotelsoftware internal rate plan ID (the default rate plan will be used if this value is not set)<br />**required**                                                                                       |
| internalComment       |                                                                                                                                                                                                           |
| guestComment          |                                                                                                                                                                                                           |
| numChildren           |                                                                                                                                                                                                           |
| childrenAge           | comma separated list of children ages<br />*make sure to configure the age categories before doing the import - if no age categories do exist at time of import, all children will be imported as adults* |
| reservationSource     | name of the reservation source - we usually recommend inserting the name of the old PMS into this field                                                                                                   |
| numAdults             | **required**                                                                                                                                                                                              |
| totalAmount           | total reservation amount in **english number format** (e.g. 513.79) in the hotels default currency<br />*no currency signs, no currency codes, no commas*                                                 |
| prepaymentAmount      | prepayment amount requested from the guest (for informational purposes only)                                                                                                                              |
| confirmationCode      | can be used to group multiple reservations together to a single group reservation                                                                                                                         |

### Valid Date Formats

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