Church directory templates for Word, Excel, PDF, and online
Each format is genuinely good at one job and bad at another. Here's the honest comparison — use a spreadsheet to collect, and something else to lay out.
The short version
| Format | Good at | Where it breaks |
|---|---|---|
| Excel / Google Sheets | Collecting and sorting the information. Sharing entry with a volunteer. | It isn't a page. Photos, page breaks, and anything that has to look printed. |
| Word | Small directories you'll never change much. Total control over one page. | Tables and photos fight each other. Around forty families, editing becomes re-layout. |
| Handing a finished file to a print shop, or emailing a fixed copy. | Uneditable. A PDF you email is a permanent copy you can't correct or take back. | |
| Online (this) | Laying out any number of families, photos, reprints, and a shareable copy. | Needs a browser, and the design decisions are picked from templates rather than drawn from scratch. |
Excel and Google Sheets: keep them, for the right step
A spreadsheet is the best place to *collect* a church directory. Rows are quick to type, a volunteer can work in a shared copy, and sorting by surname takes a second.
What a spreadsheet can't do is be a page. There are no facing pages, no cover, no photo frames that stay the same size, and no way to keep a family from splitting across a page break. Churches try, then spend an evening dragging row heights.
So use it for what it's good at and hand the result off: download the CSV template, paste your list into those columns, and import it. One row per person, a column for the family surname, and everyone in a household lands on one card. Headers are matched loosely, so *Household* or *Surname* work as well as *Family*.
Word: fine at forty families, painful at four hundred
A Word directory template works when the church is small and the directory rarely changes. You have complete control over a page, and you already own the software.
The trouble starts with volume and photos. Insert an image and the table reflows; add a family in the middle and every page after it shifts; a family of seven pushes a name onto the next page. Then someone moves, and you're re-checking sixty pages of layout to correct one phone number.
The other cost is repeatability. Next year's edition means opening last year's file and hoping the formatting survived — which is why so many churches print a directory once and never again.
PDF: an output, not a working format
PDF is exactly right at the end of the process. If you're taking the directory to a print shop, or emailing a copy to a shut-in, a PDF is what you want — it prints identically anywhere.
It's the wrong place to *keep* your directory, because it can't be corrected. And an emailed PDF is a permanent copy of your members' addresses and phone numbers on however many devices, which you cannot recall. A private link that you can password-protect or switch off is the safer way to hand out a digital directory.
You can still get a PDF here whenever you want one: print, and choose Save as PDF as the destination.
What the online version does that a file can't
- Re-flows instantly. Change photos on or off, or families per page, and sixty pages rebuild themselves — no re-layout.
- Keeps photo frames identical, whether a family has two people or seven.
- Builds the pages you'd forget: cover, welcome page, birthdays by month, anniversaries by month, back cover.
- Imposes a booklet properly — pages placed out of order on the sheet so folding puts them back in order.
- Never splits a family across a page break, because the pagination is worked out before the page is drawn.
- Stays correctable. Fix a number once; the shared link is right immediately and so is the next print.
A workflow that uses each for its strength
Collect in Google Sheets, where a volunteer can help and everyone can type. Import the CSV here in one pass. Lay out by picking a template and a paper format. Share a private link so corrections have somewhere to live. Print at the church, or save a PDF and hand it to a print shop.
Nothing in that chain asks you to give up the spreadsheet you already keep.
Questions churches ask
Is there a free church directory template for Word?+
Plenty float around online, and they work for small churches that won't change much. Expect the layout to fight you once you pass roughly forty families or start adding photos — that's the point at which churches generally move to something that paginates for them.
Can I get a church directory template for Excel or Google Sheets?+
Use the CSV template here as exactly that: open it in Excel, Numbers, or Google Sheets, type over the sample rows, and keep it as your working list. When you want pages, import it rather than trying to make a spreadsheet look like a book.
Can I export my directory as a PDF?+
Yes. Print it and choose Save as PDF as the destination. That's the file to send to a print shop — the booklet imposition is already applied, so they don't need to redo it.
Do I have to abandon my spreadsheet?+
No, and you probably shouldn't. A spreadsheet is the best place to collect and a poor place to lay out. Import it when you want a directory, and keep editing it if that's where your church's records live.
What columns does the import need?+
At minimum a family surname and a first name. It also reads relation, member or attendee status, birthday, anniversary, address, city, state, ZIP, family phone and email, and per-person phone, email, and notes. Extra columns are ignored and blanks are fine.
Will importing overwrite what I already entered?+
Only if you choose to. The importer asks whether to add these families to what's there or replace every family with the list, and it says plainly that replacing deletes the current ones.
Bring your spreadsheet and skip the layout
Download the CSV template, paste in the list you already keep, and import it. The pages are built for you on the other side.
Start your free directory