ADVERTISEMENT
|

How to Extract Any Web Page Information and Export it to Excel

  • 62K
    READS
How to Extract Any Web Page Information and Export it to Excel

Some tools are just so awesome that I can’t imagine I haven’t used them by now. My recent discovery is just awesome and I can’t wait to share it with you!

OutWit Hub is a cool FireFox addon that allows you to extract any web page information and export it to our favorite Excel for easier management and organization.

When launched, the tool shows you different kinds of data that can be extracted from the current webpage:

  • all the images on the page,
  • all page links,
  • email addresses,
  • page text,
  • RSS feeds found,
  • page tables, etc.

OutWit

Let me demonstarte its power using just a few examples:

1. Extract page lists:

Let’s try to extract the tool FAQ using two possible methods:

  • Navigate to that page and click the tool icon in the navigation bar;
  • Choose "Lists" and export it to Excel.

OR

  • Let the tool "guess" what to extract: click on "guess" and see all possible data compiled in the form of a handy table.

Outwit - extract lists

2. Extract all page images

  • Navigate to any page containing a lot of images;
  • Click the tool icon and then choose "images";
  • See the detailed table containing:
    • each image thumbnail,
    • image source URL,
    • image dimensions,
    • image alt text;
    • image file names.

Outwit - extract images

3. Scrape Google Results

This one is a bit more complicated but it demonstrates how flexible and customizable the tool can be (kindly shared by Dale Stokdyk)!

First, you will need to create your own scraper, here’s a screenshot which pretty much says that all: just do what is shown there:

Google Scraper:

snippets to create a google scraper with outwit hub

Here is a detailed info on creating your first scraper as well as the post where I found this cool tip.

  • Set Google to show 100 results per page (to have more data to export and analyze);
  • Search for any phrase;
  • Click the tool icon and click "scraper".

Outwit - Scrape Google results

ADVERTISEMENT
ADVERTISEMENT
Ann Smarty

Ann Smarty

Brand amd Community Manager at Internet Marketing Ninjas

Ann Smarty is the blogger and community manager at Internet Marketing Ninjas. Ann's expertise in blogging and tools serve as ... [Read full bio]

Advertisement