SQLizer

Query every HTML table with SQL.

SQLizer: Query HTML tables with SQL

SQLizer is a powerful Chrome extension that enables you to query HTML tables on any web page using the popular database language SQL. Simply select the text within a table, click the SQLizer button, and write your SQL query to retrieve the desired data. The extension utilizes a local SQLite database (Web SQL) for offline execution and supports various SQL features including joins, aggregate functions, nested queries, and more. SQLizer also offers features like auto completion, table renaming for joins, and the ability to export tables to files in SQL format.

Download

Extension stats

This extension was removed from Chrome Web Store on 2022-05-06

By: Johannes Schildgen

Users: 1,000+

Rating: 4.50

(6)

Version: 1.2.1 (Last updated: 2017-11-13)

Creation date: 2017-11-13

Risk impact: High risk impact

Risk likelihood:

High risk likelihood

Manifest version: 2

Permissions:

tabs
http://*/*
https://*/*

Size: 36.92K

Other platforms

Not available on Android

Not available on Firefox

Not available on Edge

Want to check extension ranking and stats more quickly for other Chrome extensions? Install Chrome-Stats extension to view Chrome-Stats data as you browse the Chrome Web Store.

Extension summary

Analyze keywords

The SQLizer allows to query every HTML table on a web site with the database language SQL.

Select a piece of text in the table you want to query, e.g. with a double click on a word
On the top right of your Google-Chrome window click the SQLizer button
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:

User reviews

it actually pulls some query hey!

dancun chiriga, 2016-05-08

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.

by FM-96, 2015-07-11

Endlich hemmungslos Datenanalyse betreiben ohne sich in R oder Excel einzuarbeiten. Da wünscht man sich doch das Tabellenlayout aus den 90ern zurück.