Convert XLS to PDF in Microsoft Excel: Step‑by‑step guide for Pakistani students

Convert XLS to PDF in Microsoft Excel: Step‑by‑step guide for Pakistani students

To convert XLS to PDF in Microsoft Excel, the fastest and most reliable method is the built-in export: go to File > Save As > PDF on Windows, or use File > Export > Create PDF/XPS > Publish as the alternative route. This preserves Excel-specific features, charts, merged cells, borders, and page setup, more reliably than third-party converters, without installing anything extra or uploading your file to a third-party server.

Pakistani students face this task constantly: submitting assignments as PDFs so lecturers cannot accidentally edit them, or sharing financial reports and project summaries without exposing the underlying data or formulas. Knowing which method to use in which situation saves time and prevents the frustration of a broken layout at the last minute. This guide walks you through every option, from Excel’s built-in method and free online converters to LibreOffice, mobile apps, batch conversion, and common formatting fixes.

Key takeaways

  • Built-in export wins: Excel’s File > Save As > PDF gives the highest fidelity and works without an internet connection or third-party tools.
  • Set page layout first: Adjusting print area, orientation, and Scale to Fit before exporting prevents many common clipped-column problems.
  • Online tools carry privacy risks: Never upload payroll data, tax records, or customer lists to free online converters; use local software for sensitive files.
  • LibreOffice is a free alternative: It handles XLS and XLSX reliably for students who do not have a paid Microsoft 365 subscription.
  • Mobile works well for simple files: Microsoft Excel mobile gives the best fidelity on Android and iPhone; always preview before sharing.
  • Batch tools save hours: Total Excel Converter, reaConverter, or LibreOffice headless can process entire folders at once.

How to convert XLS to PDF directly in Microsoft Excel

This is the method to reach for first, every time. Because Excel generates the PDF using its own rendering engine, it understands your print areas, page breaks, custom fonts, and chart placements without any guesswork.

Windows: Save As and Export routes

Open your workbook, then select File > Save As (or Save a Copy). Choose your destination folder, enter a file name, and in the “Save as type” dropdown select *PDF (.pdf). You will see two quality options: choose Standard for better print quality, or Minimum size when you need a smaller file for email or online submission. Before clicking Save, select Options** if you want to export only specific sheets, a page range, or a defined print area rather than the entire workbook.

The alternative Windows route is File > Export > Create PDF/XPS. Click Publish after choosing your destination and using Options to control which worksheets are included. Both routes produce identical results; the Export path is simply a different entry point to the same feature.

Mac: File menu and Print dialog workaround

On Excel for Mac, go to File > Save As and select PDF from the File Format or Format menu. Choose whether to export the active sheet, selected sheets, or the entire workbook, then click Export or Save. If the PDF option does not appear in Save As, use the fallback: File > Print, click the PDF button in the lower-left corner of the print dialogue, and choose Save as PDF. The fallback works reliably but gives you fewer sheet-selection controls than the Save As route.

Essential page layout settings to adjust before you export

Before you export, take two minutes to configure these settings under the Page Layout tab. Set a print area by selecting your data range, then choosing Page Layout > Print Area > Set Print Area, this stops blank columns and rows from inflating the PDF. Set Orientation to Landscape for wide worksheets, and under Scale to Fit, set Width to 1 page and Height to Automatic so all columns fit horizontally without shrinking rows to an unreadable size.

Always open File > Print before saving the PDF. The print preview shows exactly how pages will break, which catches clipped columns and stray blank pages before they become someone else’s problem. Adjusting these settings before exporting prevents many common formatting problems that students encounter.

Which free online converters actually preserve Excel charts and formatting?

Several free tools handle XLS and XLSX conversion well for everyday, non-sensitive workbooks. The question is knowing which one to reach for and when to stay away from all of them.

The most reliable tools for preserving layout and charts

Not every tool handles formatting equally well. Here is a quick overview of the most commonly used options:

  • Adobe Acrobat Online: preserves fonts, layouts, colours, borders, and table structures, with support for charts and formulas.
  • Foxit Excel to PDF: supports both XLS and XLSX and claims to preserve charts, tables, formatting, hyperlinks, and data fields.
  • Smallpdf: handles XLS and XLSX in-browser without requiring sign-up; states that tables, charts, borders, and cell formatting remain aligned.
  • ToolifyPDF and Mapsoft PDF Hub, worth trying when multiple worksheets, merged cells, column widths, and page-break adjustments all matter.

