Re: Excel for Mac: Crashes while connecting to PostgreSQL

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