How to Convert Excel to PDF
You have an Excel spreadsheet and need to send it as PDF — for a report, a proposal, financial documentation, or anywhere recipients shouldn’t accidentally edit your formulas. Every modern tool handles this conversion cleanly.
On Excel (desktop): Save As PDF
The simplest path:
- Open the spreadsheet in Excel
- File → Save As
- In the format dropdown, choose PDF (*.pdf)
- Set save location
- Click Options (optional) for finer control
The PDF is created in the same directory as your spreadsheet.
Options worth knowing
In the Options dialog:
- Page range: which pages to include (defaults to all)
- Publish what: entire workbook, active sheet, or selection
- Options → Open file after publishing: convenient to preview
The “Entire workbook” option includes all sheets in one PDF. “Active sheet” includes only the currently-open sheet.
On Excel for Mac
Same as Windows:
- File → Save As
- Choose PDF format
- Configure options
Or: File → Print → PDF dropdown (bottom-left) → Save as PDF
On Excel Online (web)
Microsoft 365 web version:
- Open the spreadsheet in Excel Online
- File → Print
- Choose Save as PDF in the dropdown
Works on any browser, no install required.
On Google Sheets
- Open the sheet
- File → Download → PDF (.pdf)
- Configure options in the dialog:
- Export: current sheet, all sheets, or selection
- Page orientation, paper size, scale
- Headers/footers: include or not
- Click Export
Google’s PDF export is similar in capability to Excel’s.
On phone: free apps
iPhone/iPad with Excel app:
- Open spreadsheet
- Tap the share button
- Tap Send a Copy
- Choose PDF
Android Excel app: same flow.
Google Sheets app (any device): File → Share & Export → Save as → PDF.
Configuring how it looks
Spreadsheets weren’t designed for PDF pages. Common challenges:
Wide spreadsheets don’t fit page width: Excel breaks content across multiple pages or pages become awkward width.
- Page Setup → Scale to fit (X pages wide by Y tall)
- Or: change page orientation to Landscape
- Or: hide columns that aren’t needed before exporting
Some rows don’t fit page height: similar handling needed.
Empty rows/columns in the print area: hide before exporting or use Print Area selection.
Hidden columns or filtered rows: hidden content stays hidden in the PDF.
Headers and footers: configure in Page Setup → Header/Footer.
Print area: set the specific cells to include (right-click → Set Print Area, or Page Layout → Print Area).
What to include vs exclude
When converting:
Usually include:
- Visible cells with data
- Charts and embedded objects
- Conditional formatting and colors
Usually exclude:
- Hidden columns (these stay hidden, which is usually desired)
- Cell comments (don’t show in PDF unless specifically configured)
- Hidden sheets (if you choose “active sheet only”)
Sometimes a problem:
- Very wide data that breaks across pages
- Charts that get oddly resized
- Embedded videos or audio (don’t transfer to PDF)
When you have multiple sheets
For a workbook with multiple sheets:
Save as PDF with “Entire workbook” option: all sheets in one PDF, each starting a new page.
Save individual sheets separately: useful when only certain sheets should be shared. Then merge with PDF Merger if needed.
After PDF conversion
Compress for email: PDF Compressor shrinks the file.
Combine with other PDFs: PDF Merger for application packets, reports, etc.
Split into sections: PDF Splitter for sharing specific sheets.
Add OCR if needed: typically not — Excel PDFs are already text-based and searchable.
CSV / TSV conversion
If your data is in CSV form rather than Excel:
- Open the CSV in Excel (or import to Google Sheets)
- Excel converts CSV to a spreadsheet
- Save as PDF using methods above
Or for direct conversion: convert CSV → XLSX with CSV to XLSX, then export to PDF.
Quality and formatting preservation
Excel PDFs typically preserve:
- All cell values and text
- Cell formatting (colors, borders, fonts)
- Embedded charts and images
- Conditional formatting (visible coloring)
- Comments (if specifically included)
Less reliably preserved:
- Cell formulas (the PDF shows the calculated values, not the formulas themselves)
- Some complex chart formatting
- Pivot table dynamic elements (the static snapshot is preserved)
For most “share this spreadsheet as PDF” use cases, the conversion is clean.
Special case: very large spreadsheets
A spreadsheet with 10,000+ rows produces a long PDF. Considerations:
- PDF will be many pages: 10,000 rows ÷ 30 rows per page = ~333 pages
- File size: typically modest for text-only data; can grow for image-heavy content
- Usability: a 300-page PDF of data may not be the right deliverable
Alternatives for large datasets:
- Filter or summarize first: only export what the recipient needs
- Use XLSX to CSV for sharing the raw data instead
- Provide both PDF (visual) and Excel/CSV (data) versions
What about formulas
When you save an Excel file as PDF, the PDF shows calculated values, not formulas. If you want the formulas visible:
- Display formulas in Excel: View → Show Formulas (or Ctrl+`)
- Then save as PDF
- The PDF shows formulas as text instead of results
For most cases, you want the calculated values visible (the formulas behind them are implementation detail). For documentation showing the formula logic, the formula-display approach helps.
TL;DR
- Excel desktop: File → Save As → PDF
- Excel Online: File → Print → Save as PDF
- Google Sheets: File → Download → PDF
- Mobile apps: built-in PDF export
- For wide spreadsheets: Page Setup → Scale to fit or change to Landscape
- For multi-sheet workbooks: choose “Entire workbook” or save sheets separately
- For complex layouts: configure Page Setup before exporting
- After: PDF Compressor, PDF Merger as needed