Caleb's Templates

Guide · 2026-10-16

How to make a copy of a Google Sheets template

A step-by-step walkthrough of opening your template's START-HERE PDF, making your own copy in Google Sheets and getting set up, plus what to do when something looks wrong.

You bought a Google Sheets template, you have a download, and now you want a spreadsheet you can actually type into. The step that trips most people up is the very first one: making your own copy. This guide walks through it slowly, so you can do it in a few minutes and know what to do if something looks different from what you expected.

Why you need to make a copy

A Google Sheets template is a file that lives in the seller's Google account. You can look at it, but you can't type in it, and it isn't yours. When you make a copy, Google duplicates the whole spreadsheet into your own Google Drive. From then on it is your file: your numbers, your formulas, your name on it. The seller can't see your copy or anything you type into it.

It also means you can make as many copies as you need for your own use, for example a fresh one at the start of each year. Each purchase is for one person or one business, so please don't share the links with others.

What you get with a purchase

Every template from Caleb's Templates comes as a small bundle:

  • A START-HERE PDF with two Make a copy buttons.
  • A ready-to-use copy, which is the clean version with no data in it.
  • A Sample copy, which is the same template filled with made-up example data so you can see how it behaves.
  • A step-by-step guide in PDF form.

The START-HERE PDF is the only file you need to open first. Everything else is reached from there.

Step by step

  1. Download the files. After you buy, you get a download link. Save the START-HERE PDF somewhere you can find it, like your Downloads folder or your Desktop.
  2. Sign in to Google. Open Google Sheets or Gmail in your browser and make sure you are signed in to the Google account you want the copy to live in. This matters. The copy goes to whichever account is signed in when you click the button. If you have a work account and a personal account, check which one is active.
  3. Open the PDF. Use any PDF viewer. A browser tab works fine.
  4. Click a Make a copy button. The first button makes the ready-to-use copy. The second makes the Sample copy. If you are new to the template, it can help to make the Sample copy first and click around with the example data, then make the ready-to-use copy for your own information.
  5. Confirm in Google. A page opens that says something like "Make a copy". Check the name, choose the folder if it asks, and click the button. Google creates the file and opens it.
  6. Rename and find it again. The new file usually starts with "Copy of" in the name. Rename it to something you will recognise, such as the template name and the year. It now sits in your Drive, in My Drive or the folder you chose.

If you want to double-check where it went, open drive.google.com and look under Recent.

First five minutes inside the sheet

Every Caleb's Templates sheet opens on a tab called Start Here. It has a short setup checklist, a map of how the tabs fit together, and links that jump to each tab. Work down the checklist in order. Setup is usually a handful of steps on a Settings tab: typing your business or household name, a start month where the template has a tax year, and any lists, such as your categories.

A few habits that save trouble:

  • Type in the white cells. Shaded cells calculate automatically. If you try to change one, Google Sheets shows a warning: click Cancel.
  • Add new entries at the bottom. Type in the next empty row at the bottom of a table rather than inserting rows in the middle, because the formulas are set up for the rows already there. Sorting and filtering are safe.
  • Don't delete columns. Hiding a column is safe. Deleting one can break formulas that point at it.

Using it on a phone or tablet

Templates open in the Google Sheets app and in any mobile browser, and you can enter data there. Setup is easiest on a computer because there is more screen to work with. A common pattern is to set the template up once on a laptop and then log entries from your phone.

If something looks wrong

  • The button says you need access. You are probably signed in to a different Google account than the one you meant to use, or not signed in at all. Sign in, then click the button again.
  • The file opened but I can't type in it. You may be looking at the original instead of your copy. Check that the name starts with "Copy of" or the new name you gave it, and that it is in your own Drive.
  • Formulas show errors right after copying. Give it a moment to finish loading, then refresh the page. If it persists, go back through the Start Here checklist and the Settings tab, and if you are still stuck, contact us with the template name and a screenshot.
  • I made the copy in the wrong account. Nothing is lost. Sign in to the right account and click the button again, then delete the extra copy.
  • I can't find my copy later. Search for the template name at drive.google.com, or open Google Sheets and look at the recent files list.

A word about Google Sheets limits

Google Sheets is free and flexible, but it has limits worth knowing. Very large logs, many thousands of rows with heavy formulas, can slow down, especially on a phone. Sheets works best with a stable internet connection, and although you can turn on offline access in Google Drive settings, setup and big edits are smoother online. These templates avoid add-ons and scripts, so there is nothing extra to install or to expire, but they also don't do things only a script could, like sending automatic emails.

Keep an original, then keep going

Before you start filling in your own data, it can be worth making a second copy of the blank file and tucking it in a folder called Originals. If you ever want to start fresh, you can copy it again instead of clearing out cells by hand.

When you are comfortable with the process, browse the templates below to find the one that fits what you are tracking. The same copy steps apply to every one of them. The Client Tracker is a good first choice for keeping client and job details in one place, the Small Business Pricing Calculator helps you price your work, and photographers can look at the Photographer CRM & Client Tracker. You can also browse all the Photographers and Small Business Basics templates.