How do I automate a url scraping task?

I have an Excel sheet with a list of 17k url hyperlinks. I need to automate the task of clicking each linking and scraping the data from the resulting web pages into an excel sheet. What is the best free method of doing this on a mac in OSX?