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…

The amount of data we need to analyze keeps increasing but MS Excel still has a 1 million record limit. Well 1,048,576 rows to be precise.

There are many ways to deal with large files using code but a simple way is to split up the files into smaller files.

Then they can be opened in Excel easily.

There are a few ways to do this

Option 1: Use www.splitspreadsheets.com

Disclaimer: we made this tool

1. Upload your file on the website
2. Select how many rows you want in each split file
3. Select whether you want the header to be included in each file or…

Phone numbers are frequently used data types. So you would think they would be straightforward to work with, right? Right?

Well if you have phone numbers from multiple people and countries, it gets to be a mess.

You may find yourself having a spreadsheet with a bunch of different phone numbers and you’re stuck figuring out how to clean them.

If you want a quick way to do it, check out Clean Spreadsheets!

However, if you are trying to code or manually clean them yourself here is what you need to keep in mind.

What would cleaning a phone number do?

Cleaning a phone number will allow…

Automating sending emails from a Google Sheet filled with names, emails, messages etc. is a common task for any person or business.

This tutorial is opinionated, i.e. it outlines one specific way we found best to automate sending emails. We also use our own product API Spreadsheets to get the data from your Google Sheet.

There are many ways to go about this all and you should modify the code to fit your needs.

Pre-requisite

If you do not know how to use the Terminal and Python, then go through this tutorial first: Intro to Reading and Writing Spreadsheets with Python

Google Sheet

…

People or customer names are frequently used data types. So you would think they would be straightforward to work with, right? Right?

You may find yourself having a spreadsheet with a bunch of different customer names and you’re stuck figuring out how to clean them.

If you want a quick way to do it, check out Clean Spreadsheets!

However, if you are trying to code or manually clean them yourself here is a general overview on what you need to keep in mind.

First… what is a Name?

This may seem like a question that doesn’t need to be answered. Everyone and everything has a…

Marketing is a creative enterprise. But it is also a data-driven enterprise. And any data driven enterprise needs clean data to work effectively.

Data analysts and professionals recognize the importance of cleaning your data. But it might not be obvious to Marketing professionals.

Here are 5 reasons why your marketing effort needs clean data

1. Duplication

Customer and user duplication might be the single most important reason to strive for clean data.

Date and time are frequently used data types. So you would think they would be straightforward to work with, right? Right?

The ISO (International Organization for Standards) even has a module dedicated to how date and time should be written.

But like all data, date and time frequently appear in the wild in all different kinds of formats.

In this guide, we will walk through the most common date and time formats. There will also be detailed steps on how to best handle them in your Data Analytics project.

SHAMELESS PLUG: If you need to convert any date/time, feel free…