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.
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.