There comes a time when you need to upload your database in Bubble and all you have an excel with a lot of data. In this quick tutorial I show you how can you use your excel and what to do, so you don’t waste time.

In this quick tutorial we will create the Dragon Ball episode’s list in Bubble database

(so my nephew can watch all the episodes later 🙂 )

  1. Create a Bubble database schema
  2. Export the excel as a csv
  3. Upload the csv file into the database
  4. …(other steps to create the full app)

1. Create data types

Go to Data menu item on the left side then go to the Data types tab.

Create two fields:
– Episode title, type: text
– Saga, type: text
(the other fields you see I created for the my app to watch episodes)

2. Save your datas as csv

This step is optional, if you have a csv from other source. But let’s say you created an excel file with file format .xlsx.

In the excel you click
– File ->Save as
– Choose -> CSV (comma delimited) .(*csv)

Source files to start with:

3. Upload process

Go To Data menu item, then App data tab. Here click on the Upload button from the header elements. After on the popup select a Pick a file to upload and select the .csv file from your computer.

Microsoft Excel converted my csv file with ; delimiter, so please select from the Data delimiter dropdown the semicolon.
In the Map Fields select for the Saga(this is how named my column in my excel) the Saga and for Episode Title the Episode Title
Validate the data, then Upload it.

See additional information on Bubble official documentation about importing data.

I am available for bubble projects, contact me to make your next application together!


Leave a Reply

Your email address will not be published. Required fields are marked *