{"id":499327,"date":"2022-10-08T21:00:49","date_gmt":"2022-10-08T18:00:49","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-convert-google-sheets-to-pdf\/"},"modified":"2022-10-08T21:00:49","modified_gmt":"2022-10-08T18:00:49","slug":"how-to-convert-google-sheets-to-pdf","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-convert-google-sheets-to-pdf\/","title":{"rendered":"#How to Convert Google Sheets to PDF"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2de1f2d7afc\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2de1f2d7afc\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-google-sheets-to-pdf\/#%E2%80%9CHow_to_Convert_Google_Sheets_to_PDF%E2%80%9D\" >&#8220;How to Convert Google Sheets to PDF&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-google-sheets-to-pdf\/#Download_Google_Sheets_as_a_PDF\" >Download Google Sheets as a PDF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-google-sheets-to-pdf\/#Publish_a_Link_to_the_PDF\" >Publish a Link to the PDF<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Convert_Google_Sheets_to_PDF%E2%80%9D\"><\/span>&#8220;How to Convert Google Sheets to PDF&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\"\/><\/p>\n<p>To share something you track in a spreadsheet like company financials, club information, or a team roster, you can use a PDF instead of a spreadsheet. We\u2019ll show you a couple of ways to convert Google Sheets to a PDF.<\/p>\n<p>Depending on how you plan to share the file, you can simply <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">download<\/a>, save, and send it however you like. Alternatively, you can publish a link to the file on your site for others to view the sheet as a PDF. This is especially useful if you plan to make updates to the PDF in the future.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Download_Google_Sheets_as_a_PDF\"><\/span>Download Google Sheets as a PDF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you plan to send the PDF file via email, text message, or chat application, you can easily <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/449707\/how-to-create-a-pdf-from-a-google-docs-document\/\">download it in PDF form.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create a PDF from a Google Docs Document<\/em><\/strong><\/p>\n<p>Visit Google Sheets, open the workbook, and do one of the following:<\/p>\n<ul>\n<li>To convert specific cells, select them.<\/li>\n<li>To convert a certain spreadsheet, make it active by opening that sheet.<\/li>\n<li>To convert the entire workbook, you don\u2019t have to select anything, just go to the next step.<\/li>\n<\/ul>\n<p>Go to File &gt; Download and select \u201cPDF\u201d in the pop-out menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831684\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/DownloadPDF-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"PDF in the Google Sheets Download menu\" width=\"598\" height=\"474\"\/><\/p>\n<p>On the top right, use the Export drop-down menu to pick from the current sheet, entire workbook, or selected cells. Then adjust the paper size and page orientation per your preference.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831689\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/ExportOptions-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Export Options for the PDF download\" width=\"456\" height=\"252\"\/><\/p>\n<p>Next, you can scale to fit the width, height, or page and make the margins narrow or wide as needed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831688\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/ScaleMargins-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Scale and Margin settings for a PDF download\" width=\"455\" height=\"397\"\/><\/p>\n<p>Then, you can use the Formatting and Headers &amp; Footers sections at the bottom of the sidebar. For Formatting, you can mark options for showing or hiding the gridlines and notes and adjusting the alignment.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831687\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/Formatting-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formatting options for the PDF download\" width=\"290\" height=\"393\"\/><\/p>\n<p>For Headers &amp; Footers, you can mark options to include page numbers, the sheet or workbook name, and the current date and time. You can also click \u201cEdit Custom Fields\u201d to view or add these options. Finally, check the boxes if you want to repeat the\u00a0frozen rows or columns in your sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831686\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/HeadersFooters-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Header and Footer options for the PDF download\" width=\"290\" height=\"436\"\/><\/p>\n<p>When you finish, click \u201cExport\u201d on the top right. The file will download and appear in your default Downloads location.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-831700 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/PrintPreviewExport-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"PDF download preview and Export button\" width=\"650\" height=\"405\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Publish_a_Link_to_the_PDF\"><\/span>Publish a Link to the PDF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you have a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/442426\/how-to-share-a-google-docs-sheets-or-slides-file-as-a-web-page\/\">website where you want to share the spreadsheet or workbook as a PDF for others to view, this is another option.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Share a Google Docs, Sheets, or Slides File as a Web Page<\/em><\/strong><\/p>\n<p>Select File &gt; Share and pick \u201cPublish to Web\u201d in the pop-out menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831690\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/SharePublishToWeb-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Publish to Web in the Google Sheets Share menu\" width=\"595\" height=\"277\"\/><\/p>\n<p>When the publish box opens, confirm that you\u2019re on the Link tab. Click the Entire Document drop-down menu if you want to convert a specific sheet instead of the whole workbook and select it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831691\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/PublishBookSheet-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Drop-down to choose the sheet or entire workbook\" width=\"503\" height=\"289\"\/><\/p>\n<p>Then, click the Web Page drop-down menu and pick \u201cPDF Document (.pdf).\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-831692 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/PublishPDF-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"PDF in the file format list\" width=\"560\" height=\"422\"\/><\/p>\n<p>Optionally, you can expand the Published Content &amp; Settings section and mark the option to automatically republish when you make changes to the sheet or workbook.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831693\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/Republish-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Automatically republish changes checkbox marked\" width=\"503\" height=\"500\"\/><\/p>\n<p>Select \u201cPublish\u201d or \u201cStart Publishing\u201d and confirm by clicking \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831694\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/PublishConfirm-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Confirmation to publish the PDF\" width=\"444\" height=\"102\"\/><\/p>\n<p>You can then select and copy the URL, add it to a Gmail message, or share it on <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> or Twitter.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831695\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/CopyLink-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Copy or share the link options\" width=\"520\" height=\"374\"\/><\/p>\n<p>If you decide later to unpublish the file, return to File &gt; Share &gt; Publish to Web. Expand the Published Content &amp; Settings section and choose \u201cStop Publishing.\u201d Then, confirm with \u201cOK\u201d in the pop-up box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-831696\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/StopPublishing-GoogleSheetToPDF.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Stop Publishing button\" width=\"401\" height=\"500\"\/><\/p>\n<p>Creating a PDF from your spreadsheet or workbook is a great way to share the data from Google Sheets with others. If you use Microsoft Excel in addition to Google Sheets, look at how to save an Excel sheet as a PDF too.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/831665\/how-to-convert-google-sheets-to-pdf\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Convert Google Sheets to PDF&#8221; To share something you track in a spreadsheet like company financials, club information, or a team roster, you can use a PDF instead of a spreadsheet. We\u2019ll show you a couple of ways to convert Google Sheets to a PDF. Depending on how you plan to share the&#8230;<\/p>\n","protected":false},"author":1,"featured_media":499328,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-499327","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/499327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=499327"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/499327\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/499328"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=499327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=499327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=499327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}