For complex pivot tables, macros, and dashboards, no online converter can guarantee perfect results. Excel’s own Export function remains the safest option for those files. As a general guide: reach for Adobe Acrobat or Foxit for business documents, Smallpdf for quick and simple workbooks, and ToolifyPDF or Mapsoft when charts and multiple worksheets are involved.

Are these converters safe to use?

The key distinction is whether conversion happens on the provider’s server or locally in your browser. Browser-based tools are safer because the file never leaves your device. Server-based tools upload your file, process it remotely, and store it temporarily. Foxit states that both files are deleted after processing; Convertio says the XLS is erased after conversion and the PDF within 24 hours; WORD.to states both files are deleted after approximately 24 hours. You cannot independently verify any of these claims, since you have no way to confirm whether copies remain in backups, logs, or third-party cloud storage.

Do not upload payroll data, tax records, customer lists, or any confidential business spreadsheets to free online tools. For sensitive XLS files, always use a local application. For ordinary worksheets, a reputable service with HTTPS and a specific deletion deadline is generally acceptable.

LibreOffice and Google Sheets as free desktop and browser alternatives

Not every student has a paid Microsoft 365 subscription, and that is completely fine. Two free alternatives handle most conversion tasks without cost.

Exporting to PDF in LibreOffice Calc

LibreOffice is free, open-source, and handles both XLS and XLSX files reliably. To export, go to File > Export as PDF, adjust options such as image quality and page range in the dialogue, and click Export. For mostly tabular workbooks, the output quality is excellent. For files with Excel-specific formatting, charts, or unusual fonts, always preview the PDF carefully; some elements may render slightly differently from Excel’s native export.

Google Sheets: a quick export from any browser

Upload your XLS or XLSX file to Google Drive, open it in Sheets, then go to File > Download > PDF Document (.pdf). The export dialogue lets you adjust page orientation, scale, margins, page breaks, and gridlines. This method works well for shared documents where collaborators already use Google Workspace. The limitation is that advanced Excel formatting, macros, and some pivot table structures do not transfer faithfully from XLS to Sheets before export, so inspect the result before sharing.

How to convert an Excel spreadsheet to PDF on your phone

Working from a mobile device is common for Pakistani students, especially when a laptop is not nearby. Several apps produce clean, properly laid-out PDFs from both Android and iPhone.

Android apps that keep your layout intact

Microsoft Excel mobile is the top choice for complex files. Open the workbook, tap Share/Export, and select PDF; because the app uses Microsoft’s own engine, fidelity is as close to the desktop version as you can get on a phone. iLovePDF Mobile and Xodo are reliable cross-platform options that preserve fonts and images. For straightforward conversions, the dedicated “Excel to PDF” app on the Google Play Store handles cells, borders, and basic layout well.

iPhone and iPad options with page controls

Microsoft Excel mobile on iOS uses the same method as Android and is the recommended starting point for complex files with charts or merged cells. The “Convert Excel to PDF” app on the App Store offers detailed page controls: sheet selection, repeated rows and columns, scaling, orientation, margins, gridlines, image quality, and a preview before export. UPDF converts the file and also allows basic PDF editing after conversion, which is useful when you need to annotate a report before submission.

Always preview the PDF before sharing, especially when the workbook contains merged cells or custom fonts. A quick check takes seconds and saves the embarrassment of sending a broken document.

Need to convert a whole folder of XLS files at once?

When you have ten or twenty reports to process, converting them one by one is not practical. These batch methods handle entire folders efficiently.

Batch convert XLS to PDF on Windows: GUI tools and PowerShell

For a graphical approach, tools such as Total Excel Converter, reaConverter, and Win2PDF can process entire folders, maintain separate PDFs per workbook, and in some cases merge everything into one PDF. These are the easiest options for students and staff who prefer not to use the command line.

For automation, PowerShell with Excel COM automation opens each workbook, runs ExportAsFixedFormat, and closes it; this gives the best fidelity because actual Excel does the rendering. The same logic can be saved as a .bat file and run on a schedule via Task Scheduler, which is useful for monthly reporting workflows. Excel must be installed and running for this method to work.

Mac and cross-platform: LibreOffice headless batch conversion

