Export Supabase database as a CSV

Here’s a quick tutorial on how to export Supabase data as a CSV

5 min read
May 23, 2025

Export Supabase database as a CSV

Supabase is a powerful database solution, making it easy to store and manage structured data. But sometimes, you need to export that data to other tools. Exporting your Supabase database as a CSV file allows you to analyze data in spreadsheets, move records to another platform, or share structured datasets with your team. 

In this guide, we’ll walk you through two ways to export your Supabase database as a CSV so you can work with it outside of the platform.

Option 1: Export via the Supabase UI

If you want to export the whole database (meaning all of the columns and rows), you can do this from the UI.

Click the three dots next to the table you want to export 

Click export data 

Click export table as CSV

Option 2: Exporting via SQL Editor

Exporting via the SQL editor allows you to:

  • Export specific columns instead of all 
  • Apply filters or conditions 
  • Join data from multiple tables

On your dashboard, go to ‘SQL Editor’

Type this SQL query

In this instance, we want to export all the data from our Contact table.

As we’re exporting from the Contact table, the query is SELECT * FROM “Contact”. However, for your own query, run this: SELECT * FROM [Insert table name].

The asterisk signifies all the values.

Run the SQL query


 Hit ‘Export’

Hit ‘Download CSV’

A smarter way to move your data 

Exporting data from Supabase as a CSV is useful for one-time transfers, but if your data is frequently changing, manual exports quickly become unsustainable.

 Instead of repeatedly exporting and re-importing, use Whalesync to automatically sync your Supabase database with tools like AirtableGoogle Sheets, and Notion in real time. With Whalesync, your data stays updated across platforms, so you can focus on building, not managing data transfers.

Subscribe for more

Stay up to date with the latest no-code data news, strategies, and insights sent straight to your inbox!

Thank you for subscribing!

Oops! Something went wrong while submitting the form.
Keep reading

Related posts

Jun 19, 2025

How to connect and sync Supabase to Sheets in 5 minutes with Whalesync

Read post
Jun 17, 2025

How to connect and sync Supabase to Webflow CMS in 5 minutes with Whalesync

Read post
Jun 17, 2025

How to connect and sync Stripe to Airtable in 5 minutes with Whalesync

Read post
Jun 16, 2025

How to connect and sync Airtable to Neon in 5 minutes with Whalesync

Read post
Jun 16, 2025

How to connect and sync Airtable to Attio in 5 minutes with Whalesync

Read post
Jun 11, 2025

How to connect and sync Airtable to PostgreSQL in 5 minutes with Whalesync

Read post