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

Image via Flickr user Paul Keller