LibreOffice’s headless command-line interface runs on Windows, macOS, and Linux. The command soffice, headless, convert-to pdf, outdir ~/PDFs ~/Reports/*.xlsx processes all XLSX files in a folder and saves the PDFs to the specified output directory. For nested folders, a simple shell loop using find handles subfolders automatically. A Python wrapper using subprocess achieves the same result and is easy to integrate into larger workflows.

Before running any large batch, verify print areas, page orientation, scaling settings, and hidden sheets across a sample of files. These settings determine how each spreadsheet paginates in the resulting PDF, and fixing them after the fact means rerunning the entire batch.

Why does my exported PDF look broken, and how do I fix it?

Most formatting problems in exported PDFs trace back to a small set of causes, all of which are fixable before you export.

Common formatting problems and their fixes

Clipped columns are the most frequent complaint. Fix them with Page Layout > Scale to Fit, setting Width to 1 page, or by tightening the print area to exclude unused columns. Font substitution on other computers happens when the original font is not embedded; use LibreOffice’s PDF options to enable font embedding, or export at Standard quality in Excel. Charts appearing on a separate page are usually caused by the chart object extending past a page break; resize the chart within the sheet and check Page Break Preview before exporting.

Hidden columns or rows sometimes appear in the PDF when they fall inside the print area. Unhide them and decide whether to include or exclude them from the print area before exporting. Formulas showing as text in the PDF is not a bug; PDF exports capture values, not live formulas, and this is correct behaviour.

Reducing file size and adding basic password protection

To reduce file size, compress images in the workbook first: select an image, go to Picture Format > Compress Pictures, and choose Web (150 ppi) for screen use or Print (220 ppi) for documents that will be printed. Then export using the Minimum size quality setting in Save As. Keep native Excel charts as charts rather than pasting screenshots of them; vector charts compress more efficiently and stay sharp at any zoom level.

Excel does not always add PDF-level encryption during export; if your version of Excel or an installed add-on offers an Encrypt or Password option during the Save As or Export step, you can use it, otherwise, secure the PDF with a dedicated tool such as Adobe Acrobat or iLovePDF after export. Open the exported PDF, choose Protect or Encrypt with Password, set a strong password, and save as a new file. Close and reopen it to confirm the password is required. Do not upload confidential files to online tools for this step; use a desktop application.

Wrapping up

When you need to convert XLS to PDF, the most reliable result comes from Excel’s built-in Save As or Export feature, with your print area, orientation, and Scale to Fit configured correctly beforehand. That single combination solves most problems before they start.

When you need a quick alternative, use a reputable online converter for non-sensitive files, LibreOffice for free desktop conversion, Microsoft Excel mobile when you are away from your laptop, and Total Excel Converter or LibreOffice headless for processing multiple files at once.

Sohaib Tutorials is an online platform offering tutorials and learning resources. Converting to PDF cleanly is just one piece of working confidently with spreadsheets, and there is considerably more to explore once these fundamentals are in place.

Frequently Asked Questions

Will my custom fonts appear in the exported PDF?

Custom fonts will appear if the export embeds them or if the viewer has the same fonts installed. LibreOffice offers PDF options to enable font embedding, and exporting at Standard quality in Excel reduces substitution risk; otherwise, a different computer without those fonts may substitute them.

Can we add a password during the Excel Save As/Export to PDF step?

Excel does not always add PDF-level encryption during export so you may not be able to set a password there. If your Excel version or an installed add-on provides an Encrypt or Password option you can use it; otherwise secure the exported PDF with a desktop tool such as Adobe Acrobat or iLovePDF afterwards and confirm the password works.

Is it safe to use free online converters for student assignments?

Using free online converters for ordinary, non‑sensitive worksheets is generally acceptable if the service is reputable and uses HTTPS and a stated deletion policy. Do not upload payroll data, tax records, customer lists or other confidential spreadsheets to free online tools; for sensitive files always use a local application such as Excel or LibreOffice.

Which mobile app should we choose when converting complex Excel files on a phone?

Microsoft Excel mobile is the recommended starting point for complex files because it uses Microsoft’s rendering engine and gives the best fidelity on Android and iPhone. For simpler conversions iLovePDF Mobile, Xodo or dedicated ‘Excel to PDF’ apps work well, but always preview the PDF before sharing, especially with merged cells or custom fonts.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top