1. Introduction to Organize an Address Book

Playback Speed:

Gathering and organizing contact details for important people in your life allows you to reach out to them quickly and easily, but keeping all of the information in one place and updated can be challenging.

A spreadsheet is a great way to keep your addresses and other contact information organized and accurate.

It’s easy to update if someone changes their phone number or moves to a new address, and you can sort or search it to find information quickly.

You can access it from different devices and digitally share it with others.

In this lesson, you will organize a digital address book in a spreadsheet.

This lesson uses Google Sheets, but you could use any spreadsheet application.

Google Sheets is a spreadsheet application, which means you can organize information into columns, rows, and individual cells.

Your Google Sheets files are saved in Google Drive and stored in the cloud, a safe place on the Internet where you can save important information.

Because your spreadsheet is stored in the cloud, it can be opened, edited, downloaded and shared from any device with internet or WiFi access.

As you organize your address book, you will learn how to: Label headings in a spreadsheet, Enter and format data, And sort and search your spreadsheet.

Before you start, gather contact information for people you would like to add to your spreadsheet.

You might have contact information scattered across multiple devices, pieces of paper, or emails.

It’s OK — you don’t have to have everything on hand right now.

You can always update the spreadsheet later.

To work on this lesson, sign in to your Google account.

Open a new tab in your browser, and navigate to Google dot com.

If you are not signed in, do so now.

If you do not have a Google account, pause the video and create one now.

To begin, open your Google Drive.

Create a new blank spreadsheet and title it.

A spreadsheet can contain one or more sheets. Naming each sheet can help you stay organized, especially if you decide to add more sheets later on to organize other types of contacts, such as your neighbors or coworkers, for example.

Then move on to the next video to start organizing your address book spreadsheet.

Now, it’s your turn: Create a new, blank spreadsheet, Add a title, And name the sheet.


  1. Create a new, blank spreadsheet.
  2. Add a title.
  3. Name the sheet.