Your database results, live in Excel & Google Sheets.
An analyst builds a query object once in the portal — a saved query that tells Query Streams exactly how to fetch the data — then shares it with anyone in the world. Recipients never see SQL or code: they pick the shared query in their own Excel or Google Sheets add-on, set the filters you allow, hit Run, and live results stream straight into their cells.
Free forever tier · No credit card required
Microsoft Excel add-in
- A live Power Query alternative — no ODBC, no VBA, no Formula.Firewall prompts
- Results land as normal cells — XLOOKUP, PivotTables, charts all work
- Fills a worksheet up to 1,048,576 rows × 16,384 columns
Google Sheets add-on
- Uses the Sheets API directly — no 6-minute limit, no URL-fetch quotas
- Results land as normal cells — VLOOKUP, pivots, charts all work
- Streams progressively across a spreadsheet’s ~10 million cells
You share a query object — never the SQL.
What you publish isn’t code — it’s a query object: a saved query that tells Query Streams exactly how to fetch the data. The people you share it with never see SQL, a schema, or a connection string. They just get live results and the filters you choose to expose — which is exactly how teams replace brittle ERP and database reporting with something anyone can run.
What the recipient sees
- Live results, right in their cells
- Only the filters you allow (dates, regions…)
- A Run / Refresh button
What stays hidden
- The SQL and query logic
- Database credentials & connection
- Tables, schema & joins
Write once. Share to anyone.
The same secure, outbound-only Network Agent powers both add-ins. An analyst builds the query object once; everyone they share it with pulls live results in their own Excel or Sheets.
Install the Agent
Run the outbound-only Network Agent on your server or VM — Windows, Linux or macOS. No inbound ports, no firewall changes.
Connect a source
SQL Server, PostgreSQL, MySQL, MariaDB, Snowflake, Oracle, BigQuery, SQLite, Access, DuckDB — or an API connector.
Save & share
Build the query once, turn on filters, and share the query object with anyone in the world — teammates or external users. They get the data, never the SQL.
They pick it in the add-on
Recipients sign in to the Excel or Sheets add-in and the shared query is right there, ready to run.
Run & refresh
Set the filters, hit Run, and live results stream into the cells. Refresh on demand — SQL never shown.
Built for real spreadsheet work
Not a static export. Live, governed, shareable data that behaves like the cells you already use.
Live refresh on demand
Hit Run whenever you need current numbers. No scheduled jobs, no refresh quotas, no waiting for a nightly batch.
Parallel into tabs
Run multiple saved queries at once and stream each result set into its own worksheet tab simultaneously.
Works with formulas & charts
Data arrives as ordinary cells, so your lookups, PivotTables, charts and conditional formatting keep working.
Share a query object
Publish a saved query and recipients refresh live results behind the filters you allow. The SQL, schema and credentials are never exposed.
Skip the old plumbing
The legacy ways of getting a database into a spreadsheet all carry the same baggage. Query Streams drops it.
Power Query / ODBC / Apps Script
- Local ODBC/JDBC drivers or a gateway to patch and keep online
- Formula.Firewall & privacy-level prompts break refreshes
- Apps Script’s 6-minute limit and URL-fetch quotas throttle big pulls
- Whitelisting Google IP ranges; passwords stored in script code
- Sharing means emailing XLSX files or exposing the raw SQL
Query Streams
- Outbound-only Agent — zero drivers, gateways or firewall changes
- Its own data channel — no Formula.Firewall, no privacy prompts
- No execution limits or quotas — streams progressively at any size
- Credentials stay on your server, never in client code
- Share a query object — recipients get results, never the SQL
Power Query and Apps Script are still great for staged ETL and scheduled refresh. Query Streams steps in when teams need secure, interactive spreadsheet queries that refresh instantly and scale to outside stakeholders.
See the add-ins in action
The same saved queries, filters and sharing — in the spreadsheet your team already lives in.
What users are saying
★ 5.0 across Microsoft AppSource (3 reviews) and the Google Workspace Marketplace (12 reviews) — every rating five stars.
“Incredible tool for data analytics and IT. Writing queries and pulling information has always been easy — sharing data with others and letting them query whenever they need it is the challenge. Query Streams fixes this problem: I can share queries with coworkers in minutes without writing complex applications. Simple and very powerful.”
“This solved our ERP reporting issues. Instead of exporting static spreadsheets, we refresh live data directly in Sheets. Analysts build the query once, and end-users interact with dropdowns and date filters. It’s cut hours of weekly manual work.”
“I’d pulled data manually from my company’s ERP system for years. We recently invested in Query Streams and it has revolutionized the way I access the company’s data for analysis. It’s lightning quick and the largest tables pull in seconds. Highly recommend!”
“A great tool for business analysts who need rapid, informed decisions — and for non-technical users who need SQL-like power and precision without the headache of writing queries. Very easy to implement.”
“QueryStreams is simple to use, and my go-to to pull data fast without having to export it out of our ERP system.”
“I integrated this into my work within a few hours, and their team answered every follow-up question. Works fantastic keeping live data in sync with Google Sheets for reports and further processing with formulas.”
“I’ve been using QueryStreams to gather all of my data in real time. If a machine is out of calibration, I know immediately.”
“Exactly what I was looking for. Wonderful layout and perfect for my needs.”
“We needed some reports out of our ERP that weren’t standard. Our data analyst built some queries and shared them to us in Excel — problem solved.”
One channel, 53 data sources
38 database connectors and 8 API connectors — all through the same secure Agent, in Excel and Sheets alike.
Put your database results in the spreadsheet today.
Free forever tier — no credit card. Connect a source and stream live results into Excel or Sheets in minutes.
English 
Spanish 
German 
French 
Portuguese 
Japanese 
Korean 
Chinese 
Italian 
Dutch 
Indonesian 
Polish