How to Export Reservations from Guestcentric
Need help with Guestcentric > Reservations > Export
To help you analyze large datasets—such as six-month or annual reservation reports—faster and more efficiently, Guestcentric exports reservation data in CSV format. Follow the steps below to export your data and open it cleanly in Microsoft Excel without formatting issues.
Export your data from Guestcentric
1. Log in to the Guestcentric extranet and navigate to the Reservations tab.
2. Select the Booking Range you want to analyze.
3. Click the Export button to download the file.
4. Leave the downloaded .csv file in your Downloads folder.
Tip: Do not double-click to open or save the file directly yet, as Excel may misread special characters or column breaks.

Import and format the CSV in Excel [If using Excel]
1. Open a new, blank workbook in Microsoft Excel.
2. In the top menu, go to the Data tab and select Get Data (or Get External Data) > From Text/CSV
3. Select the exported .csv file from your Downloads folder and click Import.
4. In the preview window, verify or configure the following settings so your data displays properly:
- Data Type: Delimited
- File Origin: 65001: Unicode (UTF-8) (prevents broken accents or special characters)
- Delimiter: Comma
- Column Data Format: General
5. Click Load (or Finish) to import the data into your spreadsheet.






Your report is now properly formatted and ready to be saved as a standard Excel workbook (.xlsx).
Notes:
- This e-card aims to help speed up reporting workflow and avoid common Excel formatting issues
- For further details on reservation reports and data exports, please reach out to our Support team.