I have a lot of tools in my SEO toolbelt, but I only consider a few of them to be absolutely necessary - Link Prospector from Garrett French is one of them. LP takes all the grunt work out of advanced queries and scraping SERPs. But just like when you prospect by hand, you are going to find some garbage that you will need to remove from your data set.
By using Excel tables with filters and throwing the filtered data into a pivot tables - you can create easily navigable documents filled with high value link opportunities.
Here’s a step by step process to cut down Link Prospector exports to just the meat and potatoes
I have a tool crush on Screaming Frog. I consider it one of the keys to scalability and I don’t know what I would do without it. Dan Sharp deserves a medal because his tool has saved SEOs countless hours of manual work. Screaming Frog can be used for a variety of things, but my new favorite use is for identifying internal link building opportunities.