Excel spreadsheet to pretty clips report?
January 31, 2013 3:18 PM Subscribe
I have an Excel spreadsheet with couple hundred rows: URLs, a few fields of identifying information (outlet, etc.), for media hits on the organization I work for. I need to make this into a pretty (or at least semi-legible to the computer illiterate) document that I can give to board members, senior staff, etc. What I would like is to use some form of scripting to automate this. Bonus points if the script can somehow open the URL and take a screenshot of the story so that I don't have to. I have a Mac, and both the Adobe and Microsoft suites. How do I not spend tedious hours manually doing this? Especially since I have to do it each month and quarter.