If you’ve ever tried to manage a directory for a church, school, or organization, you know how frustrating it can be. Many directory tools are expensive, outdated, or difficult to maintain.
The good news? You can create a clean, professional, and easy-to-update directory using Google Sheets—no special software required.
In this guide, I’ll walk you through exactly how to build your own directory from scratch in just 3 tabs.
Why Use Google Sheets for a Directory?
Before we dive in, here’s why Google Sheets is a great option:
- No subscription fees
- Customizable for your specific needs
- Easy to update and share
- Accessible from anywhere
For many people and organizations, this is a much simpler and more affordable solution than traditional directory software.
Step 1: Set Up Your Directory Structure
Start by going to your Google Drive and creating a new Google Sheet. Call this tab "Directory Information" or something similar. Then you will decide what information you want to include, and adding them as column headers.
Common columns include:
- Name
- Phone Number
- Address
- Birthday
- Membership date
You can really add whatever you'd like in with this section, depending on what you or your organization needs. Just note that some fields, such as Name, might need to be broken out into First Name and Last Name, if you're wanting to sort the directory by last name. We will add these fields back together in the next step.
Step 2: Organize and Sort Your Data
One of the biggest advantages of Google Sheets is how easy it is to add, delete, and sort your directory automatically just by using a simple formula
To do this, create a new tab called "Sorted Directory", or something similar. You will then go to cell B1 and use a SORT formula. It will look something like =SORT(Directory!A2:H5000,2,"Ascending").
What this does is reference your directory table, plus additional rows at the bottom (Directory!A2:H5000). We want it to not include the column headers, so we start in the second row. The next number is the sort column. Since Last Name is the second column in our directory table, we will indicate it with a 2. The last section is how you want the directory to sort, either ascending or descending.
The next step is small but important. In column A, you will number each row. Row 1 as 1, 2 as 2, and so on. This will help you in step 3.
You now have a sorted directory table!
Step 3: Create your Pages
The next step is to determine how you want your directory to look. You can get really creative here and do just about anything! An easy format is simply a standard 8.5" x 11" page with 2 columns of entries on it. Depending on the amount of information you put on your Directory tab (the number of columns), you will either have more or less entries here. If you have 4 or 5 columns or pieces of information you are wanting to display, then you can have about 6 entries per column with 12 point font. This gives you a nice, legible, page with 12 entries on it.
Once you have decided on a format, you will need to add the identifier next to each entry. The first entry will have a 1, the second will reference that cell and add +1. Entry 3 will need to reference entry 2's identifier and add a +1.
Next, write a VLOOKUP formula to reference the unique identifier and look that up in your sorted directory. You will adjust the column for each piece of information you are referencing on each line. Once you have the first one, you should be able to copy and paste the formulas.
Now you have an automatically sorting directory!
Want a Done-For-You Custom Directory?
If this feels like something you’d rather not build yourself, we can help!
We create fully customized directories designed specifically for your organization. We have built directories for churches, assisted living facilities, schools, professional organizations, law firms and clubs of all kinds.
Each directory is:
- Built to match your exact needs
- Easy for anyone to update
- Designed to look clean and professional
- A one-time cost (no subscriptions)
If a completely custom solution isn't for you, we also have pre-made templates that are ready to go as soon as you download them. While not 100% custom, you are able to make some light customizations yourself. The best part is you can begin creating your directory right away!
Final Thoughts
Creating a directory in Google Sheets is one of the simplest and most cost-effective ways to maintain a directory. Other tools are far more expensive or are subscription based, and simple word documents are too difficult to sort and update.