You have a workbook with a perfect layout, formulas, and formatting that you use repeatedly. You want to protect this master file from accidental changes while making it easy to start new projects. Saving the file as an Excel template creates a reusable blueprint. This article explains how to save your workbook as a .xltx template file and use it to generate new, untitled workbooks.
Key Takeaways: Creating and Using Excel Templates
- File > Save As > Browse > Save as type > Excel Template (*.xltx): Saves your current workbook as a reusable template file in your user templates folder.
- File > New > Personal: Opens a new workbook based on a saved personal template without altering the original .xltx file.
- Excel Template (*.xltx) vs Excel Macro-Enabled Template (*.xltm): Use .xltx for standard workbooks and .xltm only if your file contains VBA macros.
What an Excel Template Does
An Excel template is a pattern for new workbooks. When you save a file as a template with the .xltx extension, Excel stores it in a special system folder. Opening this template file does not open the .xltx file itself. Instead, Excel creates a new, unsaved workbook that is an exact copy of the template’s content and structure. The original .xltx file remains unchanged in its folder. This protects your master layout, formulas, and predefined styles. Any changes you make are saved to the new workbook, not the template. You need a completed workbook with the desired layout, headers, formulas, and formatting before you create a template.
Steps to Save Your Workbook as a Template
- Prepare your master workbook
Open the Excel file you want to use as a template. Ensure all sheets have the correct layout, column widths, cell formatting, and formulas. Remove any sample data you do not want to appear in new files, leaving only the structure and static labels. - Open the Save As dialog
Click File in the ribbon. Select Save As from the left-hand menu. Then click the Browse button to open the full Save As dialog window. - Choose the template file type
In the Save As dialog, navigate to where you want to save the file. Click the dropdown menu labeled “Save as type.” Scroll down and select “Excel Template (*.xltx)”. If your workbook contains VBA macros, you must select “Excel Macro-Enabled Template (*.xltm)” instead. - Name and save the template
Excel will automatically switch the save location to your user’s custom Office templates folder. Give your template a clear, descriptive name in the “File name” box. Click Save. Your original .xlsx workbook remains open and unchanged.
Using a Saved Template to Create a New Workbook
- Start a new file from the template
Close any open workbooks. Click File > New. Under the search bar, click the “Personal” tab. You will see thumbnails of all your saved .xltx and .xltm files. - Open the template
Click on the thumbnail for your template. Excel opens a new, unsaved workbook with “Book1” in the title bar. This file contains all the content from your template but is a completely separate document. - Work in the new file
Add your data, make changes, and perform calculations. When you save this file, you will be prompted to give it a name and choose a location. The original .xltx template file remains protected and unchanged.
Common Template Mistakes and Limitations
Template Opens in Edit Mode Instead of Creating a New File
If double-clicking your .xltx file opens the template itself for editing, you saved it to the wrong location. The file must be in your user’s designated Templates folder for Excel to recognize it as a template. Move the .xltx file from your Documents or Desktop folder to this path: C:\Users\[YourUsername]\Documents\Custom Office Templates. After moving it, use File > New > Personal to access it correctly.
Formulas Referencing Other Files Break in New Workbooks
If your master workbook has formulas with links to other Excel files, those links will point to the original file paths. They may return errors in new workbooks created from the template. Before saving as a template, convert these external links to values or update the formulas to use relative references within the template itself.
Default Save Location is Inconvenient
Excel defaults to saving templates in your user folder. You can save a .xltx file to a network drive or shared location for team use. However, other users must copy the file to their own Personal Templates folder or use File > Open to browse to the network location each time. It will not appear in their File > New > Personal tab automatically.
Excel Template vs Regular Workbook: Key Differences
| Item | Excel Template (.xltx) | Regular Workbook (.xlsx) |
|---|---|---|
| Primary Use | Blueprint for creating new, identical workbooks | Working document for data entry and analysis |
| File Opening Behavior | Creates a new, unsaved copy (Book1) | Opens the actual file for direct editing |
| Default Save Location | User’s Custom Office Templates folder | Any user-selected folder (Documents, Desktop) |
| Risk to Original File | Protected; changes are not saved to the .xltx | High; changes overwrite the original .xlsx |
| Access Method | File > New > Personal tab | File > Open or double-click in File Explorer |
You can now protect your master layouts by saving them as .xltx template files. Use File > New > Personal to start fresh workbooks from these templates anytime. For more control, explore creating a default template named “Book.xltx” that Excel uses for all new blank workbooks. Remember to use the .xltm format if your template includes macros to automate repetitive tasks.