Export Google Sheets as PDF
Exporting a Google Sheet as PDF is trickier than exporting a document. You need to decide whether to export all tabs or just one, whether gridlines should be visible, how wide columns fit onto a page, and whether charts export correctly. The Docs to PDF online converter handles these exports through Google's own API, giving you clean results without third-party processing.
Exporting a single sheet vs. the whole workbook
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 online converter exports all visible tabs in Google's standard PDF layout. For custom print settings or a single tab, export from Google Sheets itself with File > Download > PDF.
Controlling page layout for spreadsheets
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.
Gridlines and print settings
Whether gridlines appear is a choice you make in Google Sheets' own export dialog: File > Download > PDF, then 'Show gridlines' under Formatting. The online converter exports every spreadsheet with Google's default layout and all visible tabs. Custom print settings (print area, gridlines, orientation, scaling) only apply when you export from Google Sheets itself with File > Download > PDF, where you choose them for that download.
Charts in exported spreadsheets
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.
Multiple tabs and tab order
The online converter uses Google's standard PDF layout. For custom print settings, export from Google Sheets itself with File > Download > PDF. Tab order in the PDF matches the tab order at the bottom of the sheet.
Specific Guides
Export Google Sheet as PDF
The fastest way to export a Google Sheet as a PDF. One click from inside the spreadsheet or from Google Drive.
Read guide →Export a Single Tab from Google Sheets as PDF
Export just one sheet tab from a Google Sheets workbook as a PDF, leaving the other tabs out.
Read guide →Export All Tabs from Google Sheets as One PDF
Export every sheet tab in a Google Sheets workbook as a single multi-page PDF.
Read guide →Export Google Sheets as PDF Without Gridlines
Remove gridlines from the PDF when exporting a Google Sheet. Clean output for reports and presentations.
Read guide →Export Google Sheets as PDF with Charts
Export a Google Sheet with embedded charts preserved as clear images in the PDF.
Read guide →Export Google Sheets as PDF in Landscape Orientation
Export a wide Google Sheet as a landscape PDF so all columns fit on the page without being cut off.
Read guide →Export Google Sheets as PDF Fit to Page
Scale a Google Sheet to fit on one page when exporting as PDF. No cut-off columns or rows.
Read guide →Export Google Sheets as PDF for Free
Export Google Sheets as PDF at no cost using the free Docs to PDF online converter. No watermarks; sign in with Google and get 25 free conversions.
Read guide →Export a Shared Google Sheet as PDF
Export a Google Sheet that was shared with you as a PDF, even if you are not the file owner.
Read guide →Export Google Sheets as PDF for Reports
Create clean, professional PDF reports from Google Sheets. Control layout, hide raw data, and export on a schedule.
Read guide →Frequently Asked Questions
How do I export a Google Sheet as PDF?
Open the Docs to PDF online converter, pick the spreadsheet from your Google Drive, and click Convert. The PDF downloads as soon as it is ready.
Can I export all tabs of a Google Sheet as one PDF?
Yes. The online converter exports all visible tabs of a spreadsheet into one PDF. In Google Sheets itself, File > Download > PDF with the scope set to Workbook does the same.
How do I hide gridlines in a Google Sheets PDF export?
Go to File > Print in Google Sheets. Under 'Formatting', uncheck 'Show gridlines'. The exported PDF will not show gridlines.
Why is my spreadsheet cut off in the exported PDF?
The spreadsheet has more columns than fit on the page at the current scale. Go to File > Page Setup, set the scaling option to 'Fit to page width', and re-export.
Does the PDF include all the data in my spreadsheet?
The PDF includes all data that falls within the print area. If you have set a print area that excludes some data, those cells will not appear in the PDF.
Ready to Convert?
Join thousands of users who convert their Google Docs to PDF every day with our free Chrome extension.
Convert Sheets to PDF online, freeConvert online, no install