Forum Documentation Showcase Pricing Learn more

Inserting data from Excel to App Data

Hi All,

I am currently trying to use zeroqode’s barcode scanner to scan items. I have an excel document with all the data that corresponds to the barcodes but I am having difficulty importing a whole excel sheet into the data section of Bubble. Is there a simple way to do so?

Thanks

If it’s a CSV file, you can upload directly into the database from the data tab.

@jcindy81 how do you upload the CSV filed directly into the database from the data tab?

Under the App Data tab, use the Upload button.

You should really join https://coachingnocodeapps.com/ for at least a little bit to get yourself up to speed on things like CSV uploading. These resources can get you up and running pretty quickly.

You have probably seen the site designer in the forum quite a bit.

For anybody looking for an instructional guide as I was…here is what I figured out after a lot of trial and error.

First go into the app ( must be on paid plan to be able to do this ) and open the data section.

Go to here

Click the upload button on right side of screen.

35%20PM

Then you will see this screen popup

Choose your data type, which is from your database. Then Select a file using the “pick a file to upload” button.

After selecting the file you will be prompted to “map the fields”…an important part of making this step smooth is to make sure your excel file as column titles that match exactly the data fields in your database.

For example your data type of users has a data field of “first_name” you need to make sure you excel file has a column title of “first_name” so that the system automatically will match them. This is helpful when needing to upload many entries.

Also important, at least on a personal plan, the upload will only allow up to 100 rows at a time, so you should have excel files with only 100 rows of data…it doesn’t seem to be affected by the number of columns.

I had a set of 1800 entries and needed to have 18 separate excel files with 100 entries each for the upload to work. At first I tried with the 1800 entries on one file and the upload never worked even after letting it go for over 3 hours. The annoying thing is that it created the new entries in the database but with no data.

It took me only 50 minutes to upload the 18 separate files as I had the column titles matched to the data fields and the process was much smoother that way.

Hope this helps somebody else.