- Create your own template to create a starting point for new spreadsheets.
- What you need for a custom Google Sheets template
- Create a folder for custom templates
- Add your template to the folder
Create your own template to create a starting point for new spreadsheets.
Google Sheets has useful templates. If these templates don’t meet your needs, create your own template in Google Sheets. Create your own template if you want to share a table with the same design every time you use it. To create custom Google Sheets templates, copy the contents of your spreadsheet into Google Sheets and make a copy of the file so you always have the original handy.
The 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.
What you need for a custom Google Sheets template
A custom Google Sheets template contains information about the spreadsheet you want to create. To create your own template, start with a spreadsheet file that contains the information and formatting you want to use in the template.
Create a spreadsheet file in a spreadsheet program such as LibreOffice or Microsoft Excel. You can even create a spreadsheet in Google Sheets, from scratch or from a template gallery. Just open one of these templates and edit it however you want.
Create a folder for custom templates
To keep your custom templates organized, create a folder that contains only template files.
Open Google Drive and navigate to the root folder (the top folder, not the subfolder).
Select New † folder †
In the dialog box new map enter a descriptive name for the folder, then select To create †
The new folder will appear in the list along with 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 create a blank spreadsheet to use as a template file.
if you choose From template , the Google Sheets template gallery opens. You cannot upload templates or create a blank template from the template gallery.
Open the spreadsheet containing the data you want to use in the template and select its contents. To select all items in the spreadsheet, press the hotkey Ctrl+A or Command+A †
Select Change † To copy to copy the selected content. Or click on ctrl+c or Command+C †
Open the blank spreadsheet created in step 2 and select Change † Insert to paste the contents of the worksheet. Or click on Ctrl+V or Command+V †
Select the cell where you want to paste the paste. For example, if you copied everything to a spreadsheet, check the box to the left of A and beyond a to select the entire sheet, then paste the contents of the worksheet.
Enter a descriptive name for the template.
Select the Google Sheets icon to return to Google Sheets.
Use your custom templates
To use this custom template to create a new spreadsheet, make a copy of the template file before making any changes to the original template file. If you edit the original template, you won’t have that unmodified template available for future use.
To make a copy of a template, right-click or right-click on the template file, then select: Make a copy †
Then rename the copy and move the copy to another folder so you don’t accidentally edit the template.