Data Import & Export

Fix Excel for Mac Returning No Data from PostgreSQL ODBC Queries

John WilsonJohn Wilson Oct 9, 2026 871 views

Question details

The user is attempting to retrieve data from a PostgreSQL database using Microsoft Query in Excel for Mac, but the queries return zero results despite a successful connection.

Fix Excel for Mac Returning No Data from PostgreSQL ODBC Queries
Product
Excel for Microsoft 365
Device & OS
Mac
Scenario
Running SQL statements through Microsoft Query to import data from a PostgreSQL database into Excel on a Mac device.
Observed behavior
Excel successfully establishes the ODBC connection to PostgreSQL, but Microsoft Query returns completely empty results even for simple, valid SQL statements.
Before you start

Ensure that your PostgreSQL server is actively running, network access is permitted from your Mac, and that you have tested your SQL queries using a dedicated database management tool to confirm they actually return data.

Solution 1Recommended

Use the Actual Technologies ODBC Driver

Install a Mac-optimized ODBC driver from Actual Technologies, which is highly compatible with Excel for Mac and circumvents the empty query bug.

Default or generic ODBC drivers on Mac often face compatibility issues with Microsoft Query in Excel, leading to empty result sets. Specialized drivers like the one from Actual Technologies are designed specifically to bridge this gap.

1
Download the Driver

Visit the Actual Technologies website and download their ODBC driver for databases like PostgreSQL designed for macOS.

2
Configure the DSN

Open the ODBC Manager application on your Mac, navigate to the System DSN tab, and add a new connection using the Actual Technologies driver.

3
Enter Database Credentials

Input your PostgreSQL server address, database name, username, and password when prompted by the driver configuration screen.

4
Run Microsoft Query

Open Excel for Mac, go to the Data tab, select 'Get Data' or 'New Database Query', choose your newly created DSN, and execute your SQL statement.

Use the Actual Technologies ODBC Driver
Free Demonstration Mode: Actual Technologies offers a free demo mode. While it restricts the maximum number of rows returned, it is perfect for testing whether the driver resolves the 'no data' issue before you commit to purchasing a license.
Free Microsoft Office alternative

Experience Seamless Data Management with WPS Office

Tired of dealing with complex driver compatibility issues and empty queries in Microsoft Excel on Mac? WPS Office provides a lightweight, highly compatible alternative for your spreadsheet needs. Enjoy a familiar interface, comprehensive data analysis tools, and seamless file migration without the heavy subscription fees.

  1. 1. Download WPS Office: Visit the official WPS website and download the installation package for Mac.
  2. 2. Install the Software: Run the downloaded file and follow the simple on-screen instructions to install the suite.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel workbooks seamlessly to continue your data analysis.
Highly compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Lightweight architecture optimized for smooth performance on Mac devices.Powerful built-in data processing and visualization capabilities.Free to use with an intuitive, familiar user interface that minimizes the learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for Mac connect to my PostgreSQL database but return no data?

This is a known issue caused by compatibility gaps between standard PostgreSQL ODBC drivers and Microsoft Query on macOS. While the connection handshake succeeds, data fetching fails. Using a specialized driver optimized for Excel on Mac typically resolves this.

Are there completely free ODBC drivers that work perfectly with Excel for Mac?

Fully compatible drivers like OpenLink and Actual Technologies usually require a paid license. However, Actual Technologies provides a free demonstration mode that allows you to test the connection and fetch a limited number of rows before buying.

Where do I manage ODBC connections on a Mac?

You manage them using the ODBC Manager or ODBC Administrator application. You can find this utility in your Mac's Applications > Utilities folder, or it may be installed alongside the third-party ODBC driver.