Google Sheets to PDF: Clean Table Exports (2026)
Google Sheets can print to PDF, but anyone who has tried it knows the failure modes: columns sliced in half across pages, ten-point font nobody can read, and gridlines that vanish or double up. This guide covers when the built-in export is enough, and a browser-based alternative that gives you styled, paginated tables — without the spreadsheet leaving your machine.
Method 1: the built-in export
File → Download → PDF (.pdf) opens Google's print settings. It works well for small sheets if you adjust two things:
- Set Scale → Fit to width so columns aren't cut off at the page edge.
- Switch to Landscape for sheets wider than about six columns.
The limits: header rows don't repeat on every page unless you set them in print settings, formatting options are minimal, and you need edit access plus a Google session — awkward when the data has already left Sheets as a CSV.
Method 2: export the file, convert in your browser
If you have a downloaded copy of the spreadsheet — or you want nicer table styling — convert the file directly:
- In Sheets, choose File → Download → Microsoft Excel (.xlsx) or Comma Separated Values (.csv).
- For .xlsx files, open to-pdf.com/xlsx-to-pdf — every sheet tab becomes a formatted, paginated table.
- For .csv files, open to-pdf.com/data-to-pdf — the data renders as a styled table with header row styling and zebra striping.
- Click Download PDF. The file is parsed in your browser; nothing is uploaded.
Which method should you use?
- Quick one-pager from a live sheet: built-in download is fine.
- Recurring reports from exported data: the CSV route is faster — no Google login needed, and the output styling is consistent every time.
- Multi-tab workbooks: the .xlsx route converts all sheets in one pass.
- Sensitive data: the browser converter never sends the spreadsheet anywhere; Google's export obviously requires the data to be in Google's cloud already.
Common problems and fixes
Columns still get cut off
Very wide tables can't fit a portrait A4 page at readable size. Delete helper columns before exporting, or split the table: lead columns plus key metrics in one PDF, details in another.
Numbers lose their formatting in CSV
CSV stores raw values, so currency symbols and thousands separators set by cell
formatting disappear. Either use the .xlsx route, which keeps display values, or
format the column with a formula (TEXT(A2, "$#,##0.00")) before
downloading.
Formulas show errors after download
IMPORTRANGE and other connected-data functions resolve only inside
Google's servers. Use File → Download from the browser (not a sync
client) so values are frozen at export time.