← All guides

How to Convert Excel to PDF

excelpdfspreadsheetconversion

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:

  1. Open the spreadsheet in Excel
  2. File → Save As
  3. In the format dropdown, choose PDF (*.pdf)
  4. Set save location
  5. 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:

  1. File → Save As
  2. Choose PDF format
  3. Configure options

Or: File → Print → PDF dropdown (bottom-left) → Save as PDF

On Excel Online (web)

Microsoft 365 web version:

  1. Open the spreadsheet in Excel Online
  2. File → Print
  3. Choose Save as PDF in the dropdown

Works on any browser, no install required.

On Google Sheets

  1. Open the sheet
  2. File → Download → PDF (.pdf)
  3. Configure options in the dialog:
    • Export: current sheet, all sheets, or selection
    • Page orientation, paper size, scale
    • Headers/footers: include or not
  4. Click Export

Google’s PDF export is similar in capability to Excel’s.

On phone: free apps

iPhone/iPad with Excel app:

  1. Open spreadsheet
  2. Tap the share button
  3. Tap Send a Copy
  4. 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:

  1. Open the CSV in Excel (or import to Google Sheets)
  2. Excel converts CSV to a spreadsheet
  3. 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:

  1. Display formulas in Excel: View → Show Formulas (or Ctrl+`)
  2. Then save as PDF
  3. 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