How to Convert Google Sheets to PDF

To share something you’re tracking in a spreadsheet, such as For example, company finances, club information or a team roster, you can use a PDF file instead of a spreadsheet. We’ll show you a few ways to convert Google Sheets to PDF.

Depending on how you want to share the file, you can easily download, save and send as you like. Alternatively, you can post a link to the file on your website so others can view the sheet as a PDF. This is especially useful if you plan to make updates to the PDF file in the future.

Download Google Sheets as PDF

If you want to send the PDF file via email, SMS or chat application, you can easily download it in PDF format.

TIED TOGETHER: How to create a PDF from a Google Docs document

Visit Google Sheets, open the workbook and do one of the following:

  • To convert specific cells, select them.
  • To convert a specific table, activate it by opening that table.
  • To convert the entire workbook, you don’t need to select anything, just go to the next step.

Go to File > Download and select PDF from the pop-out menu.

PDF in Google Sheets download menu

Use the Export drop-down menu at the top right to choose from the current sheet, entire workbook, or selected cells. Then adjust the paper size and page orientation to your liking.

Export options for PDF download

Next, you can scale to fit the width, height, or side, and make the margins narrow or wide as needed.

Scaling and margin settings for a PDF download

Then you can use the Formatting and Headers & Footers sections at the bottom of the sidebar. For formatting, you can check options to show or hide the gridlines and notes, and adjust alignment.

Formatting options for the PDF download

For headers and footers, you can check options to include page numbers, the sheet or workbook name, and the current date and time. You can also click Edit Custom Fields to view or add these options. Finally, check the boxes if you want to repeat the frozen rows or columns in your sheet.

Header and footer options for PDF download

When you’re done, click Export in the top right. The file will download and appear in your default download location.

PDF download preview and export button

Publish a link to the PDF

If you have a website where you want to share the spreadsheet or workbook as a PDF for others to view, this is another option.

TIED TOGETHER: How to share a Google Docs, Sheets or Slides file as a webpage

Choose File > Share and choose Publish to Web from the pop-out menu.

Publish to the web in the Google Sheets Share menu

When the publish box opens, confirm that you are on the Link tab. If you want to convert a specific sheet instead of the entire workbook, click the Entire document drop-down menu and select it.

Drop-down to select the sheet or the entire workbook

Then click the Web Page drop-down menu and select PDF Document (.pdf).

PDF in the file format list

Optionally, expand the Published Content and Settings section and check the option to automatically republish when you make changes to the sheet or workbook.

Automatically republish changes check box selected

Select “Publish” or “Start publishing” and confirm with “OK”.

Confirmation of publication of the PDF

You can then select and copy the URL, add it to a Gmail message, or share it on Facebook or Twitter.

Copy or share link options

If you later decide to unpublish the file, return to File > Share > Publish to Web. Expand the Published Content & Settings section and select Stop Publishing. Then confirm with “OK” in the pop-up window.

Stop Publishing button

Creating a PDF from your spreadsheet or workbook is a great way to share Google Sheets data with others. If you use Microsoft Excel alongside Google Sheets, check out how to save an Excel spreadsheet as a PDF as well.

Leave a Reply

Your email address will not be published. Required fields are marked *