Import Multiple PostgreSQL Tables Into Excel Software — Fast & Automated

How to Import Multiple PostgreSQL Tables Into Excel — Step-by-step

Overview (assumption)

Assume you have access to the PostgreSQL server, credentials, and Excel on Windows or macOS. This guide shows two reliable approaches: exporting CSVs with psql/pgAdmin (best for many tables) and connecting Excel directly via ODBC/Power Query (best for live refresh).

Option A — Export multiple tables to CSV then open in Excel (recommended for bulk/export)

1. List tables (example SQL to run in psql or pgAdmin Query Tool):

   sql
   Copy CodeCopied
   SELECT table_schema, table_name FROM information_schema.tables
   WHERE table_type=‘BASE TABLE’ AND table_schema NOT IN (‘pg_catalog’,‘informationschema’);
   

2. Create export folder on the machine that can access PostgreSQL server (e.g., C:\exports).
3. Export each table to CSV (server-side COPY or client-side psql \copy). Example using psql client from your workstation (replace placeholders):

   bash
    ffON2NH02oMAcqyoh2UU MQCbz04ET5EljRmK3YpQ CPXAhl7VTkj2dHDyAYAf” data-copycode=“true” role=“button” aria-label=“Copy Code”>Copy CodeCopied
   # loop in shell (Linux/macOS)
   for t in \((</span><span class="token" style="color: rgb(54, 172, 170);">psql -t -c </span><span class="token" style="color: rgb(163, 21, 21);">"SELECT table_schema||'.'||table_name FROM information_schema.tables WHERE ..."</span><span class="token" style="color: rgb(54, 172, 170);">)</span><span class="token" style="color: rgb(57, 58, 52);">;</span><span> </span><span class="token" style="color: rgb(0, 0, 255);">do</span><span> </span><span></span><span class="token assign-left" style="color: rgb(54, 172, 170);">schema</span><span class="token" style="color: rgb(57, 58, 52);">=</span><span class="token" style="color: rgb(54, 172, 170);">\)(echo \(t </span><span class="token" style="color: rgb(57, 58, 52);">|</span><span class="token" style="color: rgb(54, 172, 170);"> </span><span class="token" style="color: rgb(57, 58, 52);">cut</span><span class="token" style="color: rgb(54, 172, 170);"> -d. -f1</span><span class="token" style="color: rgb(54, 172, 170);">)</span><span> </span><span>  </span><span class="token assign-left" style="color: rgb(54, 172, 170);">table</span><span class="token" style="color: rgb(57, 58, 52);">=</span><span class="token" style="color: rgb(54, 172, 170);">\)(echo \(t </span><span class="token" style="color: rgb(57, 58, 52);">|</span><span class="token" style="color: rgb(54, 172, 170);"> </span><span class="token" style="color: rgb(57, 58, 52);">cut</span><span class="token" style="color: rgb(54, 172, 170);"> -d. -f2</span><span class="token" style="color: rgb(54, 172, 170);">)</span><span> </span><span>  psql -c </span><span class="token" style="color: rgb(163, 21, 21);">"</span><span class="token" style="color: rgb(255, 0, 0);">\c</span><span class="token" style="color: rgb(163, 21, 21);">opy </span><span class="token" style="color: rgb(54, 172, 170);">\){schema}.\({table}</span><span class="token" style="color: rgb(163, 21, 21);"> TO 'C:/exports/</span><span class="token" style="color: rgb(54, 172, 170);">\){schema}${table}.csv’ DELIMITER ‘,’ CSV HEADER”
   done
   

   Or single-table server-side:

   sql
    ffON2NH02oMAcqyoh2UU MQCbz04ET5EljRmK3YpQ CPXAhl7VTkj2dHDyAYAf” data-copycode=“true” role=“button” aria-label=“Copy Code”>Copy CodeCopied
   COPY public.mytable TO ’/var/lib/postgresql/exports/mytable.csv’ DELIMITER ’,’ CSV HEADER;
   

4. Transfer CSVs to the machine with Excel if exported on the server.
5. Open in Excel:
   • Excel: Data → Get Data → From Text/CSV → select CSV → Load. Repeat per file or use Power Query to combine.
6. Optional: Combine multiple CSVs into a single workbook:
   • In Excel: Data → Get Data → From File → From Folder → point to export folder → Combine & Load. This creates tables/sheets per file or combined table.