[et_pb_section fb_built=”1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
This five-step tutorial will show you how to convert Google Sheets to PDF. PDF is an abbreviation that stands for Portable Document Format. PDFs allow you to save files that others can\u2019t modify but are easily shared and printed.<\/p>\n
By the end of this article, you will wield the power to convert Google Sheets to PDF manually or using the Sheetgo automation.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Navigate to and open the Google Sheets file. You can locate your Google Sheets files in a few ways:<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/How-To-Convert-Google-Sheets-To-PDF-1.png” alt=”How To Convert Google Sheets To PDF 1″ title_text=”How To Convert Google Sheets To PDF 1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Print settings will open, showing two screens. On the left, you\u2019ll see what your PDF will look like. On the right, you\u2019ll see formatting options for your PDF download.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/How-To-Convert-Google-Sheets-To-PDF-2.png” alt=”How To Convert Google Sheets To PDF 2″ title_text=”How To Convert Google Sheets To PDF 2″ align=”center” _builder_version=”4.20.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
You can configure several options in the print settings:<\/p>\n
Export: <\/b>Specify the contents of your Google Sheet that you want to convert into a PDF. You can choose from the current sheet, the entire workbook, or selected cells.<\/p>\n
Selection:<\/b> Specify which sheets you want to download if you selected \u201cworkbook\u201d in the export dropdown. You can download all the sheets in the workbook or choose and exclude specific ones.<\/p>\n
Paper size:<\/b> Your Google sheet will be on the default paper size for printer paper; Letter (8.5\u201d x 11\u201d). You can change it to any size you want using the dropdown or create a custom size.\u00a0<\/p>\n
Page orientation:<\/b> Specify whether the exported file should be portrait or landscape.<\/p>\n
Scale: <\/b>Specify if you want the page orientation in landscape or portrait orientation.\u00a0<\/p>\n
Margins: <\/b>Specify if you want the margins to stay Normal (Default), narrow, wide, or a custom margin.<\/p>\n
To print or export only part of a sheet, see how to set a print area in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can configure several options in the formatting settings:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/How-To-Convert-Google-Sheets-To-PDF-3.png” alt=”How To Convert Google Sheets To PDF 3″ title_text=”How To Convert Google Sheets To PDF 3″ align=”center” _builder_version=”4.20.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Show gridlines:<\/b> Specify whether you want to show gridlines by checking or unchecking the box. Gridlines are the horizontal and vertical lines that separate the cells in a worksheet.<\/p>\n Show notes:<\/b> Specify if you want the PDF to display notes in the exported PDF file. Sheets will export any notes as footnotes.<\/p>\n Page order:<\/b> Specify the page order as \u201cOver, then under\u201d or \u201cDown, then over\u201d<\/p>\n Horizontal Alignment:<\/b> Specify whether you want the contents of the PDF download aligned \u201cCenter,\u201d \u201cLeft,\u201d or \u201cRight.\u201d<\/p>\n Vertical Alignment:<\/b> Specify whether you want the contents of the PDF download aligned \u201cTop,\u201d \u201cBottom,\u201d or \u201cCenter.\u201d<\/p>\n Headers and Footers: <\/b>Specify if you want to show page numbers, workbook title, sheet name, current date, or current time in the header or footer.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Scroll back to the top and click the blue \u201cExport\u201d button.\u00a0<\/p>\n Your download should appear at the bottom of your browser window on Chrome and most other browsers. You can also locate your download in the Downloads folder on your Mac or Windows laptop.<\/p>\n [\/et_pb_text][et_pb_text module_id=”sheetgo” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Using the Sheetgo web app, you can create a 100% automated workflow. Sheetgo can identify the rows of data within your Google Sheet, transfer and add this data to any document you wish, convert the document into a PDF, and then send it to its recipient. All you need to do is set up the workflow. Provide your spreadsheet full of your data and the document template you wish to add your data.<\/p>\n Sheetgo handles everything else.<\/p>\n Why is this better than converting Google Sheets to PDF manually?<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Signing up for Sheetgo is easy. Simply click the blue button below.<\/p>\n Log in with your Google, Microsoft, or Dropbox account to start.<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/automations.sheetgo.com\/login” url_new_window=”on” button_text=”Start free trial” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”30px||30px||true|false” custom_padding=”15px|20px|15px|20px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Before creating your workflow, you\u2019ll need two files ready:\u00a0<\/p>\n Let\u2019s look at these in more detail.<\/p>\n Your source data file should contain all the dynamic data you need to create your desired document. In this example, my Google Sheets file contains all the intern information I need to create the contracts and convert them as PDFs.<\/p>\n You should name each column clearly. These columns will become the dynamic tags in your document template, where Sheetgo will transfer your spreadsheet data. Each row of data in your spreadsheet will create a new document.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/How-To-Convert-Google-Sheets-To-PDF-4.png” alt=”How To Convert Google Sheets To PDF 4″ title_text=”How To Convert Google Sheets To PDF 4″ align=”center” _builder_version=”4.20.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You also need a document template created in Google Docs.<\/p>\n This should contain two things:<\/p>\n In my example, I have created a Google Doc with the foundational content of the main contract text and variable placeholders for each intern\u2019s personal information.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/How-To-Convert-Google-Sheets-To-PDF-5.png” alt=”How To Convert Google Sheets To PDF 5″ title_text=”How To Convert Google Sheets To PDF 5″ align=”center” _builder_version=”4.20.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that your source file and document templates are ready, it\u2019s time to create your workflow.<\/p>\n Open the Sheetgo web app. Select + New workflow on the homepage, then Connect files to build your workflow from scratch. Rename your new workflow at the top. I\u2019ll name my new workflow \u201cInternship Contracts 2022\u201d in my example.<\/p>\n You can add single or multiple source files to begin your workflow. In this case, I want to add my Google Sheets, so I will select Single file, then upload my spreadsheet. Don\u2019t forget to choose the tab where your data is in your file.<\/p>\n Once finished, press Next.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/How-To-Convert-Google-Sheets-To-PDF-6.png” alt=”How To Convert Google Sheets To PDF 6″ title_text=”How To Convert Google Sheets To PDF 6″ align=”center” _builder_version=”4.20.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now it\u2019s time to add your document template. Under the \u2018Generate\u2019 section, select Documents. Upload your document template. You can change the title of your documents to clearly identify each document Sheetgo will create using your source data.<\/p>\n In my example, I can use the dynamic tags from my source data to identify each contract by intern name. To do this, I can type the document title as \u201cInternship contract \u2013 {{First name}} {{Last name}}.<\/p>\n Finally, choose the destination file for these new documents.<\/p>\n Once completed, click Next.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/How-To-Convert-Google-Sheets-To-PDF-7.png” alt=”How To Convert Google Sheets To PDF 7″ title_text=”How To Convert Google Sheets To PDF 7″ align=”center” _builder_version=”4.20.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This connection will allow every new row of your data to be transferred into an individual document based on your template. Now let\u2019s continue to convert these new documents into a PDF.<\/p>\n To convert your newly created documents into a PDF, head to the \u2018Generate\u2019 section and select PDF. Select or create a destination folder where you want to save these PDFs.<\/p>\n Once finished, click Next.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/How-To-Convert-Google-Sheets-To-PDF-8.png” alt=”How To Convert Google Sheets To PDF 8″ title_text=”How To Convert Google Sheets To PDF 8″ align=”center” _builder_version=”4.20.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This connection now means that every new document created in the previous connection will be converted as a PDF automatically by Sheetgo. You will have the original document and the PDF in your files.<\/p>\n You can opt to send these PDFs to their recipients automatically. Sheetgo can discover the email addresses within your source data and send each new document to its intended recipient via Gmail.<\/p>\n To do this, head to the \u2018Share\u2019 section and click Email<\/b>. Select the Get dynamically from a column<\/b> option and select the email address column. You can send your new documents as an access link or an attachment. Finally, you can edit the email subject \u2013 here, I will use my dynamic tags to personalize the subject line.<\/p>\n <\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/How-To-Convert-Google-Sheets-To-PDF-9.png” alt=”How To Convert Google Sheets To PDF 9″ title_text=”How To Convert Google Sheets To PDF 9″ align=”center” _builder_version=”4.20.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”convert” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Once completed, click Finish<\/b> and save<\/b>.<\/p>\n There you have it.<\/p>\n We answered, \u201cHow to convert Google Sheets to PDF.\u201d Now you have two ways to convert Google Sheets to PDF. Google Sheets is a powerful tool that allows you to share sheets as PDFs across the internet or among small groups. You can convert your Google Sheets to PDF automatically using the Sheetgo web app<\/a> to get even more out of Google Sheets.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n \u21d2 Watch the video below and learn how to automatically convert Google Sheets to PDF.<\/p>\n [\/et_pb_text][et_pb_video src=”https:\/\/www.youtube.com\/watch?v=2_5CF1Cmsec” _builder_version=”4.21.2″ _module_preset=”default” width=”90%” module_alignment=”center” height=”90%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_video][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" This five-step tutorial will show you how to convert Google Sheets to PDF. PDF is an abbreviation that stands for Portable Document Format. PDFs allow you to save files that others can\u2019t modify but are easily shared and printed. By the end of this article, you will wield the power to convert Google Sheets to […]<\/p>\n","protected":false},"author":40,"featured_media":41999,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-38653","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/38653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=38653"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/38653\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/41999"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=38653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=38653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=38653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Step 4: Configure the formatting settings<\/h3>\n
Step 5: Click the blue \u201cExport\u201d button<\/h3>\n
Sheetgo: Convert Google Sheets to PDF automatically<\/h2>\n
\n
Step 1: Sign up for Sheetgo<\/h3>\n
Step 2: Prepare your spreadsheet data and document template<\/h3>\n
\n
\u200b\u200bSource data file:<\/h4>\n
Document template:<\/h4>\n
\n
Step 3: Create your workflow<\/h3>\n
Step 4: Connect your source file to your document template<\/h3>\n
Step 5: Convert your new documents to PDF automatically<\/h3>\n
Step 6 (optional): Share your PDFs automatically via Gmail<\/h3>\n
Convert Google Sheets to PDF<\/h2>\n