We’ve been using Screaming Frog’s SEO Spider in the office for a few months now and, along with other spider software, it provides a great means of identifying technical and on-page issues quickly and easily.
My personal preference is to export the data to Excel where you can manipulate it however you like. In addition, you can then email the spreadsheet to a client, development team etc. once you’ve highlighted the problem you’re trying to fix.
Here are some of the Excel features and formulas that I’ve been using to generate meaningful, actionable reports.