Export Supabase data 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 how to efficiently export your Supabase data as a CSV so you can work with it outside of the platform.

1. Go to your Supabase project

2. On your dashboard, go to ‘SQL Editor’

3. Type this SQL query

4. Run the SQL query

5. Hit ‘Export’

6. 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 Airtable, Google Sheets, and Notion in real time. With Whalesync, your data stays updated across platforms, so you can focus on building, not managing data transfers.