XLSX to PDF: How to Export Spreadsheets with Correct Layouts

Exporting an XLSX (Excel spreadsheet) to PDF is the best way to share or archive spreadsheet data in a format that anyone can open, without risking accidental edits or layout changes.

Quick Answer: How to Export XLSX to PDF

To convert an XLSX spreadsheet to PDF while preserving layout and formatting, open the file in Excel or a compatible editor, choose Export or Save As PDF, and adjust print settings. For those without Excel, use an online XLSX to PDF converter like FileConversion.co’s XLSX to PDF tool for fast results.

Practical Steps: Export XLSX to PDF (with Examples)

Using Microsoft Excel

1. Open your XLSX file in Excel.
2. Review the layout in the Print Preview window (File > Print). Adjust column widths, margins, or scaling as needed.
3. Go to File > Export or File > Save As.
4. Choose PDF as the output type.
5. Select options for:
   • Entire workbook or selected sheets
   • Fit sheet on one page (if needed)
   • Include document properties (metadata)
6. Click Publish or Save.

Using Google Sheets

1. Upload your XLSX to Google Drive and open with Google Sheets.
2. Click File > Download > PDF (.pdf).
3. Adjust settings for:
   • Paper size and orientation
   • Scaling (fit to width/height)
   • Margins
   • Spreadsheet gridlines and notes
4. Click Export.

Using FileConversion.co XLSX to PDF

1. Go to FileConversion.co XLSX to PDF.
2. Upload your XLSX file.
3. (Optional) Adjust settings if available, such as page range or orientation.
4. Download the resulting PDF.

Other Offline Options

• LibreOffice Calc and WPS Office also support XLSX to PDF exports. The steps are similar to Excel: use the File > Export as PDF menu.
• For command-line workflows, tools like unoconv or LibreOffice headless mode can batch convert spreadsheets (though layout may differ).

Format and Settings Comparison

Not all XLSX to PDF exports are equal. The table below compares common methods by how well they preserve layout, formulas, hyperlinks, and special features.

*Formulas are never editable in PDF; only displayed values are exported.

Key Points

• PDFs are not spreadsheets: All formulas are flattened; only visible results remain.
• Layout: Print area, scaling, and print settings in the original file affect PDF output.
• Charts and Images: Usually included as static objects, but check placement and quality.
• Hyperlinks: Most tools preserve clickable links in cells.
• Sheet Selection: Choose whether to export the entire workbook or just selected sheets.

Common Problems and How to Fix Them

Problem: PDF Output Looks Different Than XLSX

• Symptoms: Columns spill off the page, missing rows, margins off, or page breaks in odd spots.
• Fix: Before exporting, use the Print Preview feature. Adjust column widths, row heights, set print area, and check scaling (e.g., "Fit Sheet on One Page"). In Excel, use Page Layout view.

Problem: Missing Charts, Images, or Colors

• Symptoms: PDF is missing embedded charts, images, or color formatting.
• Fix: Some online converters skip complex objects. Try exporting with Excel or Google Sheets, or ensure the online tool supports these features. FileConversion.co’s XLSX to PDF usually preserves images and basic charts.

Problem: Large File Size

• Symptoms: PDF size is much larger than expected, especially with images.
• Fix: Compress images in the XLSX before export. Some tools allow PDF compression as an option. For online tools, check if there is a file size reduction option.

Problem: Unwanted Blank Pages

• Symptoms: PDF contains extra blank pages at the end or between sheets.
• Fix: Set the print area correctly in the XLSX. Remove unused columns/rows. Check for hidden content that gets included in the print range.

Problem: Fonts Look Wrong

• Symptoms: PDF text uses substitute or generic fonts.
• Fix: Use standard fonts (Arial, Times New Roman, Calibri) in your spreadsheet. If using custom fonts, embed them if your PDF export tool supports it. Otherwise, font substitution can occur, especially with online tools.

Recommended XLSX to PDF Tools

• FileConversion.co XLSX to PDF: Fast, no registration, handles most formatting and charts.
• FileConversion.co Excel to PDF: Works for both XLSX and older XLS files.
• Microsoft Excel: Best control over print settings, ideal for complex or critical layouts.
• Google Sheets: Free, good for simple exports.
• LibreOffice Calc: Free and open source, decent compatibility with Excel files.

XLSX to PDF Export: FAQ

Does converting to PDF preserve formulas?
No. PDF is not a spreadsheet format. Only the visible results of formulas are exported; the formulas themselves are lost.

Can I export only certain sheets or ranges?
Yes. In Excel and Google Sheets, select the sheets or set a print area before exporting. Online converters may only export the active sheet or entire file.

Will interactive elements (drop-downs, buttons) work in PDF?
No. Interactive spreadsheet controls are not supported in PDF; they’ll appear as static content.

How do I keep header rows repeating on each page?
In Excel, set "Print Titles" under Page Layout > Print Titles. In Google Sheets, use the "Repeat frozen rows" option in the PDF export dialog.

Can I password-protect the resulting PDF?
Only if the export tool provides that option. FileConversion.co XLSX to PDF does not currently add password protection.

What about very large or complex workbooks?
Large files or those with many sheets, pivot tables, or heavy graphics may require desktop Excel for the best fidelity. Some online tools may fail or simplify such files.

Practical Takeaway

For reliable XLSX to PDF exports, check the print layout and scaling in your source file first, then use a trusted tool like FileConversion.co XLSX to PDF or desktop Excel. Always review the output PDF to confirm charts, images, font choices, and page breaks appear as intended.

Reviewed for accuracy against Microsoft Excel 365, Google Sheets, and PDF standards as of June 2024.