Guide

Export Table Data

Overview

Supabase is a Postgres-based backend platform that provides a built-in data management interface. Exporting table data as CSV is a common task when you need to extract records for reporting, data migration, or external analysis. CSV format is universally compatible with spreadsheet applications (Excel, Google Sheets) and data processing tools, making it ideal for sharing or archiving table snapshots. This workflow guides you through accessing Supabase's export functionality from the table view.

Before you begin

  • Active Supabase account (free or paid) at supabase.com
  • At least one project created in Supabase with an initialized database
  • A table with data that you want to export (the table must already exist in your project)
  • Access permissions to the table (typically owner or editor role on the project)

Step by step

1
Clickbutton

Open the export menu by clicking the menu button (typically three dots or a dropdown icon) in the top toolbar of your table view. This button reveals options for downloading and sharing your table data.

Tip. The menu button is usually located near the table search or filter controls in the top-right corner of the table interface. If you cannot find it, ensure you are actively viewing a table (not the project home or SQL Editor).
Step 1
2
ClickExport data

Select 'Export data' from the dropdown menu to access export format options. This action opens a submenu with different export formats available for your table.

Tip. If 'Export data' is not visible, confirm that the table has at least one row of data. Empty tables may not show export options in all Supabase versions.
Step 2
3
ClickExport table as CSV

Click 'Export table as CSV' to initiate the download. Supabase will immediately generate and download a CSV file containing all rows and columns from the current table.

Tip. The CSV file will be named after your table and saved to your default Downloads folder. You can open it directly in Excel, Google Sheets, or any text editor to verify the export was successful.
Step 3

Confirm it worked

  1. 1A CSV file downloads to your default Downloads folder with the table name as the filename
  2. 2The downloaded file contains all rows and columns from the selected table with proper CSV formatting (comma-separated values, headers in first row)
  3. 3Opening the CSV file in a spreadsheet application (Excel, Google Sheets) displays the data correctly with no corruption or encoding issues

Common issues

Keep reading