Forum Discussion

sg_22's avatar
sg_22
Copper Contributor
Apr 03, 2025

Excel for Mac: Crashes while connecting to PostgreSQL

Hi

I use Excel for Mac and recently updated it to 15.95. Since updating, Excel keeps crashing as soon as I try to connect any excel file to Postgre SQL through Power Query. This does not happen in 15.79 version of Excel for Mac or below. Does anyone have any solution for this?

Thanks

excel
Excel on Mac

1 Reply

  • JaxonMitchell's avatar
    JaxonMitchell
    Iron Contributor
    Apr 05, 2025

    1. Check compatibility 
     Driver version: make sure you use the official PostgreSQL ODBC driver (download link) 
     Excel version: update to the latest version (Excel > Help > Check for Updates) 
    2. Steps to fix it 
    Reinstall the ODBC driver (recommended v13.02 stable) 
    Reduce the amount of data: add LIMIT 1000 to the query to avoid running out of memory 
    Shut down the other applications: Free up memory 
    3. Alternatives 
     Export CSV: Use other tools to export data and then import it into Excel 
     Script with Python 
    python 
    import pandas as pd 
    df = pd.read_sql("SELECT * FROM table LIMIT 1000", "postgresql://user:password@ address:port/database name") 
    df.to_excel("data.xlsx") 
    4. The Ultimate Solution 
    Switching to Excel for Windows

     

Resources