An unofficial blog that watches Google's attempts to move your operating system online since 2005. Not affiliated with Google.

Send your tips to gostips@gmail.com.

May 24, 2008

Filter and Sort Tables from Web Pages

TableTools is a Firefox extension that lets you sort, filter and export tables from any web page. After installing the extension and restarting Firefox, find a web page that includes tables (this search might help) and right-click on a table to find a lot of interesting features:

* sort a column, depending on the type of elements (text, numbers, dates)
* filter the rows of a table by selecting elements from a drop-down or by entering your search terms, like in the screenshot below. You can even enter regular expression to filter more complex patterns. After typing the query, press Enter or click outside the active input box.
* export the entire table as tab-delimited text, HTML code or just the filtered rows


This might be helpful if you want to insert some partial data from a table in a document, a site or in Google Spreadsheets, which only supports filtering using a limited gadget. For Google Spreadsheets, choose the option to copy the rows as tab-delimited text.

6 comments:

  1. Wouldn't this screw up some pages that use tables for styling? (Haven't tried it yet so I don't know). I wish people would start using real CSS and stop using tables to style.

    ReplyDelete
  2. In my limited testing, I noticed it works well and it doesn't ruin any page because you must explicitly enable filtering for each table.

    ReplyDelete
  3. Great tip!

    I've cursed to those crazy wiki-comparisons a bunch of times, and this really is the perfect way to make it easier to sort them out.

    ReplyDelete
  4. Thanks a ton!
    This worked like a charm!

    ReplyDelete
  5. sounds incredibly useful but cannot be found at AMO :(

    Does this addon still exist somewhere?

    ReplyDelete