Exporting a report

Prev Next

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

    1. 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

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

    2. Excel will automatically parse the commas into separate columns.

It’s possible that Excel uses your regional settings for decimal/thousand separators) instead of treating a comma as the delimiter so some columns may be merged. So you don’t have to follow step 2 above each time, you can update these settings as follows:

  • Windows

    • Go to Control Panel → Region → Additional settings…

    • Find List separator and set it to , (comma)

    • Click Apply and restart Excel

  • Mac

    • Go to Apple Menu → System Settings → General → Language & Region

    • Scroll down and click Advanced….

    • Under the Numbers tab, look for Grouping and Decimal separators

      • Change the Decimal separator to . (dot)

      • Change the Grouping separator to , (comma)

    • Click OK and restart Excel



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

    1d7f5f5e-07a8-4110-b536-6baf12919c93.png

  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.

      71786cd5-29e4-44bc-bd41-6266f3eba4c7.png

  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.

    5a550163-106c-4463-a235-7131a9d16237.png

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

526393f5-d681-4b0f-9d34-69d71b3c950c.png

Tip

You can add filters to a number of different columns at once. For example, you check "Cancelled" under the "Status" column and a specific name under the "Client" column to see cancelled bookings for only that client in Excel.