Convert an Excel booking export to CSV safely

Where to find this
Your computer › Booking export in Excel
HotelConnext › Portfolio › Open your hotel › Opening inventory › Compare bookings from a CSV

Use this when: a booking source downloads an XLS or XLSX file. HotelConnext currently accepts CSV files only; renaming an Excel file to “.csv” does not convert it.

Step 1 — Keep the original file #

Save the source export unchanged. Open a separate copy in Excel or another spreadsheet editor. Confirm the export includes the future bookings and the columns you need: original booking number, arrival, departure, room, quantity and status.

Step 2 — Select the correct worksheet #

If the workbook has several sheets, select the sheet containing the booking rows. A CSV save normally exports only the active sheet. If important bookings are on another sheet, prepare a separate CSV for that sheet and review it independently.

Step 3 — Check booking numbers and dates before saving #

Compare a few original booking numbers with the source. If a long number has become scientific notation or lost digits or leading zeros, stop: changing its display format afterward may not recover the original value. Re-export it as text or enter the affected booking manually. Check whether dates are day/month/year, month/day/year or year-month-day.

Step 4 — Save a CSV copy #

Choose Save As or Save a Copy and select CSV, preferably CSV UTF-8 when available. Give the copy a new name that identifies the source and export date. Do not overwrite the original XLS/XLSX. The spreadsheet may warn that CSV keeps the active sheet and does not preserve workbook formatting; verify the saved values before using it.

Step 5 — Compare in HotelConnext #

Open Opening inventory → Compare bookings from a CSV. Choose the source and the CSV copy. The page accepts comma or semicolon separators and lets you map the source’s column names. Check the sample rows, especially booking numbers, dates, grouped rooms and cancellations. The file must be under 2 MB and contain at most 2,000 data rows; one comparison can include at most 500 booking numbers. Split a larger export into reviewed batches.

Expected result: the preview matches the unchanged source export. Confirm only after you have reviewed every proposed room-night change. If the CSV copy cannot preserve the original identifiers or dates, use manual entry and keep the source file for comparison.

Further help: Microsoft explains saving a workbook as CSV and preserving long numbers and leading zeros.

Updated on November 22, 2026

What are your feelings

  • Happy
  • Normal
  • Sad