Convert Google Sheets to PDF from Drive

Converting Google Sheets to PDF from Drive saves the hassle of opening each spreadsheet and navigating to File > Download. The Docs to PDF extension converts any Google Sheet you select in Drive to a properly formatted PDF without you needing to open it.

1

How Google Sheets converts to PDF

The extension calls Google's export API using the spreadsheet's file ID and your Drive credentials. Google renders the PDF on its own servers using the same engine as File > Download > PDF inside the Sheets editor. The output includes all visible data, formatting, and charts. Print area settings and page break settings from the spreadsheet are respected.

2

Page layout for spreadsheet PDFs

Spreadsheets often contain wide tables that need landscape orientation. Set the page orientation in Google Sheets under File > Page setup before converting. Landscape orientation ensures columns are not cut off in the PDF. Also set the print area in Sheets if you only need a specific range, and that range will appear in the PDF.

3

Gridlines and formatting options

By default, Google Sheets exports with gridlines visible. To suppress gridlines, go to File > Page setup > Sheet in Sheets and uncheck 'Gridlines'. The extension respects this setting. Headers and footers, column and row headers, and page breaks are all controlled in the Sheets page setup before you run the extension.

4

Charts in Sheets PDFs

Charts created in Google Sheets export as static images in the PDF. The chart data is rendered at the point of export. If the underlying data has changed since the last view, refresh the Sheets tab before converting to ensure the chart reflects current data.

5

Converting multiple sheets at once

Selecting multiple spreadsheets in Google Drive and running the extension converts each one as its own PDF. Each PDF covers the entire spreadsheet, following the print area and page setup of each individual file. The extension does not merge multiple spreadsheets into a single PDF unless you use the merge feature.

Frequently Asked Questions

How do I convert a Google Sheet to PDF from Drive?

Select the spreadsheet in Google Drive and click the Docs to PDF extension icon. The PDF downloads immediately. The output matches the print settings configured in the Sheets file.

Can I convert only one tab from a Google Sheet?

Yes. Open the spreadsheet, navigate to the specific tab, and use File > Download > PDF from inside the editor to export just that tab. Alternatively, hide the tabs you do not want to include before running the extension from Drive.

Why are my columns cut off in the exported PDF?

The spreadsheet is set to portrait orientation and the columns are too wide. Open the Sheets file, go to File > Page setup, and switch to landscape. Then re-export.

Can I remove gridlines from the exported PDF?

Yes. In the Sheets editor, go to File > Page setup > Sheet and uncheck Gridlines. The next export will not include gridlines.

Is there a free way to convert Google Sheets to PDF from Drive?

Yes. The free plan of the extension covers Sheets conversion. There are no watermarks. A monthly conversion limit applies.

Ready to Convert?

Join thousands of users who convert their Google Docs to PDF every day with our free Chrome extension.

Install Free Extension