You’ll need aGoogle accountto access Google Sheets.
Sign in to Google Sheets with the same account you use to accessGmailorYouTube.
Create the spreadsheet file in anyspreadsheet program, such asLibreOfficeorMicrosoft Excel.
Just open one of those templates and edit it as needed to fit your project.
Open Google Driveand go to theroot folder(the top folder and not a subfolder).
In theNew folderdialog box, enter a descriptive name for the folder, then selectCreate.
The new folder appears in the list with the other folders inGoogle Drive.
SelectNew>Google Sheetsto make an empty spreadsheet that will be used as the template file.
If you selectFrom a template, the Google Sheets Template Gallery displays.
You cannot upload templates or create a blank template from the Template Gallery.
launch 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 theCtrl+AorCommand+Akeyboard shortcut.
SelectEdit>Copyto copy the highlighted content.
kick off the empty spreadsheet you made in Step 2 and selectEdit>Pasteto paste the spreadsheet contents.
Select thecellat which you want the paste to take place.
Enter a descriptive name for the template.
opt for Google Sheets icon to return to Google Sheets.
To make a copy of a template, right-click or tap-and-hold the template file, then chooseMake a copy.
