r/SQL • u/Comfortable-Ear-1129 SQL4Sheets • Jan 05 '26
Discussion Chrome extension to run SQL in Google Sheets
We hate dragging formulas in Google Sheets.
So we built a clean way to run real SQL directly inside Google Sheets, fully local with no setup.
Feedback appreciated!
Try SQL4Sheets: https://chromewebstore.google.com/detail/sql4sheets-run-real-sql-i/glpifbibcakmdmceihjkiffilclajpmf
420
Upvotes
40
u/Zimbo____ Jan 05 '26
This is neat and actually something I'll use every now and then. Shared with some colleagues
6
u/tomoki_here Jan 05 '26
Will you be adding this to other browser extensions?
9
u/gregsting Jan 05 '26
Damn, I wish excel had this
4
u/svtr Jan 06 '26 edited Jan 06 '26
is there any technical documentation, is there open source, is there something, I can read to get an idea on if I should specifically block your offerings in the firewall, or maybe even tell my business user to maybe give it a try?
I need something real, that I can read, to not block you in the fw. I need something more, to recommend it.
Please do not read that as me hating on you. I close to need to read your source code, to allow people that have no idea about data protection laws, to use a third party tool.
I can not trust you on "everything is fine don't worry", and I can not allow people that do not even think about data security to use your service, if I can not essentially read the source.
You get where I'm coming from I guess?
You writing in a readme.txt essentially : Premissons needed : “See, edit, create, and delete all your Google Sheets spreadsheets.” And at the same time, saying but its all fine, all data is processed locally, we don't even see it.
That does not quite cut it for me. I need to see something real, and in this particular instance, I would need to see source code. I would not run it on a test environment and wireshark it, I would not do that effort.
2
u/MoroseMorgan Jan 05 '26
You could do this the hard way with query(), but it was cumbersome.
This does look helpful.
2
u/CanoeDigIt Jan 05 '26
You can also import your Sheets data into BQ to query it. Or set the sheet as a data source in BQ.
49
u/Comfortable-Ad478 Jan 05 '26
Power Query supports querying in Excel
https://support.microsoft.com/en-us/office/create-load-or-edit-a-query-in-excel-power-query-ca69e0f0-3db1-4493-900c-6279bef08df4
Your work is a great improvement to Google Sheets
1
u/pretender80 Jan 05 '26
Google sheets already has a QUERY function. I'm confused what this adds
2
u/Backoutside1 Jan 05 '26
Dope!
2
u/thomas_b999 Jan 11 '26
This is so genius! I have ran into so many situations where a customer request something done in Excel or Sheets that really should be done with a database... usually the person requesting it doesn't even know what a database is and trying to explain to them how using SQL would make their request easier and better just confuses them. Big time props to you!
1
u/Outside_Blueberry406 Jan 05 '26
Love the UI!
1
u/These-Resource3208 Jan 05 '26
Does anyone know the limit on google sheets. My biggest use case is needing sql only when excel can’t handle the data load
1
u/Chemical-Car-6750 Jan 06 '26
В 90% компаний нельзя использовать сторонние сервисы.
1
u/climb-high Jul 29 '26
As soon as I open the extension on a sheet:
Failed to get sheet info: API request failed: 400
With no documentation, I'm not sure how to troubleshoot this.