Forum Discussion
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...
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