In this tutorial, you will learn how to convert Google Sheets to PDFs.
How To Convert Google Sheets To PDF
Quick Navigation
You may come across a situation where you need to share your spreadsheet with someone who does not have a Google account or to archive your data in an easily readable and sharable format.
Fortunately, Google Sheets makes it easy to convert your spreadsheet into a PDF document. PDF documents are advantageous because they are universally compatible with different devices. They are also essential if you need to print out your data in any way.
In this guide, we will show you how to convert your Google Sheets spreadsheet into a PDF file.
We will also provide some tips on how to customize the output of your PDF document.
How To Export a Google Sheets Document as a PDF
Here’s how to export a Google Sheets document as a PDF.
Step 1
Navigate to the spreadsheet you want to convert into a PDF.
Before exporting to a PDF, you may highlight a select area that you want to include in the PDF. Otherwise, Google Sheets will try to print the entire sheet.
Step 2
Next, click on the option File > Download > PDF (.pdf).
Step 3
The user will be led to a Print settings screen. This screen will give the user a preview of what the PDF will look like.
Step 4
Users can modify several different options for the conversion to PDF. For example, users can choose whether to export the current sheet or a selection the user has made prior.
The user may also modify the paper size, page orientation, scale, and margins of the output document.
Step 5
Select formatting options are also available. For example, users can either show or hide gridlines or notes in the final product.
Step 6
Users can also control which elements to add as headers and footers.
For example, users may want to add the sheet name, current date and time, and the page number as a header or footer.
Step 7
Once the user is satisfied with the options, they can click on the Export button to download the PDF file through their browser.
Summary
This guide should be everything you need to convert Google Sheets to PDF.
You may make a copy of this example spreadsheet to test it out on your own.