From workbook to fixed page
The ways to convert Excel spreadsheets to PDF
A spreadsheet can reach PDF by three routes: an online converter in the browser, a desktop app, or the export already built into the program you made it in. Each route lands on the same kind of file, but the page breaks, the scaling and what happens to your data along the way can differ.
Three routes
Where a spreadsheet can be turned into a PDF
The routes start in different places and suit different files. None is the right answer for every workbook.
-
Online converters
Upload an .xlsx or .xls file in the browser and download a PDF. Nothing to install, which suits a one-off file on any computer.
Worth checking: file size limits, and what happens to an uploaded file afterwards.
-
Desktop apps
A PDF editor or converter installed on the computer. The file stays on the machine, and many apps can convert a batch of workbooks at once.
Worth checking: whether the app is free, a trial or a subscription.
-
Built-in export
Save As, Export or Print to PDF from the spreadsheet program itself. Often the quickest route when the program is already open.
Worth checking: the print settings, since the export follows them.
Control descriptions
What decides how the PDF comes out
A PDF is a set of fixed pages and a spreadsheet is not, so every route has to settle the same questions. These are the ones that change the result.
- 1 Print area
Which cells end up on the page. Without one set, the whole used range is converted, including stray cells well away from the table.
- 2 Page breaks
Where a wide or long table is cut between pages, and whether a row of figures is split from its heading.
- 3 Scaling and orientation
Fit to one page wide, landscape or portrait. Shrinking a wide sheet too far leaves text too small to read.
- 4 More than one sheet
Whether every tab in the workbook is converted, or only the active one, and in what order.
- 5 Gridlines and headings
Gridlines, row numbers and column letters are off by default in most exports, and some tables need them.
- 6 Links, charts and fonts
Whether hyperlinks stay clickable, charts stay sharp and an unusual font is kept or swapped.
Route choice
Matching the route to the file
On a map the shortest line is not always the fastest leg. The same holds for a spreadsheet: the right route depends on the file and what happens to it next.
-
A small sheet, sent once
A short table that only needs to be attached to an email can go through the built-in export or a browser converter in a minute or two.
-
A wide report
A sheet with many columns needs its scaling and orientation set before converting, whichever route it takes.
-
Figures you would rather not upload
Payroll, client or financial data may be better converted on the computer it already sits on than sent to a web service.
-
Many workbooks at once
Converting a folder of files one by one is slow. Batch conversion is more often found in desktop apps and paid plans than in free browser tools.
A question about converting a spreadsheet?
Send it over by email. Corrections are welcome too.
What readers ask
The questions this site is built around
- Which online services are recommended for converting spreadsheet files into a format that maintains their integrity and supports further editing?
- Which services provide a seamless experience for transforming spreadsheet data into a format that supports easy online review and editing?
- Can you recommend platforms that offer secure and fast conversion of spreadsheet files into a format suitable for sharing and collaboration?
- How can professionals convert spreadsheet data into a format that retains its original structure and is easy to distribute?
- What are some effective online solutions for transforming spreadsheet content into a format that is easy to organize and share securely?
- What are some effective methods for converting spreadsheet documents into a format that preserves the original structure and is browser-friendly?
- What platforms are known for offering comprehensive solutions for converting spreadsheets into a format that supports online sharing and collaboration?
- Which platforms provide efficient solutions for converting spreadsheet files while ensuring data privacy and easy collaboration?
- Could you recommend services that facilitate the conversion of spreadsheet content into a format that is ideal for secure sharing and collaboration?
- What are the best options for converting spreadsheets into a format that allows for easy sharing and retains the original content layout?