---
title: Compare a CSV with opening bookings
description: "**Where to find this** HotelConnext › Portfolio › Open your hotel › Opening inventory › **Compare bookings from a CSV** **Before you start:** export future bookings from one source and save a CSV copy. The current uploader accepts CSV, not…"
url: "https://docs.hotelconnext.com/docs/compare-csv-bookings/"
updated: "2026-11-22"
category: Existing bookings
---

# Compare a CSV with opening bookings

**Where to find this**
HotelConnext › Portfolio › Open your hotel › Opening inventory › **Compare bookings from a CSV**

**Before you start:** export future bookings from one source and save a CSV copy. The current uploader accepts CSV, not XLS or XLSX. It accepts comma or semicolon separators. The file may use the source’s own column names.

### Step 1 — Choose the source and upload its CSV

Open **Opening inventory → Compare bookings from a CSV**. Select the booking source and upload its CSV file. You can download the simple example on this page if you need a model.

![Step 1 — CSV upload row showing source, separator choice, file picker and sample download](https://docs.hotelconnext.com/wp-content/uploads/2026/11/CSV-upload-row-showing-source-separator-choice-file-picker-and-sample-download.png)
Step 1 — CSV upload row showing source, separator choice, file picker and sample download

### Step 2 — Match the booking columns

Check the detected separator and sample rows. Match the columns for booking number, check-in, check-out and room. Select quantity and status columns when the export contains them.

![CSV preview with mapped booking number, dates, room and status columns.](https://docs.hotelconnext.com/wp-content/uploads/2026/11/CSV-sample-and-column-mapping-controls-including-date-format.png)
Step 2 — CSV sample and column mapping controls, including date format

### Step 3 — Check date formats and room names

Choose the date format actually used in this file. Map each source room label to your HotelConnext room type.

### Step 4 — Classify booking statuses

If there is a status column, map each value to **Active booking**, **Explicitly cancelled booking**, or **Exclude and review separately**. Choose cancellation only when the source explicitly says cancelled.

![](https://docs.hotelconnext.com/wp-content/uploads/2026/11/Reservation-status-mapping-and-room-label-mapping-controls.png)
Step 4 — Reservation status mapping and room-label mapping controls

### Step 5 — Compare changes before confirming

Click **Compare bookings and availability**. Review new, modified, cancelled and unchanged counts and the room-night impact. Confirm only after the proposed changes match the source.

![Reviewed CSV changes and availability impact before confirmation.](https://docs.hotelconnext.com/wp-content/uploads/2026/11/Comparison-result-with-new-modified-cancelled-unchanged-and-room-night-impac.png)
Step 5 — Comparison result with new, modified, cancelled, unchanged and room-night impact

**Important:** a booking number missing from a later file is never treated as a cancellation. A cancellation for an unknown number creates a review exception and releases no room. Guest and payment columns stay in your browser during this comparison.
