Exporting your data from aleno to Excel

With aleno, it’s super easy for you to export your guest data and work with it.

On your relatIn you can export customer data:

 excel_export_EN1

 Via reportIn you’ll be able to export booking/reservation data:

 excel_export_EN2

Clean export

To provide quick access to your exported data, the best way to open the data as an Excel file is in following order:
(images provided from a german Excel program)

  1. open an new and empty Excel file
  1. select the category "Data”

 Gästedatenexport_1 

  1. click on "Get external data" and then select "From text":

 excel_export_1

  1. select your file exported by aleno in the downloads.
  1. change the file origin to Unicode (UTF-8)

 Gästedatenexport_3

  1. your Excel file can be displayed as a tab stop or in other delimiters such as a semicolon or via "Other" as a pipe (|):

 Gästedatenexport_4

Click on "Finish" to display the export cleanly and according to your wishes.

And that's it!

Filter function

To find what you are looking for, you can activate the filter function in the file:

 Gästedatenexport_5

You can now filter out which of your guests have signed up for your newsletter for example and use your data for specific marketing! Have fun!