CSV import and export is a Hotel Booking Pro workflow. Validation is separate from confirmation so staff can inspect the proposed records before any booking is created.
Validate and import
- Open Hotel Booking → Booking Import / Export.
- In Import bookings, choose a UTF-8 CSV file.
- Select Validate CSV.
- Review row count, valid rows, errors, room code, stay, status, total and paid amount in Import preview / result.
- Correct the source file and validate again if required.
- Create a database backup, then select Confirm and import bookings once.
- Review the imported, skipped and failed counts and the recent import history.
Validation never creates bookings. Confirmation rechecks capacity and availability per row, skips existing references and does not send booking or invoice emails for imported historical records.
Export
Choose the approved date, booking-status and payment-status filters in the Export bookings section, then select Export CSV. Treat the downloaded file as personal data and store it only in an approved location.
Verify and recover
Open the affected bookings and compare their snapshots with the source. If an import partially fails, preserve the batch result and fix only failed rows; existing references are intentionally skipped. Do not upload a spreadsheet with formula payloads or unredacted guest data to support.