QUERYX ADD-ON
for Google Spreadsheets
QUERYX allows you to use sql queries in sheets.
It's simple to use!
It's simple to use!
This is tested now.
You need to be a member of the group https://groups.google.com/forum/#!forum/contributorpw.
After this you can install the last version https://chrome.google.com/webstore/detail/queryx/pabipchonhdoiiiicalnhpfjnglcdlkb
Just install the add-on from the Google Marketplace and add the formula
=QUERYX("SELECT LEN('QUERYX')")
You might want to select all from a range, for example, from A1:C
. Then add the formula
=QUERYX("SELECT * FROM ?",A1:C100)
=
=
=
_
_
Hmm ... By the way,
123
123
?
How much is it, do I need help?
How much is it, do I need help?
This program is distributed free of charge.
QUERYX is completely based on the AlaSQL.js database (MIT License) and implements its without changes.
More amazing add-ons
More amazing add-ons
An useful add-on for Google Sheets
The Google QUERY alternative for Google Sheets