How to Save a Workbook as a Template in Excel

If you find yourself building the same spreadsheet from scratch every single week - whether it’s for a client report, a budget forecast, or a content calendar - you’re spending more time on setup than on actual analysis. Creating an Excel template transforms that repetitive task into a one-and-done setup. This article will show you exactly how to save an Excel workbook as a template so you can stop reinventing the wheel and get straight to the insights.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly is an Excel Template?

An Excel template is quite simply a pre-made workbook that serves as a blueprint for new spreadsheets. Instead of opening a blank sheet, you open a template that already contains your custom formatting, formulas, layouts, charts, and headers. It’s saved as a special file type (.xltx) that, when you open it, creates a brand new, untitled workbook (a standard .xlsx file) instead of overwriting the original template.

Think of it like a reusable stencil. You have the perfect design ready to go, all you have to do is fill in the new information.

Why Should You Bother Using Templates?

Taking a few minutes to set up a template pays off almost immediately. Here’s why:

• It saves boatloads of time. The single biggest benefit is efficiency. No more recreating your monthly sales report’s structure, formulas, and charts on the first Monday of every month. Just open the template, plug in the numbers, and you’re done.
• It promotes consistency. When your whole team uses the same template for invoices or project plans, every document looks professional and uniform. This standardization means you know exactly where to find key information, no matter who created the file.
• It reduces human error. Building spreadsheets from memory invites mistakes. You might forget a key formula, mislabel a header, or mess up the formatting. With a template, your essential formulas, conditional formatting rules, and data validation are already baked in and tested.

How to Save a Workbook as an Excel Template: A Step-by-Step Guide

Turning a regular spreadsheet into a reusable template is a straightforward process. Here’s how to do it, using a simple monthly marketing budget tracker as an example.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Build or Open Your Master Workbook

First, create the spreadsheet you want to turn into a template. Open a new Excel workbook and build it out exactly as you'd want it to look every time you use it. This includes:

• Headers and Labels: Columns like "Campaign," "Channel," "Date," "Budgeted Spend," and "Actual Spend."
• Formulas: A formula in a "Variance" column (e.g., =D2-E2) or a SUM function at the bottom to total your costs.
• Formatting: Custom number formats (like currency), cell colors to distinguish sections, bold headers, and branded fonts.
• Charts and Graphs: A pie chart that visualizes spend by channel or a bar chart comparing budgeted vs. actual spend.
• Dropdown Menus: Use data validation to create a dropdown list for the "Channel" column (e.g., Google Ads, Facebook Ads, Email).

Your goal is to build a complete, ready-to-use worksheet. Here's a stripped-down example:

Create your desired layout, with all formatting and structural elements in place. Don't worry about the specific data just yet.

Step 2: Clean Up Your Workbook

This is a critical step many people forget. Before saving the template, you need to delete any placeholder or example data you used to build it. A template should be a clean, empty canvas.

In our budget example, you'd delete the specific numbers in the "Budgeted Spend" and "Actual Spend" columns and any example campaign names. You want to leave behind only the structure: the headers, the empty cells waiting for data, the zeroed-out formula cells, and the chart which will update automatically once new data is entered.

Step 3: Go to ‘Save As’

Once your workbook is clean and ready, it's time to save it as a template.

Navigate to File in the top-left corner and select Save As. You can also press F12 on your keyboard as a shortcut.

Step 4: Select "Excel Template (*.xltx)"

In the "Save As" window, click the dropdown menu next to "Save as type." It usually defaults to "Excel Workbook (.xlsx)." Scroll through the list and select *Excel Template (.xltx).*

If your workbook contains macros, you'll need to choose Excel Macro-Enabled Template (*.xltm) instead.

From the ‘Save as type’ dropdown, choose ‘Excel Template (.xltx).’*

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 5: Name and Save Your Template

As soon as you select the .xltx file type, you'll notice that Excel automatically changes the save folder location. It typically switches to a default "Custom Office Templates" folder. Do not change this location. Excel needs the template to be in this specific folder so it appears on your "New" workbook screen.

Give your template a clear, descriptive name like "Monthly Marketing Budget Tracker" or "Client SEO Report Template." Click Save.

That's it! You've successfully created and saved your first custom Excel template.

How to Use Your New Custom Template

So you've saved your template. Now, how do you actually use it? The next time you need to create your monthly budget report, follow these simple steps:

1. Open the Excel application.
2. Click on File and then New.
3. On the "New" screen, right below the search bar, you should see tabs like "Office" (or "Featured") and "Personal" (or "Custom"). Click on Personal.

Here you'll see a gallery of all the custom templates you've saved. Just click on your template (e.g., "Monthly Marketing Budget Tracker"), and Excel will instantly open an untitled copy of it. Notice the file name will be something generic like "Monthly Marketing Budget Tracker1.xlsx." This is a brand-new workbook, leaving your original .xltx template file untouched and ready for next time.

Where Does Excel Store Custom Templates?

Sometimes you need to find the actual .xltx file to share it with a coworker, back it up, or delete it. Because Excel whisks it away to a special folder, finding it can be tricky.

The default location is usually:

• For Windows: C:\Users\[Username]\Documents\Custom Office Templates\
• For Mac: /Users/[Username]/Library/Group Containers/UBF8T346G9.Office/User Content.localized/Templates.localized/

Simply navigate to this path in your file explorer to manage your templates directly.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Edit an Existing Excel Template

Let's say you want to add a new formula or change the branding on your template. Your first instinct might be to find the .xltx file and double-click it. Don't do that - it will just create a new workbook from the template instead of editing the template file itself.

To edit the template, you have to open it in a specific way:

1. In Excel, go to File > Open.
2. Click Browse and navigate to your Custom Office Templates folder (using the path mentioned above).
3. Click on your template file (.xltx) and click Open. Now you have opened the original template file itself.

Make your necessary changes, and simply click Save (or hit Ctrl + S). This will overwrite the template file with your new changes. The next time you create a new workbook from it, it will reflect your updates.

Final Thoughts

Custom Excel templates are a simple yet powerful way to bring efficiency and consistency to your repetitive reporting tasks. By investing just a little time upfront to create a solid blueprint, you save yourself hours of tedious rebuilding and reduce the risk of manual errors week after week.

While templates streamline manual spreadsheet work beautifully, they don't eliminate the need to wrangle data in the first place. This is where modern analytics tools can help automate the entire cycle. We built Graphed to connect directly to platforms like Google Analytics, Shopify, and Facebook Ads, letting you build live dashboards simply by asking questions in plain English - no exporting CSVs or filling in templates required.