One of the best features of working with Google apps like Google Sheets is how well they work when you are doing an online collaboration.
But occasionally you will need to create a file that you can share with other people, such as those who aren’t able to work in the Google Sheets app on their Web browser or mobile phone.
Luckily there is a simple Google Sheet to PDF conversion process that you can use to turn your Google spreadsheet into a PDF copy that you can email or share in a variety of different ways.
How to Do a Google Sheet to PDF Conversion
- Open your Google Sheets file.
- Select the File tab.
- Choose Download.
- Click the PDF option.
- Adjust the settings, then click Export.
Our guide continues below with additional information on the Google Sheets to PDF process, including pictures of these steps.
You read more about this feature of Google Sheets with our download Google spreadsheet article.
Sharing a spreadsheet file, such as the ones produced by Google Sheets, will let anyone with access to the file make adjustments, provided that not cell or file protection has been enacted. If your file is finalized, or if you would prefer that people not be able to modify it, then you might be looking for a way to send the file as a PDF instead.
Fortunately, this functionality exists in Google Sheets as default, allowing you to create a PDF from your existing file by following a few steps.
You will even have the option of adjusting some of the settings of the output file so that you can control how it will look and print.
Our convert PDF to Google Doc article can show you how to take a PDF file and edit it using the Google Docs app.
How to Download as a PDF from Google Sheets (Guide with Pictures)
The steps in this article were performed in Google Chrome but will work in other desktop Web browsers as well. Following these steps is going to create a copy of your spreadsheet in the PDF file format.
The original Google Sheets file will remain in Google Drive.
These steps will show you how to convert a Google Sheet to a PDF.
Step 1: Open your Google Drive at https://drive.google.com/drive/my-drive and open the Sheets file that you want to save as a PDF.
Open the Google Sheets file to convert.
Step 2: Click the File tab at the top of the window.
Select the File tab in the top menu.
Step 3: Select the Download as option, then click the PDF document option.
Choose Download as, then PDF document.
Step 4: Adjust the PDF settings in the column at the right side of the window, then click the Export button.
Chose the PDF settings, then click Export.
Now that you know how to convert Google Sheet to PDF you will be able to turn any of your other spreadsheets into a PDF file that you can easily send to other people.
You can read our how to make a CSV file in Google Sheets article for steps on creating another type of useful file.
More Information on How to Save Google Sheets as PDF
As you can see on the final screen before you click the blue Export button, you have a handful of settings that you can adjust for the output PDF copy of your spreadsheet. These export options include:
- Export – you can export only the current worksheet, or the entire workbook. If you have more than one tab in your worksheet then choosing the workbook option is a good way to avoid needing to create multiple documents.
- Paper Size – you can choose a different page size for the PDF copy of the spreadsheet
- Page Orientation – select between Portrait or Landscape
- Scale – choose how you would like the sheet to fit on the page
- Margins – select from a few different options for the page margins
- Set Custom Page Breaks – you can manually select where you want the page breaks to occur
- Formatting – Set options like show gridlines, show notes, page order, alignment
- Headers & footers – Choose to add information like frozen rows, page numbers, sheet name, date, time, etc.
Note that you can elect to export the current sheet or the entire workbook as a PDF, if you so wish.
You can also adjust formatting settings like the orientation of the document, the size of the document, and other options that can affect the output PDF file.
When you convert Google Sheets to a PDF document, the PDF documents may be difficult for the recipient to change if they don’t have an application that can edit files in the PDF format.
Some people would consider this to be a benefit, as the difficulty in editing PDF files is one of their advantages, but it is something to consider when you choose PDF document as the file output type.
When you are electing to turn your data into a different file type with the File > Download option at the top left corner of the window, you have a few different file type options. These include:
- Microsoft Excel (.xlsx)
- Open Document (.odf)
- PDF (.pdf)
- Web Page (.html)
- Comma Separated Values (.csv)
- Tab Separated Values (.tsv)
Are you collaborating on a spreadsheet with a team of people, and you would like to receive notifications when the file is modified? Learn how to set up change notifications in Google Sheets and keep track of the status of your file.
Frequently Asked Questions About How to Convert a Google Sheet to PDF
After converting Google Sheets files to PDFs, how can I edit them?
While there are some options available for editing PDFs like Adobe Acrobat, many of the better options can be expensive.
You may want to try opening the file in an application like Google Docs or Microsoft Word if you want to edit it, or you can use an online file converter to turn it into a CSV file, or back into a spreadsheet.
Generally, it will probably be easier to edit the original Sheets file and re-convert it to a PDF after you have made the necessary changes.
Can I also create PDFs automatically in Google Docs?
Other Google apps have this capability as well, including the word processing application.
You can convert a Google Doc to a PDF if you open the file, click File at the top-left of the window, choose Download as, then select PDF from the list of compatible file download types.
Can I upload a PDF file that I created somewhere else to Google Drive?
Yes, you can save all kinds of different files to Google Drive and access them from other computers or compatible mobile devices.
If you sign into Google Drive you can click the Create button at the top-left of the window, choose the File upload option, then browse to the PDF or other file type that you would like to import to your Google Cloud storage.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.