Export Google Sheets as PDF

When you export a Google Sheet to PDF through the native menu, you choose between the current sheet, the full workbook, or specific pages. The Docs to PDF extension exports the active sheet by default when you trigger it from inside the open spreadsheet. For workbook-wide exports, navigate to the file in Google Drive and export from there.

Spreadsheets often have more columns than fit on a standard page. Before exporting, use File > Page Setup to choose the orientation (landscape usually works better for wide spreadsheets) and the scaling option. Setting scaling to 'Fit to page' compresses the sheet to fit on one page. These settings are saved with the document and apply to every export.

By default, Google Sheets does not include gridlines in PDF exports. If you want gridlines visible, go to View > Show > Gridlines and make sure they are enabled, or use the print settings at File > Print and toggle 'Show gridlines' before exporting. The extension picks up whatever print settings are active in the document.

Charts embedded in a Google Sheet export as static images in the PDF. They reflect the data at the moment of export. If the underlying data changes after the export, the chart in the PDF will be outdated. For reports that update regularly, re-export after each data update.

If you want all tabs in a spreadsheet exported as a single PDF, use the print preview in Google Sheets and select 'Workbook' as the scope before the extension triggers the export. Tab order in the PDF matches the tab order at the bottom of the sheet.