Data Query in Excel: Pull Live Database Results into Any Spreadsheet

See everything Query Streams can do beyond this guide Get Started Free

Supports

+more

Live Data

Replace exports with on-demand SQL

Excel Sheets

BI & AI Analytics

Ask Nova, get SQL + charts

Meet Nova

Database REST API

One key per partner. No credentials shared.

Build an API

+more

Automation

Scheduled sync to 6+ platforms

Explore

+more

API to SQL

Query APIs with SQL, no code

Explore

+more

AI Database MCP

Claude, Cursor, ChatGPT & Grok talk to your data

Connect AI

Query Streams is a secure, real-time database integration platform that lets you pull live SQL results into Microsoft Excel and Google Sheets without configuring ODBC drivers, writing VBA macros, or sharing database credentials. Learn more at QueryStreams.com and sign up for free to start running data queries in Excel from any database in minutes.

The Challenge: Getting Database Data into Excel

Every team that works with data eventually faces the same problem: the data lives in a database, but the analysis happens in a spreadsheet. Whether it is a finance team building revenue forecasts, a sales team tracking pipeline metrics, or an operations team monitoring inventory levels, the destination is almost always Microsoft Excel. The challenge is getting that data from the database into Excel reliably, securely, and without turning it into a full-time job for your DBA.

The result is a bottleneck. Business users depend on IT or a DBA to extract data on their behalf, and each request becomes another ticket. According to Gartner, IT teams spend up to 40% of their time on ad-hoc data requests. The problem is not a lack of tools — it is that existing tools for running a data query in Excel either sacrifice security for convenience or sacrifice convenience for security.

Methods for Querying Databases from Excel

There are several established approaches for getting SQL data into an Excel spreadsheet. Each has trade-offs in complexity, security, and scalability. Understanding these options helps clarify why many teams are moving to agent-based solutions for using SQL in Excel.

ODBC / DSN Connections

The traditional method for connecting Excel to a database is through ODBC (Open Database Connectivity) drivers. You install a database-specific driver on each user’s machine, configure a DSN (Data Source Name) with the server address and credentials, then use Excel’s Data menu to import from the ODBC source. This approach works, but it requires IT to install and configure drivers on every workstation, embeds database credentials on each machine, and typically requires direct network access (VPN or firewall rules) to the database server. Maintenance becomes painful when server addresses change, passwords rotate, or driver versions need updating across dozens of machines.

Power Query (Get & Transform)

Power Query is built into modern versions of Excel and provides a visual interface for connecting to databases, transforming data, and loading results into worksheets. Power Query supports SQL Server, PostgreSQL, MySQL, Oracle, and other sources natively. It is more user-friendly than raw ODBC, but still requires users to understand connection strings, write or paste SQL queries, and have direct network access to the database. For enterprise environments where databases sit behind firewalls, Power Query hits the same network barriers as ODBC. It also stores connection details within the workbook, which creates credential management challenges when files are shared.

Copy-Paste and CSV Export

The most common approach in practice is also the least scalable: someone with database access runs a query in a SQL client (SQL Server Management Studio, pgAdmin, DBeaver, or similar), exports the results as a CSV file, and either emails it or drops it in a shared folder. The Excel user opens the CSV and works with the data. This method requires zero technical setup for the end user, but it produces stale data the moment the export completes, creates an ongoing dependency on the person running the queries, and offers no audit trail or access controls. For a one-time data pull, it works fine. For recurring reports that need fresh data, it does not scale.

Query Streams: Agent-Based Live Data

Query Streams takes a fundamentally different approach. Instead of requiring Excel users to connect directly to your database, a lightweight network Agent runs on any machine with database access and creates an outbound-only WebSocket connection to the cloud relay. A DBA or data team builds saved queries in the web portal, then shares them with specific users. Those users open the Query Streams add-in inside Excel, pick a query from a dropdown, optionally adjust filters, and click Run. Live results stream directly into the worksheet. No ODBC drivers, no Power Query connection strings, no VBA scripts, no database credentials anywhere near the spreadsheet.

How Query Streams Works as an Excel Data Query Tool

Setting up Query Streams for Excel data queries involves four steps. Once configured, your team gets unlimited on-demand access to live database results without any ongoing IT involvement.

