Convert an Entire Google Sheets Workbook to PDF
Exporting an entire Google Sheets workbook to PDF means every sheet in the file becomes part of a single PDF, with each sheet starting on a new page. This is the right option when sharing a complete dataset or report where all tabs are relevant to the recipient.
Setting up a full workbook export
In Google Sheets, go to File > Print and change the selection from 'Current sheet' to 'Workbook'. Adjust any other print settings you want to apply to all sheets and close the print preview. The extension will use these saved settings the next time you export.
Sheet order in the PDF
Sheets appear in the PDF in the same order they appear as tabs at the bottom of the Google Sheets interface. If you want the sheets in a different order, rearrange the tabs before exporting.
Hidden sheets
Hidden sheets in a Google Sheets workbook are not included in the PDF export. Only visible sheets are exported. If a sheet is hidden but contains data you need in the PDF, unhide it before exporting.
Page numbering across sheets
When you export the full workbook, page numbers run continuously through the entire PDF. If your first sheet has three pages and the second sheet has two pages, the PDF has five total pages numbered 1 through 5.
Frequently Asked Questions
How do I export all sheets in Google Sheets as one PDF?
Go to File > Print in Google Sheets, set the export scope to Workbook, and then use the Docs to PDF extension to export. All visible sheets are included in a single PDF.
Can I include hidden sheets in the PDF?
No. Hidden sheets are excluded from the export. Unhide any sheet you want to include before exporting.
Related article
Convert Google Docs to PDF & Preserve Formatting →Ready to Try It?
Install the free Chrome extension and start converting your Google Docs to PDF in one click.
Install Free Extension