Exporting a report

You can export your report and save it on your computer by clicking the save button. Most reports are downloaded as an Excel spreadsheet file type, though some reports are downloaded as a CSV file (Comma Separated Values) which is also viewable through your default spreadsheet application as per normal.

Steps

1. Run your desired report (see Running a report article)

2. Click the Save Icon above the report and select Excel (or CSV). The report should now be available in your Downloads bar or folder.
   
   

CSV files

A CSV (Comma-Separated Values) file is just plain text with data separated by commas (or sometimes semicolons). Excel recognizes this format and lays the data out into rows and columns.

There are two main ways to do it:

1. Double-click the file

   • If Excel is your default program for .csv files, just double-click the file and it will open directly in Excel.

2. Open from Excel

   • Open Excel → go to File > Open → browse to your .csv file → select it.

   • Excel will automatically parse the commas into separate columns.

Advanced filtering in Microsoft Excel

You may wish to filter your report based on more conditions than shown on the online report. You can easily do this by exporting to a spreadsheet application such as Microsoft Excel.

Steps

1. Open your report in Microsoft Excel (ensure it has been exported in the Excel or CSV format)

2. Select the entire top row of the report by clicking on the left edge of the row
   
   
   
   

3. Navigate to the Data tab and select the Filter option

   1. Dropdown arrows will now appear above all your columns which will let you filter by any value stored. For example, we could filter by Paid, Cancelled or Unattended in the Status column.
      
      
      
      

4. Click the arrow above your column of choice and tick the filter values. In this case, we will just tick "Cancelled" to show only the Cancelled Bookings.
   
   
   
   

5. Now the Report has been filtered to only show Cancelled Bookings