How do I extract data from a website into Excel on a Mac?
by ldinour - 4/16/13 2:57 PM
I am trying to create a database from a set of public comments submitted via regulations.gov. There will be over 240,000 separate comments (each has a separate webpage), and I do not have the time to copy and paste the information from each into an excel spreadsheet. Is there a way to extract the data in one action? I've tried creating a query in Excel, but it didn't work. I'm using Excel 2011 for Mac, OS X version 10.8.3, and Firefox. Thank you so much for your help!