Excel to PDF: how sheets get paginated, why wide sheets scale, and printing spreadsheets that fit the page
Spreadsheets are for calculating; PDFs are for sharing. The moment a budget, roster or price list leaves your team, it should stop being editable and start being readable — which is why "send it as a PDF" is the standard closing move of spreadsheet work. But converting a spreadsheet is not printing a document: sheets are wide, formulas hide the real values, and multiple tabs need sensible page breaks.
This guide explains how the Paperly Excel to PDF tool handles those realities, what appears in the output, and the honest limits around charts and formatting. Everything runs locally in your browser — your financial files are never uploaded.
What the tool converts
The tool reads .xlsx (modern Excel) and .xls (legacy) files. Each sheet becomes a table drawn on the PDF pages: cell values in a grid with lines, one sheet after another, each starting on a fresh page. Up to 20 sheets are converted per file — for larger workbooks, split the file first or convert the important sheets.
- Values, not formulas — a cell showing =SUM(A1:A9) appears as its computed number.
- Grid lines — every cell is bounded, so the table reads clearly even without the source styling.
- Page breaks per sheet — sheet 2 never shares a page with sheet 1.
Using the tool
- Upload the .xlsx or .xls file (up to 50 MB).
- Click Process — sheets are drawn as paginated tables.
- Download the PDF.
- Share it anywhere — recipients need no spreadsheet software to read it.
How wide sheets are handled
Spreadsheets often span more columns than a page can hold. The tool scales wide sheets to fit the page width, preserving the table's proportions. That keeps every column on one page instead of splitting columns across pages — the difference between a readable table and a jigsaw puzzle.
Extremely wide sheets scale down accordingly: a 40-column roster prints at small type no matter the tool. If the output type is too small, the honest fixes are upstream — hide helper columns, delete empty spacer columns, or split the sheet into logical blocks before converting.
What does not come through (honest limits)
- Charts and embedded images are not rendered yet — the PDF carries the data tables, not the visuals. Export charts separately from Excel if they matter.
- Cell colors, conditional formatting and fonts are simplified — the goal is a clean, legible table, not a pixel copy of your workbook.
- Formulas are evaluated by the parser where possible; if a very exotic formula returns an unexpected value, verify the number in Excel and consider pasting it as a static value before converting.
- Beyond 20 sheets, extra sheets are not converted.
The classic monthly-report workflow
- Finalize the workbook in Excel — right numbers, hidden helper columns, sensible sheet order.
- Convert with Excel to PDF — paginated tables, one sheet per page.
- Add a header or footer with Add Header & Footer (e.g. "Q3 2026 — Internal").
- Protect the PDF with a password if the numbers are confidential — done in the same browser, still no uploads.
Troubleshooting
- A value shows 0 or an error — the parser could not evaluate that formula. Compute it in Excel and paste the static value, then convert again.
- Type too small — the sheet was scaled to fit its width. Reduce columns in the source or split the sheet.
- Missing sheets — the workbook has more than 20; convert the rest separately.
- Date looks different — date cells are drawn as their displayed values; check the cell format in Excel first.
Sheet ordering, empty sheets and hidden data
The conversion follows the workbook exactly as it is stored: sheets appear in their tab order, each starting on a fresh page. A few workbook habits produce surprising PDFs, and all of them are fixed in Excel in seconds before converting:
- Empty-looking sheets still convert — a tab with stray spaces or a single formula cell produces a near-blank page. Delete unused sheets first.
- Hidden sheets are not special-cased: check which tabs are hidden before converting, since what ships is what the parser reads.
- Helper columns full of intermediate calculations become real columns in the PDF. Hide or delete them, or move them to a scratch sheet outside the 20-sheet window.
- Print-area expectations do not apply — the tool draws the used range of each sheet, not the print area defined in Excel.
Building a clean source workbook
The PDF can only be as good as the sheet it is drawn from. A few minutes of workbook hygiene before converting pays off in every page of the output:
- Freeze the numbers — paste any formula whose result matters as a static value so the drawn table cannot surprise you.
- Set the sheet order to the reading order you want, since pages follow tab order one-to-one.
- Shorten very long text cells — wrapped cells produce tall rows that can push a table onto extra pages.
- Give sheets short, meaningful names if you will reference pages later ("Summary", "Q3", "Notes").
None of this changes your data — it only removes ambiguity between what you see in Excel and what the PDF can honestly draw.
For recurring reports, turn the checklist into a habit instead of a memory test: keep a template workbook whose sheet order, naming and value-freeze conventions are already right, duplicate it each cycle, fill in the numbers, and convert. The conversion itself is deterministic — the same workbook always produces the same PDF — so a stable template yields a stable, predictable document every month.
Related tools that pair well
- PDF to Excel — the inverse path when a PDF table must come back into a spreadsheet.
- Protect PDF — password-lock the converted report.
- Compress PDF — shrink large converted reports before emailing.