Is there a quick and easy way to create an excel spreadsheet with a list of all blog content and it's SEO factors i.e. URL, title, description, etc.?  I know I could use screaming from to get the entire site but is there a way to just get the content on the blog?

I have a client that owns one franchise location of a franchise company with multiple locations.  They have one large site with each location owning it's own page on the site, which I feel is the best route.  The problem is that each location page has basically duplicate content on each page resulting in like 80 pages of duplicate content. I'm looking for advice on how to create unique content for each location page?  What types of information can we write about to make each page unique, because you can only twist sentences and content around so much before it just all sounds cookie cutter and therefore offering little value.

I have some clients that recently got hit by "Penguin" they have several less than desireable backlinks that could be the issue?  Does anyone have any suggestions on getting these removed?  What are the odds that a webmaster on these spammy sites are going to remove them, and is it worth the time and effort?