Query every HTML table with SQL.
The SQLizer allows to query every HTML table on a web site with the database language SQL.
1. Select a piece of text in the table you want to query, e.g. with a double click on a word
2. On the top right of your Google-Chrome window click the SQLizer button
3. Write your SQL query and execute it
The whole script is executed offline using a local SQLite database (Web SQL).
SQLizer supports everything SQLite supports: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, IN, Aggregate Functions, Joins, Nested Queries, ...
New in Version 1.2.1:
- Joins! Tables can be renamed, so that multiple tables from the same website, different websites, and different browser tabs can be joined.
- Auto completion (Ctrl+Space) also for table names
New in Version 1.1:
- Dots in Column Names are removed
- Integers and real numbers are now stored as numbers (not as text anymore)
- Support for tables where multiple columns have the same name
- Auto completion with Ctrl+Space (column names and SQL keywords)
- Support for <td> columns as first columns in a row
- Export table to file (SQL CREATE and INSERT statements)
Latest reviews
- (2016-05-08) dancun chiriga: it actually pulls some query hey!
- (2015-07-11) FM-96: Nice idea, bad execution. This extension can't handle <th> cells and also has a problem with periods in the column name. Since most of Wikipedia's tables have those, that makes it rather useless for me.
- (2014-09-08) Manuel Dossinger: Endlich hemmungslos Datenanalyse betreiben ohne sich in R oder Excel einzuarbeiten. Da wünscht man sich doch das Tabellenlayout aus den 90ern zurück.
Latest issues
- (2018-06-19, v:1.2.1) Jeff Bowles: wrong values from some cells
Hello - this is a fantastic idea and I can see lots of uses for it. One problem I found is that some cells containing text like "H-1" are returning integers rather than text. I even tried the cast() function, which is accepted syntactically, but did not change the results. I can supply the URL I was looking at if that helps. - (2018-01-10, v:1.2.1) D H: Joins
Hi Nice work, but I don't seem to be able to make use of the join function. It's not clear to me how this works.(I might be a bit dense here) Would you explain the usage of multiple tables please. - (2016-10-27, v:1.0.5) link to local database
this is very good extension, and it will be great idea if you link many queries from many tabs together in a local database or to be linked to a personal server database. if possible, please contact me on [email protected] - (2015-11-06, v:1.0.5) Christopher Ottersen: insert
I am trying to pull tables off of wikipedia, would it be possible to get a list of insert statements from a table? - (2015-04-23, v:1.0.5) FM-96: <th> cells and periods in the column names
This extension apparently can't handle <th> cells, and I think periods in the column name throw it off too. To see what I mean, try to get only the titles from the Season 1 table here: http://en.wikipedia.org/wiki/List_of_The_Legend_of_Korra_episodes