Planning the music for an event or party can be stressful. Especially if you’re the DJ & everyone attending wants their song to be played.

This is part two of a three part series about how to build a custom web app with spreadsheets.

• Part One: Learn how to build a form and display the data. Read it here!
• Part Two: Create a login page where the user can delete & update data
• Part Three: Deploy the web app

For this part, we will go through how to make a login for the DJ & they can delete & update…

Standardizing, cleaning and normalizing currency & money amounts in data is relatively simple if all the amounts are from the same denomination and format. Such as the following amounts that are all USD and follow American numerical conventions:

Planning the music for an event or party can be stressful. Especially if you’re the DJ & everyone attending wants their song to be played.

This is part one of a three part series about how to build a custom web app with spreadsheets.

• Part One: Learn how to build a form and display the data
• Part Two: Create a login page where the user can update & delete
• Part Three: Deploying the web app

For part one, we will go through how to make a form for guests to submit their song request and how that data can instantly…

Raise your hand if you have tried doing some analytics with company names and it led to a visualization like this one

WHY DID THIS HAPPEN?!

Dirty data strikes again. The same company name can be written a bunch of different ways.

1. Just the company name — Apple
2. The company name with abbreviated legal entity suffix — Apple Inc
3. The company name with full legal entity — Apple Incorporated

Not to mention the usual dirty data suspects:

4. Inconsistent capitalization — apple Inc

5. Random commas and dots — Apple, Inc.

How do I clean these company names?

Let’s go step by step and use this list as an example

Data lives in a ton of places. Your marketing software, your payment provider, random spreadsheets, your email thread with Rebecca.

But in our collective 20+ years of working with Data teams, we have noticed that the most important data usually lives in a database. Whether it is your sales data as an e-commerce provider or usage numbers as a SaaS startup.

So, it becomes imperative that managers, leaders and business people should access the database with ease. Especially if they want their team or organization to champion data-driven decision making.

Currently there are 2 ways for business people to access…

What is an HTML form?

A form in HTML is a full or part of a web page that allows a user to submit data to a server. This can be something like a mailing list or a survey.

What will I learn in this article?

1. All about setting up and styling a Form using HTML & CSS
2. How to save data from that Form to Spreadsheets & Google Sheets without setting up a back-end
3. Comparison of different tools that allow you to do Step 2

How do I create a form in HTML?

It’s really easy to set up a web form using HTML & some CSS. If you have any coding experience, HTML can be picked up quickly…

Learn how to make a quick custom website using HTML, CSS, and JavaScript using data from a Google Sheet.

Perfect for beginners to web development or experienced devs looking to make a website without a backend!

The End Product

Final Website

My website is about How to Pronounce Indian names — a cause close to my heart as an Indian-American.

Below is a sample of how it looks. You can view it live here, as well.

Code

Here is the full code for the two files that will create the website: index.html & index.css.

Don’t worry! …

Ah, there’s nothing as satisfying as finishing all your code for a website you’re making. But then comes the hard part — deploying it. Don’t worry, we got you covered with this guide.

We will go through deploying without a custom domain, with a HTTP custom domain, and a secured HTTPS domain custom.

What Will I Need For This?

• Files containing code for your Website
• An account on Amazon Web Services (services used in this article are free up to a year on a new account)
• A custom domain, I am using Google Domains for this article

Deploying on Amazon Web Services (AWS)

1. Login in or create an account on AWS
2. Click…