You can search in pretty much every column by clicking on the name of the column and then on the triangle that displays. The options for the column display. Click on Search to enter a query.
You can export a table and hide empty rows from the hamburger menu in the top left of the table. Exporting from the hamburger menu will only export the relevant table.
You can export the whole view by clicking on the Download button in the task bar. This exports all of the tabs in the view to a multi-tab Excel spreadsheet.