You should export the result of a report search to a spreadsheet when you want to make your own data processing of the search result.
In order to export a search you must have assigned the Show reports permission.
How to do it:
• Click on Reports in the main menu to open the Reports module
• Right click on the search in question in the search folders to the left

• Select Export to Excel
• This will create a Microsoft Excel file which can be stored locally