Skip to content

Export and upload data from local SQLite database to Supabase database

Hieu Vu edited this page Apr 7, 2023 · 4 revisions

If you already have some data in your SQLite database and want to move them to Supabase database, you can export them in the format of CSV file and upload them to Supabase database

1. Export database to CSV file with Android Studio.

In Android Studio, open App Inspection tab, select the process your app is running on. Database preview

Select a table or entire database to export each table in CSV format

Screen Shot 2023-04-06 at 23 04 26

2. Upload CSV file to Supabase database

Drop the Inser button, select Import from CSV

Screen Shot 2023-04-07 at 20 55 37

Select your CSV file and see how the data is imported

Note: If there is something wrong with the CSV regarding file format, columns are not matched, these information will be display below as error message or a warning

Screen Shot 2023-04-07 at 20 55 55

Note: Instead of uploading anh CSV, you can also paste data from Google Sheet, Excel to import data In case the CSV is in wrong format, you can open this CSV in Excel or Google Sheent, then copy data from the sheet and paste to Supabase dashboard