Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PostgreSQL Query to Excel Sheet

Tags:

I need to export some data from PostgreSQL to Excel (quick customer wish), and the last time Excel had serious problems opening or importing my COPYd csv files (line endings, utf-8 encoding, etc), and it took me an hour at best.

Does someone know a quick, elegant solution that generates a real Excel file? Like a small shell script or the like?

I want this to be done either on my Linux box (Debian 5.0 Lenny) or on Windows (XP or higher).

like image 930
Daniel Avatar asked Apr 01 '11 05:04

Daniel


People also ask

How do I export query results to excel in PgAdmin 4?

In PgAdmin export option is available in file menu. Execute the query, and then we can view the data in the Output pane. Click on the menu FILE -> EXPORT from query window.


1 Answers

You could install the PostgreSQL ODBC driver on the Windows machine, and then connect Excel to the database like explained in this blog post (except using ODBC rather than OLEDB).

I haven't tested this. I'm not really sure if this makes it any easier than exporting CSV and fixing it (given what Excel is like).

EDIT (thanks @Tometzky): The best solution is to use the PostgreSQL ODBC driver to connect Microsoft Access to the database and from Access export to Excel.

like image 104
StackExchange saddens dancek Avatar answered Oct 09 '22 11:10

StackExchange saddens dancek