GuestCentric Support PageGuestCentric Support Page

menutoggle

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.

We use first-party and third-party cookies for analytical purposes and to show you advertising related to your preferences, based on your browsing habits and profile. You can configure or block cookies by clicking on “Cookies settings”. You can also accept all cookies by clicking on “Accept all cookies”. For more information, please consult our Cookie Policy.

Cookies Settings:

Cookies and other similar technologies are an essential part of how our Platform works. The main goal of cookies is to make your browsing experience easier and more efficient and to improve our services and the Platform itself. Likewise, we use cookies to show you targeted advertising when you visit third-party websites and apps. Here, you will find all the information on the cookies we use. Furthermore, you will be able to activate and/or deactivate them according to your preferences, except for any cookies that are strictly necessary for the functioning of the Platform. Keep in mind that blocking certain cookies may affect your experience on the Platform, as well as its functioning. By clicking “Confirm preferences”, the cookies selection you have made will be saved. If you have not selected any options, clicking this button will be the same as blocking all cookies. For more information, please consult our Cookie Policy.

Cookies Settings
Accept all Cookies