and optionally export it to the clipboard or Excel, JSON, HTML, Tab or Comma delimited file formats! In an earlier article, I demonstrated how to scrape any web site with a single SQL select statement. _I love SQL and it never ceases to amaze me what can be accomplished via the power of SQL syntax. In this example, we…_hackernoon.com Scrape any Website/Service/API with a single SQL Select Statement This turned out to be a popular article so I decided I’d take a different approach that accomplishes a similar task all from within the browser. In my previous article, I used a server side (PhantomJS) to do the heavy lifting. In this example, we are going to use a bookmarklet to make the task even easier. technology browser Navigate to : _From any Web Page, click on the link (the one you dragged to your browser) to activate the Add-in_s3.amazonaws.com Web Page Scraper by @mikeptweet and drag the “Web Page Scraper” link to your browser toolbar: Then from any web page, click on the Bookmarklet ( ) to scrape the web page. that is the single mouse click NOTE: You have to allow popups as the Web Page Scraper uses an external browser window. You should see something that looks like this: The Web Page Scraper loads a few default columns but you can choose from a bunch of other columns by right clicking on the column headers: You can move columns around as well as filter and sort on the columns: Once you have the data that you need, you can export it in a bunch of formats, including Excel, JSON, HTML, TAB and Comma Delimited. Just right click on the grid to export: This is a work in progress and you many notice that performance on pages with lots of elements is slow. I’m working on this :-) Also, I am working on adding a bunch of additional features that will make this utility even more useful. I’ll be posting an article on that soon. Please recommend this and my other articles if you like it! _Read writing from Mike Parsons on Medium. Software Research Geek. Every day, Mike Parsons and thousands of other voices…_medium.com Mike Parsons - Medium Thanks.
