{"id":3470,"date":"2016-01-01T12:50:35","date_gmt":"2016-01-01T18:50:35","guid":{"rendered":"https:\/\/www.vertex42.com\/blog\/?p=3470"},"modified":"2019-06-04T15:16:27","modified_gmt":"2019-06-04T21:16:27","slug":"how-to-access-templates-for-google-sheets-and-docs","status":"publish","type":"post","link":"https:\/\/www.vertex42.com\/blog\/help\/how-to-access-templates-for-google-sheets-and-docs.html","title":{"rendered":"How to Access Templates for Google Sheets and Docs"},"content":{"rendered":"

\"How<\/p>\n

After you have previewed a template for Google Sheets or Google Docs and decide you want to use the template, what is the best way to get a copy you can edit<\/em><\/strong>?<\/p>\n

What To Do<\/strong>: Click on the Use Template<\/strong> button. If you don't see the Use Template button, then go to File > Make a Copy<\/strong>. These actions place a copy of the template on your Google Drive for you to use and edit.<\/p>\n

If you click on View Only > Request Edit Access<\/strong>, you are requesting access to edit the original template, and I don't grant access to edit the original. Instead, you need to get your own copy of the file, and you do that by going to File > Make a Copy<\/strong>.<\/p>\n

NOTE<\/strong>: If you see the original template listed in your Google Drive (the owner will be listed as jonwittwer or jon), then you can safely delete that from your Google Drive. This will not delete the original - it is only a pointer to the original template.<\/p>\n

How to Open Excel Templates in Google Sheets<\/h2>\n

Within Google Drive, go to New > File Upload<\/strong> and select the Excel file from your computer. To find the file you uploaded in Google Drive, click on the Recent<\/strong> tab in the left sidebar. Double-click on the file you uploaded then click on Open With Google Sheets<\/strong>. <\/p>\n

Google Sheets recently made it possible to edit Excel files without having to first convert them to Google Sheets. If you still want to convert the Excel file to Google Sheets, you can do that by clicking on File > Save as Google Sheets<\/strong> as shown in the image below.<\/p>\n

\"How<\/p>\n

Not all of my Excel templates<\/a> are fully compatible with Google Sheets. Although Google Sheets is rapidly getting better, there is still a long way to go before it can do everything Excel can do. For that reason, I usually have to create separate templates specifically for Google Sheets.<\/p>\n

If there is an Excel template on Vertex42.com that you would like to work with in Google Sheets, please request it by commenting below.<\/p>\n","protected":false},"excerpt":{"rendered":"

To access a template for Google Sheets or Google Docs, either click on USE TEMPLATE, or go to File > Make a Copy. Do not click on Request Edit Access.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[56],"tags":[],"class_list":{"0":"post-3470","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-help"},"_links":{"self":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/posts\/3470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/comments?post=3470"}],"version-history":[{"count":0,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/posts\/3470\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/media?parent=3470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/categories?post=3470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/tags?post=3470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}