Software & Apps Google Drive How to Create a Google Sheets Template Make a custom template to create a starting point for new spreadsheets By Jack Wallen Writer Jack Wallen is a former Lifewire writer, an award-winning writer for TechRepublic and Linux.com, and the voice of The Android Expert. our editorial process LinkedIn Jack Wallen Updated December 17, 2019 Google Drive Sheets Docs Slides Tweet Share Email Google Sheets has a supply of useful templates. When these templates don't match your needs, create your own template in Google Sheets. Create your own template when you want to share a spreadsheet that has the same design with every use. To make custom Google Sheets templates, copy the spreadsheet contents to Google Sheets and make a copy of the file to always have the original at hand. Instructions in this article apply to Google Sheets. You need a Google account to access Google Sheets. Sign in to Google Sheets with the account you use to access Gmail or YouTube. You can also create a template for Google Docs. What You Need for a Custom Google Sheets Template A Google Sheets custom template contains information specific to the spreadsheet you want to make. To make a custom template, start with a spreadsheet file that contains the information and formatting you want to use in the template. Create the spreadsheet file in any spreadsheet program, such as LibreOffice or Microsoft Excel. You can even make the spreadsheet in Google Sheets, either from scratch or from the Template Gallery. Just open one of those templates and edit it as needed to fit your project. Make a Folder for Custom Templates To keep your custom templates organized, create a folder that will contain only template files. Open Google Drive and go to the root folder (the top folder and not a subfolder). Select New > Folder. In the New folder dialog box, enter a descriptive name for the folder, then select Create. The new folder appears in the list with the other folders in Google Drive. Add Your Template to the Folder To add your custom template to the newly created folder: Open the templates folder you created. Select New > Google Sheets to make an empty spreadsheet that will be used as the template file. If you select From a template, the Google Sheets Template Gallery displays. You cannot upload templates or create a blank template from the Template Gallery. Open the spreadsheet that contains the data you want to use in the template and highlight its contents. To select everything in the spreadsheet, press either the Ctrl+A or Command+A keyboard shortcut. Select Edit > Copy to copy the highlighted content. Or, press Ctrl+C or Command+C. Open the empty spreadsheet you made in Step 2 and select Edit > Paste to paste the spreadsheet contents. Or, press Ctrl+V or Command+V. Select the cell at which you want the paste to take place. For example, if you copied everything in the spreadsheet, select the square to the left of A and above 1 to highlight the entire sheet, then paste the spreadsheet contents. Enter a descriptive name for the template. Select the Google Sheets icon to return to Google Sheets. Use Your Custom Templates When you want to use this custom template to create a new spreadsheet, make a copy of the template file before you make any changes to the original template file. If you edit the original template, you won't have that unaltered template available for use in the future. To make a copy of a template, right-click or tap-and-hold the template file, then choose Make a copy. Then, rename the copy and move the copy to another folder so that you don't accidentally edit the template.