CRX id
gialokobpnodfmmbfofdbfnoijhlodgl
gialokobpnodfmmbfofdbfnoijhlodgl
Description from extension meta
Query every HTML table with SQL.
Image from store
Description from store
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.