What a template is and why you'd make one

A template is a pre-built document or spreadsheet that you save as a starting point. Instead of rebuilding the same layout, formatting, and text every time you need it, you open the template, fill in the new information, and save it as a regular document. Templates save time on repetitive work — whether that's invoices, meeting agendas, project plans, or letters you send regularly.

You can create a template in Microsoft Word, Google Docs, Google Sheets, or Excel. Each program stores templates slightly differently, but the process is the same: build what you want, save it as a template file, and then open it whenever you need a fresh copy.

Key Takeaways

  • A template is a document you design once and reuse many times by opening it, filling in new details, and saving it with a new name.
  • In Word and Excel, you save a file as a .dotx (Word) or .xltx (Excel) template file, which prevents you from accidentally overwriting the original.
  • In Google Docs and Sheets, you save a regular document and mark it as a template in your Google Drive, or save it to the template gallery.
  • The easiest way to use a template is to open it, immediately save it with a new filename, and then make your changes to that new copy.

Creating a template in Microsoft Word

Open Word and build the document the way you want it to look every time. Add your company logo, standard headings, placeholder text (like "[Your Name Here]" or "[Date]"), tables, or any formatting you always use. Don't worry about making it perfect — you can edit it later.

When the document looks right, go to File > Save As. In the "Save as type" dropdown at the bottom of the window, select Word Template (.dotx). Word will automatically put it in your Templates folder. Give it a clear name like "Invoice Template" or "Meeting Agenda." Click Save.

The next time you need to use it, go to File > New and search for your template by name. Click it, and Word opens a fresh copy without touching the original. You can then type your information and save it as a regular .docx file with a new name.

Creating a template in Google Docs

Build your document in Google Docs the same way — add your layout, logos, placeholder text, and formatting. When it's ready, click the three-dot menu in the top right corner and select Template gallery. This saves your document to Google's template collection and makes it available every time you create a new document.

If you don't want to add it to the public gallery, you can skip that step. Instead, just keep the document in your Google Drive. When you need to use it, open the document, click File > Make a copy, and give the copy a new name. This creates a fresh version you can edit without changing the original.

You can also share a template with others by giving them view or edit access to the original document in Drive. They can then make a copy whenever they need it.

Creating a template in Microsoft Excel

Build your spreadsheet with all the columns, formulas, formatting, and labels you want to reuse. If you use the same calculations (like totaling a column or calculating a percentage), build those formulas in now — they'll carry over to every new copy. Add placeholder text in cells where information changes, like "[Employee Name]" or "[Project Title]."

Go to File > Save As and select Excel Template (.xltx) from the "Save as type" dropdown. Excel saves it to your Templates folder automatically. Name it clearly, like "Monthly Budget" or "Expense Report."

To use it, go to File > New and search for your template. Click it, and Excel opens a fresh copy. Fill in your data and save it as a regular .xlsx file with a new name. The original template stays untouched.

Creating a template in Google Sheets

Set up your spreadsheet with the columns, headers, formulas, and formatting you need. Add any calculations or conditional formatting (like cells that change color based on a value). Use placeholder text for information that changes each time.

Click the three-dot menu and select Template gallery to add it to your templates. This makes it available when you create a new sheet. Alternatively, keep it in your Drive and use File > Make a copy each time you need a fresh version.

Formulas in Google Sheets work the same way as in Excel — they copy over to every new sheet you create from the template, so you don't have to rebuild calculations.

The safest way to use any template

No matter which program you use, follow this habit: open the template, then immediately save it with a new name before you make any changes. This prevents you from accidentally editing the original template instead of a copy.

In Word or Excel, this happens automatically when you open a .dotx or .xltx file — the program prompts you to save as a new document. In Google Docs or Sheets, you have to do it manually by clicking File > Make a copy first. If you forget and edit the original, you can undo your changes by pressing Ctrl+Z (or Cmd+Z on Mac) repeatedly, or close without saving and reopen the template.

Common mistakes when building templates

The most common mistake is leaving real data in the template. If you build a template for an invoice and forget to delete the sample customer name or amount, that information will appear in every invoice you create. Before you save as a template, replace all real data with placeholder text like "[Customer Name]" or "[Amount Due]."

Another mistake is not testing the template before you rely on it. After you save it, open it once to make sure it works the way you expect. Check that formulas calculate correctly, that formatting looks right, and that placeholder text is clear. If something is wrong, edit the template file itself (not a copy) and save it again.

Finally, don't save a template in a location you can't find later. Word and Excel automatically put templates in the right folder, but if you save a Google Doc or Sheet as a template, make sure you know where it is in your Drive or add it to the template gallery so you can find it quickly.

Frequently Asked Questions

Can I edit a template after I've already created it?

Yes. In Word or Excel, find the template file in your Templates folder (usually in Documents), open it, make your changes, and save it. In Google Docs or Sheets, open the original document, edit it, and save. Any new copies you create from that point forward will include your changes, but old copies you already made won't update automatically.

What's the difference between saving as .dotx and .docx in Word?

A .dotx file is a template — when you open it, Word creates a new unsaved copy so you can't accidentally overwrite the original. A .docx file is a regular document — when you open it, you're editing the actual file. Always use .dotx for templates and .docx for documents you want to keep as-is.

Can I use a template someone else made?

Yes. In Word, Excel, Google Docs, and Google Sheets, you can search for templates built by Microsoft or Google when you create a new document. You can also download templates from websites, though be careful to download from trusted sources. Once you download, save it in your Templates folder or Google Drive and use it the same way you'd use one you built yourself.

What happens if I accidentally save over my template?

If you opened a template and edited it without making a copy first, you've changed the original. Undo your changes immediately by pressing Ctrl+Z (or Cmd+Z on Mac) as many times as needed to get back to the version you want. If you've already closed the file, you may not be able to recover it — this is why it's important to make a copy before editing.

Can I share a template with my team?

In Google Docs or Sheets, share the original document with your team and let them make copies when they need it. In Word or Excel, you can email them the .dotx or .xltx file, and they can save it in their Templates folder. You can also upload templates to a shared drive or cloud storage so everyone on your team can access the same version.