The Agent supports connections to 10+ databases from a single installation — Microsoft SQL Server (including Azure SQL Database and AWS RDS), PostgreSQL (including Google Cloud SQL), MySQL, MariaDB, Oracle, Snowflake, Google BigQuery, SQLite, DuckDB, and Microsoft Access. Multiple agents can be deployed across your entire infrastructure (on-premises data centers, AWS EC2, Azure VMs, Google Cloud), and all their data sources appear as a single unified dropdown in the query builder. Users simply select from available data sources without needing to know which agent or physical location hosts the database. For optimal performance, deploy agents in the same network or region as their databases.

Interactive Filters: Let Users Customize Queries Without SQL

One of the most powerful features for running data queries in Excel is Query Streams’ interactive filter system. Instead of building dozens of nearly identical queries for different date ranges, regions, or departments, a DBA builds a single query with configurable parameters. End users then adjust those parameters from the Excel add-in without ever touching the SQL.

Query Streams supports two approaches to filter creation. You can use explicit SQL variables (e.g., @start_date, @region, @department) that become named filter fields in the add-in. Alternatively, Query Streams can auto-detect static values in your WHERE clauses — for example, if your query includes WHERE region = 'Northeast', the platform detects Northeast as a filterable value. You enable this from the query’s Properties tab, where a Config switch can be toggled for any detected filter. Users see clean dropdowns, date pickers, or text fields in Excel and adjust them freely before each execution.

This capability is what sets Query Streams apart from other methods of using SQL in Excel. With ODBC or Power Query, each user either writes their own SQL or receives a static query with no flexibility. With Query Streams, a single query serves an entire team — each person adjusts the filters independently to get exactly the data they need, on demand, without submitting a ticket or waiting for a new CSV export.

Parallel Execution: Refresh Multiple Queries Simultaneously

A common limitation of traditional database-to-Excel workflows is serial execution. With ODBC or Power Query, refreshing multiple data connections usually happens one at a time — you wait for query A to finish before query B starts. For teams that need to populate multiple worksheet tabs with different datasets, this sequential approach wastes significant time.

Query Streams supports parallel query execution. Users can launch five or more saved queries simultaneously into different worksheet tabs, and the Agent streams each result set concurrently, regardless of result size. A finance team refreshing five different reports — revenue by region, expense breakdown, headcount projections, pipeline summary, and budget variance — can kick them all off at once. Each query runs independently on the Agent, and data streams back to each tab as soon as it is ready.

Comparison: ODBC vs Power Query vs Query Streams for Excel Data Queries

The following table compares the three primary methods for pulling SQL into Excel across the factors that matter most for enterprise and team use. Whether you need to connect a local SQL Server, a remote PostgreSQL instance on AWS RDS, or a cloud-hosted Snowflake warehouse, each approach has distinct strengths and weaknesses.

For individual power users who are comfortable with SQL and have direct network access, ODBC and Power Query remain viable options. For teams — where a DBA needs to provide controlled, secure, self-service data access to non-technical Excel users across different networks — Query Streams eliminates the setup complexity, credential risks, and ongoing maintenance that traditional methods require.

Security: No Credentials in Excel, No Inbound Firewall Rules

The security implications of running data queries from Excel are often overlooked until there is an incident. When ODBC connections or Power Query store database credentials inside workbooks or DSN configurations on user machines, every shared spreadsheet and every laptop becomes a potential credential leak. Query Streams eliminates this attack surface entirely.

Works with Google Sheets Too

Not everyone on your team uses Microsoft Excel. Query Streams also provides a Google Sheets add-on that works with the same saved queries, the same interactive filters, and the same Agent infrastructure. A DBA builds a query once in the web portal, and that query is available in both the Excel add-in and the Google Sheets add-on simultaneously. A shared user can independently select a query from their list, adjust any available filters, and run it to get live data on demand from either platform — without any action needed from the query creator.

This cross-platform compatibility means your team is not locked into a single spreadsheet tool. Finance might prefer Excel for its pivot table capabilities, while marketing might prefer Google Sheets for real-time collaboration. Both access the same live database data through the same secure pipeline. Query Streams supports parallel query execution in both Excel and Google Sheets — users can launch multiple queries into different worksheet tabs simultaneously and the Agent streams each concurrently, regardless of result size.

Frequently Asked Questions

Get Started

Related guides: Download the Query Streams Agent | Databases in Microsoft Excel | Databases in Google Sheets | AI Data Analytics with Nova | How to Run SQL Queries in Excel

Category: Articles

Tags: data query in excel, sql in excel, database to excel, excel database connection, live data excel, sql into excel, Excel add-in, database query spreadsheet, query streams, Excel data import

Meta Description: Pull live database results into Excel instantly. No ODBC, no VBA — just select a query and run.