How to read an Excel/CSV file in bubble.io using AWS S3/Lambda

How to read an Excel/CSV file in bubble.io using AWS S3/Lambda

Today I will demonstrate a very simple way to implement the data extraction from Excel/csv file to your SQL database in bubble.io.

Hi everyone, today I will demonstrate a very simple way to implement the data extraction from Excel/csv file to your SQL database in bubble.io.

This workflow uses AWS S3/Lambda function as a connecting bridge which is both time efficient compared with manual input and cost efficient if you’re using AWS free tier services.

The only cost would be installing a plugin in bubble called AWS File Uploader ($35) and that’s all. Amazing, right?

Let’s now dig in and see how it works.

Step 1: Confirm your input data and build database accordingly

This is actually an egg and chicken problem. Usually it happens when you find out that Excel/Access can no longer serve your purpose of managing and retrieving data promptly and that’s when you start to build your relational (and/or) non-relational database.

Image for post

Photo by Dylan Gillis on Unsplash

For example, as a senior project manager overlooking the global or regional market, using Excel as a standard template for distribution and extracting data from it would be very helpful especially when you have project managers all over the world and you want to centralize the project information and monitor the progress from a holistic view.

Step 2: Build your bubble page to reflect the project information

Image for post

Project Database for test use

data-engineering aws aws-lambda data-science web-development

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Hire AWS Developer

Looking to Hire Professional AWS Developers? The technology inventions have demanded all businesses to use and manage cloud-based computing services and Amazon is dominating the cloud computing services provider in the world. **[Hire AWS...

Hire Dedicated AWS Developer

Want to Hire AWS Developer for cloud computing services? At **[HourlyDeveloper.io](https://hourlydeveloper.io/ "HourlyDeveloper.io")**, we leverage maximum benefits from the AWS platform ensuring prominent Solutions for business requirements....

50 Data Science Jobs That Opened Just Last Week

Data Science and Analytics market evolves to adapt to the constantly changing economic and business environments. Our latest survey report suggests that as the overall Data Science and Analytics market evolves to adapt to the constantly changing economic and business environments, data scientists and AI practitioners should be aware of the skills and tools that the broader community is working on. A good grip in these skills will further help data science enthusiasts to get the best jobs that various industries in their data science functions are offering.

Applications Of Data Science On 3D Imagery Data

The agenda of the talk included an introduction to 3D data, its applications and case studies, 3D data alignment and more.

Managing Data as a Data Engineer:  Understanding Data Changes

Understand how data changes in a fast growing company makes working with data challenging. In the last article, we looked at how users view data and the challenges they face while using data.