A workbook is a working file; a PDF is what you send to someone who should not change the numbers. This tool lays a spreadsheet out as a simple table and saves it as spreadsheet.pdf, with a choice of one sheet or all of them and portrait or landscape pages.
It prints the values, not the spreadsheet's print layout. If the sheet has a carefully set print area, repeating header rows or a page break at the right place, those settings are not carried over. The table is rebuilt row by row, which is predictable but plain.
Rows, columns and the cut-offs
Two limits shape the result, and both are stated in the result panel:
- 2,000 rows per sheet. A 2,100-row sheet was cut at 2,000, so the last hundred rows were left out.
- The first 12 columns. A 14-column sheet printed through Notes and dropped the two columns after it.
Formulas are printed as their displayed values, which is normally what you want: the PDF shows the number a reader would see, not the formula behind it. Charts, images, merged cells and cell colours are not reproduced.
Sheets and orientation
First sheet only keeps the PDF short and is the usual choice for a summary tab. All sheets adds each sheet in workbook order, with the sheet name as a heading, so a two-sheet workbook produced one table after another in a single PDF.
Orientation matters more than it looks. Portrait fits more rows on a page; landscape fits more columns. On the test workbook, portrait clipped the last column at the page edge, while landscape showed the same column in full. If the sheet is wide, use landscape and check the right-hand edge.
A worked example
First run: the 2,100-row, 14-column workbook with two sheets, first sheet only, portrait. The tool reported Converted 1 sheet into a PDF, 2,000 rows, 40 pages, columns first 12 only, and a 495,792-byte file. The header row read Reference, Depot, Region, Q1, Q2, Q3, Q4, Total, Owner, Status, Opened, Notes.
Second run: all sheets, landscape. That gave Converted 2 sheets into a PDF, 2,003 rows, 59 pages and a 514,380-byte file. The second sheet, Yards, appeared at the end with its two columns, and the Notes column was no longer clipped.
Before you convert
Hide or delete columns you do not want in the PDF, because the first 12 are printed whether or not they are useful. Freeze panes and filters mean nothing in a PDF, so sort the data the way it should read. If a sheet is longer than 2,000 rows, split it into two sheets or accept the cut.
The workbook reader is lenient. A text file renamed .xlsx was read as a one-row sheet rather than refused, so if the PDF looks like a single line of text, check that the source file really is a workbook.
Limits and alternatives
One workbook of up to 30 MB per run, saved as spreadsheet.pdf. Both .xlsx and .xls are accepted.
For a PDF that matches Excel's own print layout, use File > Export > Create PDF in Excel or Export as PDF in LibreOffice. This tool is for the quick local copy where the rows matter more than the styling.
To read a PDF the other way, PDF to Excel extracts text into a sheet. To combine the result with a cover page, use Merge PDF.