Hi all,
how can I upload geographic addresses to data base, I have a list of Users I need to upload and one field is address I have the address as a geographic address because I will need to calculate distances between the addresses the list is quite long any idea?
cheers Vik
Hey Vik,
You can definitely upload geographic addresses to your Bubble database using a CSV import! Just keep in mind that Bubble treats geographic addresses as a special field type, so you’ll need to make sure everything is formatted correctly. Here’s how you can do it:
First, you’ll want to prepare your CSV file. Make sure the address column has full address strings—like "1600 Amphitheatre Parkway, Mountain View, CA". If you have latitude and longitude, just a heads up that Bubble does not allow direct imports of those into geographic address fields, so you’ll need to use an API to convert them.
Once your CSV is ready, head over to Data → App Data → Upload. Select your CSV file and map the address column to the geographic address field in Bubble. The cool part is that Bubble will try to geocode the addresses for you automatically!
Just a quick note: if Bubble has trouble geocoding some addresses, it might not import them. If that happens, you can check out Option 2.
If you’re dealing with a long list of addresses, it’s actually a good idea to convert them into latitude and longitude first and then store those as geographic addresses in Bubble.
Here’s what you can do:
Geocoding API) or even a script in Python or Excel.Google Maps API, and then store the results in your Bubble database.let me know if makes sense for you…
cheers!