How to Connect Supabase to Excel

Supabase is hosted PostgreSQL, so you have four ways to get data into Excel: Power Query's PostgreSQL connector, the dashboard's CSV export, the PostgREST REST API via Power Query's web connector, and a connector add-in. The main gotcha is the connection string. Supabase's direct connection is IPv6-only on most projects, and Excel Power Query on Windows does not handle IPv6 reliably, so the connection times out without a clear error. The fix is to use the session pooler connection string from the Connect panel in your Supabase dashboard. Here is every method with the specifics each one requires.

Method 1: Power Query PostgreSQL connector with the session pooler

In Windows desktop Excel, go to Data, Get Data, From Database and choose From PostgreSQL Database. Before this option connects, install Npgsql version 4.0.17 (not 4.1 or later) with GAC Installation selected. Then:

1. In your Supabase dashboard, click Connect at the top of the project page and choose Session pooler.
2. Copy the connection string. It will look like postgres://postgres.[project-ref]:[password]@aws-[region].pooler.supabase.com:5432/postgres.
3. In Power Query, enter the host portion (aws-[region].pooler.supabase.com) as the server and postgres as the database. Use the username in the format postgres.[project-ref] for authentication.

The catch: Windows desktop Excel only. Do not use the direct connection string (db.[project-ref].supabase.co) because it resolves to IPv6 on most projects and silently fails in Power Query. Do not use the transaction pooler on port 6543 either, because it does not support prepared statements and will break the connection. The session pooler on port 5432 is the correct choice.

Method 2: CSV export from the Supabase Table Editor

In the Supabase dashboard, go to Table Editor, open the table you want, click the Export button (usually in the top-right of the table view), and choose CSV. Open the file in Excel. For custom queries, use the SQL Editor, run your query, and use the download button above the results grid to get a CSV.

The catch: every refresh is a manual repeat of the process. Works on any platform, including Mac and web Excel, because you are just opening a file. Fine for one-off snapshots.

Method 3: PostgREST API via Power Query Web.Contents

Supabase exposes every table through a PostgREST REST API. You can query it from Power Query using the Web connector. In Windows desktop Excel, go to Data, Get Data, From Other Sources, From Web, enter the URL for the table you want, and add the required headers. The anon key from your Supabase project settings provides read access to tables with a permissive Row Level Security policy.

A Power Query M query for a Supabase table looks like this:

let
    url = "https://[project-ref].supabase.co/rest/v1/your_table?select=*",
    headers = [
        #"apikey" = "your-anon-key",
        #"Authorization" = "Bearer your-anon-key"
    ],
    response = Web.Contents(url, [Headers = headers]),
    json = Json.Document(response),
    table = Table.FromList(json, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    expanded = Table.ExpandRecordColumn(table, "Column1", Table.ColumnNames(Table.FromRecords(json)))
in
    expanded

Replace [project-ref], your_table, and your-anon-key with your project values. The anon key is in Project Settings, API.

The catch: Windows desktop Excel only (the Web connector works there). PostgREST returns 1,000 rows by default; add &limit=10000 to the URL or paginate with &offset= for larger tables. Also, RLS must be set up correctly for the anon key to read the table you want.

Method 4: Brooked for Excel (Mac, web, and scheduled refresh)

Brooked for Excel connects to Supabase as a standard Postgres database, using the session pooler connection string from your project's Connect panel. It runs inside Excel's ribbon and works in desktop Excel on Windows, desktop Excel on Mac, and Excel on the web. No Npgsql install, no driver architecture mismatch, no IPv6 troubleshooting. The AI analyst lets you ask plain-English questions about the data.

Honest framing: Excel support is in beta. Manual imports and the AI analyst work today; scheduled refresh is rolling out through the beta. The Google Sheets version of the connector is fully live, so the Supabase and Postgres plumbing itself is mature.

Setting up the Supabase connection

Open Brooked in the Excel ribbon, choose Supabase or PostgreSQL as the source, and paste the session pooler connection string from your Supabase project's Connect panel. Pick the tables or write a SQL query, choose the destination sheet, and import. For scheduled refresh, configure the interval in the Brooked settings panel once that feature is available in the beta.

Brooked AI, Supabase

Live

Ask anything about your Supabase data…

Method comparison

What teams build with this

• User growth dashboards pulling signup and churn data from Supabase into a formatted Excel workbook
• Revenue reports joining orders, subscriptions, and refund tables for a weekly finance review
• Support queue snapshots from a Supabase-backed help desk, refreshed each morning for the ops team
• Content moderation summaries showing flagged items by type and status, updated daily
• A/B test result tables exported from a Supabase experiment log for analysis in Excel pivot tables

Troubleshooting common issues

Related Articles

• How to Connect PostgreSQL to Excel
• How to Connect SQL Server to Excel
• How to Connect Supabase to Google Sheets

Frequently asked questions