Wow! This extension is amazing when you have to do anything with tables in Firefox!
I hope it continues to see updates.
Very useful! Download tables. Change the way tables are displayed in web pages (e.g. sort, etc)
a must-have add-on for me
This is an important step towards the full potential of a Semantic Internet possible with innovative FireFox OS intelligent agent applications!
thanks man.. appreciate the hard work that went into this.. maybe if you get a chance can you please add a "tick" for persistent filters that remain after page load (or next / back links).. that would be marvelous.. but this extn is just amazing.. kudos!
Thanks! This feature had been requested before, but it's impossible to implement reliably: the page could change (some tables gone), the table could change (the same sorted column might have heading change or even disappear), and with dynamic pages, you can't just remember URL and table positions to even find the right table. Sorry but it can't be done ...
harika bir uygulama. kullanmayan çok şey kaçırır.
Just want to make a suggestion: add a "TT2 Options" button in FF "Tools" drop down menu. This would make it easier to access the options.
TT2 is a very useful and powerful add-on!
Thanks! However, it's neither practical or faster to put options in Tools. Not practical because there could be many HTML tables on a webpage, when you access "sort" from tools, which table and which column should be sorted? Not faster because many people nowadays don't have menu bar displayed. It takes 2 clicks (with much mouse traveling) just to get to TT2 options, if it were in Tools.
my son uses it, he says it's great
works nicely, I use it on may sites that forget to make their tables sortable
Thanks a lot!
works flawlessly.. :-)
A little suggestion: option to flag "table with no headers" (or nonstandard headers, undetectable by TableTools) to sort/filter since the first row.Example with "error" (first row treated as a header):http://globoesporte.globo.com/futebol/brasileirao-serie-a/
I'm Brazilian, and pt-BR of this extension confused me.
"Sort/Filter Row starts from clicked row" was translated as "Sort/filter only rows below" ("Restringir ordenação/filtro às linhas abaixo"), should be "Ordenar/filtrar a partir desta linha".
Similarly, menuitem.sort.up.only should be "Ordenar/filtrar até esta linha".
There is actually already a way of dealing with this: Right click in the first row of the table, choose TableTools2->Other->"Sort/Filter Row starts from clicked row". This will allow you to sort the entire table (albeit due to the lack of a proper first row to detect sorting direction, you have to click twice to sort again in a different direction).
My old TableTools addon had the option to allow table with no headers, but in TT2 I thought, why not allow user to set it on-the-fly for specific tables instead of going to Options to change it for all tables? Hence the context menu item.
excellent add-on! a must-have!
The main reason I use Firefox is that this add-on exists. Without it, I would consider other browsers.
Thanks for the ultimate compliment an addon could get!
Outstanding addon!!Thank you very much, it works seamlessly, Helped to very easily categorize table data into graphs pictorially. Cheers
A hidden jewel in addons.mozilla.org
Very useful and resourceful tool. Thanks you very much for this addon!
très pratique, menu contextuel intelligent et efficacité optimale pour l'export HTML->Excel
A fine tool!
Exceptional tool. Most of the table to csv like tools miserably fail even with slightly complicated html tables, so I used to use xpath to grab html and feed results to excel. TableTools2 gets it right on the spot, one even can do inplace data analysis and charting. Great great great tool.
I love Evernote, but it is very fussy when it comes to tables. This addon helps save a lot of frustration, especially if you like to change the way the data is sorted before posting it in a new note. Excellent!
I found that TableTools2 suddenly had disappeared.
Turns out that in "synchronizing extensions" between two machines, I had Book Text Mark" extension enabled.
Apparently there is an incompaibility with TT2 not showing up in the context menu any more.
Since I don't need to bookmark "a text within a long page" too often,I disabled BTM and ... TT2 is back.
Hmm, I tried installing BTM and it seemed fine. TT2 still showed up in context menu. I wonder if some other addon's actually causing BTM disabling TT2 in context menu?
Even more than I need :)
Works as intended when copying an entire table and select cells if you're using keyboard shortcuts. Deleting unnecessary columns from an entire table is much faster than: 1.) manually entering information 2.) writing an Excel macro after exporting table data with Outwit. One downside is that TableTools2 doesn't always recognize tables in the sense that right-clicking doesn't show a menu, shortcuts still seem to work (http://www.optiforms.com/elliptical.htm for example). This is a great addon for quick data entry when using the text import wizard to paste HTML data does not produce a table. You can fully customize keyboard shortcuts. In my opinion the default Ctrl+Q and then holding left mouse button while dragging over cells of interest is most useful - although quirky at times, without changing selection method...
D/L today the latest version of TT 1.6.
1 Quick Question:
Following your video tutorial,
I tried this Search:
(with a minus sign for "negative 200")
on the "Unrecognized Currency" column,
of the "Demo" Table of your site.
(JUST like you show in your video...).
But, after pressing <Enter>,
I still see ALL the Table rows...not the "selected" rows.
I would hope to see only the Table rows
with numbers "greater than minus 200" in this Column...
Maybe the word "YMB" in this Col., is interfering with the search query?
Similar "> 100" query on the last Col. of this Table,
(with the "$" dollar sign),
All other Search queries on my other Tables, work great...
XP PRO SP3
Firefox 11 (latest version).
PS: --- Update ---
Don't ask me why - my query (above) suddenly worked OK!
(probably something I was doing wrong...).
Thanks for your review & clear question/details!
The query failed you initially because the column is 'Unrecognized currency', meaning that TT2 considers the column contains strings. For strings, 'YMB...' is always bigger than '-200', that's why the query matched all rows except for the empty value row. It later worked for you because you right clicked inside that column and chose to sort the column as 'number/currency'. This tells TT2 that this column should be considered as number/currency. So now TT2 removes non-number characters and converts the cell values to numbers, and that is why the search query worked later.
That's the little detail that I believe I put inside the demo video too, but it's easy to miss it. But just remember, if TT2 fails to recognize a column correctly (some columns have exotic values or inconsistent values), just right click and choose to sort the column as whatever data type you see fit. TT2 will from now on always thinks that column is of that type (until you reload the page).
Lots of useful features and truly the best in what it says! Combining tables has some problems though, sometimes the last or the 1st entry (cell) of each combined table gets mixed up. Where should I file bug reports?
The issue with combining tables is now resolved in v1.16. Many thanks to the author for the quick fix & a wonderful addon overall.
Thanks for your review! You can contact me by clicking the "Support Email" link on right hand side below the screenshot of my addons. Please email me with examples so I can see if I could fix any issue.
I have been using it on my website www.dobrovest.ru for years
It helps work with table data in minutes, export it to Excel in seconds...