Excel does not have a dedicated “Export to XPS” button, but it includes XPS as a file format in the Save As and Export commands. To save a worksheet as an XPS file in Excel for Microsoft 365 on Windows, go to File > Save As, choose a location, pick XPS Document (*.xps) from the “Save as type” dropdown, and click Save. Alternatively, use File > Export > Create PDF/XPS Document, then click Create PDF/XPS. The XPS format is a fixed-layout document format developed by Microsoft, similar to PDF, but with less third-party support.
What Is XPS and Why Use It?
XPS (XML Paper Specification) is a fixed-layout document format that preserves the visual appearance of your spreadsheet, including fonts, colors, and page breaks, regardless of the device or software used to view it. It was introduced with Windows Vista and Office 2007 as a competitor to PDF. While PDF has become the industry standard, XPS still has niche uses: it is built into Windows (the XPS Viewer is preinstalled on most Windows versions), it supports digital signatures, and it can be useful in environments where PDF creation is restricted. However, XPS files are rarely used outside Windows, and many online services and mobile devices cannot open them.
How to Export Excel to XPS (Step-by-Step)
The process is straightforward in Excel for Microsoft 365 on Windows. Here are the two main methods:
- Save As method: Click File > Save As, select a folder, type a file name, then in the “Save as type” dropdown choose XPS Document (*.xps). Click Save.
- Export method: Click File > Export > Create PDF/XPS Document. In the “Create PDF/XPS” dialog, choose where to save, set the file name, and select XPS from the “Save as type” dropdown (the default is PDF). Then click Publish.
On a Mac, Excel does not support XPS export at all. The Save As dialog does not offer XPS as an option. If you need an XPS file on a Mac, you would have to use a third-party converter or a Windows virtual machine.
Choosing Between XPS and PDF in Excel
When you use the Export command, Excel gives you a choice between PDF and XPS. Here are the key differences to help you decide:
- Compatibility: PDF is universally supported on all operating systems, browsers, and mobile devices. XPS is only natively supported on Windows (and even there, modern browsers like Edge may not open XPS directly without a viewer).
- File size: XPS files are often slightly smaller than PDFs for the same content, but the difference is usually negligible.
- Security: Both formats support digital signatures and permissions, but PDF has more robust encryption and redaction tools.
- Accessibility: PDF has better support for screen readers and text extraction, making it more accessible.
- Use case: If you are in a Windows-only corporate environment and need to archive documents, XPS might be acceptable. For sharing with clients or publishing online, PDF is the safer choice.
Common Problems and How to Fix Them
Users often encounter issues when exporting to XPS. Here are the most frequent ones and their solutions:
- XPS option is missing: In some Excel installations, the XPS writer may not be enabled. Go to File > Options > Add-ins, select “COM Add-ins” from the Manage dropdown, and click Go. Check if “Microsoft XPS Document Writer” is listed. If not, you may need to enable the feature via Windows’ “Turn Windows features on or off” (search for “XPS Services” and “XPS Viewer”).
- Page breaks are wrong: XPS export uses the print area and page setup. To control page breaks, go to Page Layout > Page Setup and set the orientation, scaling, and margins. Also check the print area under Page Layout > Print Area.
- XPS file won’t open: On Windows, use the built-in XPS Viewer (search for “XPS Viewer” in Start). If it’s not installed, enable it via Windows Features. On other operating systems, you’ll need a third-party viewer like STDU Viewer or convert the file to PDF.
- Export creates multiple pages: This is normal if your spreadsheet is wider than one page. Adjust scaling to fit all columns on one page: Page Layout > Scale to Fit, set Width to “1 page”.
Comparison: XPS vs. PDF vs. Other Formats
Understanding how XPS stacks up against other export options in Excel helps you choose the right format. Here’s a quick comparison:
- XPS: Fixed layout, Windows-only, supports digital signatures, but limited sharing.
- PDF: Fixed layout, universal, supports forms and encryption, widely used.
- Excel Workbook (.xlsx): Editable, retains formulas and formatting, but requires Excel to view.
- CSV: Plain text, no formatting, ideal for data interchange.
- Web Page (.htm): Can be viewed in browsers, but layout may shift.
For most users, PDF is the recommended fixed-layout format because of its universal compatibility. XPS is only preferred when you need a Microsoft-native format or when PDF creation is disabled on your system.
Costs and Safety of Using XPS
Creating XPS files in Excel is completely free—no additional software is required. The XPS format is an open standard (ISO 29500), but Microsoft’s implementation is proprietary. There are no licensing fees for creating or viewing XPS files. However, be aware that XPS files can contain macros? No, XPS is a fixed-layout format and cannot contain macros, so it is safe from macro viruses. But like any file, XPS files can be used to deliver malware if they exploit viewer vulnerabilities. Always open XPS files from trusted sources. Also, XPS files do not support DRM, so they are not suitable for protected content. For sensitive data, consider using PDF with encryption or password protection.
Alternatives to XPS Export in Excel
If XPS isn’t working for you, or you need more control, consider these alternatives:
- PDF: The most common alternative. Use File > Export > Create PDF/XPS and select PDF. You can also use the “Save As” type PDF.
- Print to XPS via Windows: If Excel’s export fails, you can print your spreadsheet to the “Microsoft XPS Document Writer” printer. This creates an XPS file from any application that can print.
- Third-party converters: Online tools or software like Zamzar or Adobe Acrobat can convert Excel files to XPS, but be cautious with sensitive data—avoid uploading confidential files to unknown services.
- Change the default export format: In Excel, you can set the default file format for saving, but not for export. The export dialog always defaults to PDF.
Frequently Asked Questions
Can I export a selection of cells to XPS?
Yes. Select the cells you want to include, then go to Page Layout > Print Area > Set Print Area before exporting. Alternatively, in the Save As dialog, click the “Options” button and choose “Selection” under “Publish what”.
Why doesn’t Excel for Mac have XPS export?
Microsoft never implemented XPS support in Office for Mac. XPS is a Windows-centric format, and Apple’s macOS has no native XPS viewer. If you need XPS on a Mac, use a Windows machine or a third-party converter.
Can I edit an XPS file in Excel?
No. XPS is a fixed-layout format, like PDF, so it cannot be edited in Excel. You would need to reopen the original Excel file to make changes and re-export.
Is XPS better than PDF for printing?
Both produce high-quality prints. XPS is designed for high-fidelity printing and supports color management, but PDF is more widely supported by printers and printing services. For most printing needs, PDF is the safer choice.
How do I convert an XPS file back to Excel?
You cannot directly convert XPS to Excel because XPS is a static image-like format. You would need to use OCR (optical character recognition) software to extract text, or manually re-enter the data. For editable copies, always keep the original .xlsx file.
Related
- Vacation Budget Excel Template: How to Plan & Track
- Excel Template for Weekly Attendance: How to Build One
- Excel Template for Weekly Employee Schedule: How to Build One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Find and Replace Preview: How to Check ChangesExcel for Microsoft 365 on Windows does not provide a separate preview screen for Replace All. To review…
- Present in PowerPoint With Notes on Screen: How ToYes. In Microsoft PowerPoint for Microsoft 365 on Windows, turn on Presenter View and use an extended display:…
- How to Delete an Excel File in Office 365To delete an Excel file in Office 365, close it, then remove it from the place where it…
- How to Add a Draft 2 Watermark in Word on Every PageTo add a DRAFT 2 watermark in Word for Microsoft 365 on Windows, open the document and choose…
- Excel Shortcut to Insert a Copied Row Without Replacing DataIn Excel for Microsoft 365 on Windows, copy the source row with Ctrl+C, select the destination row header,…
- How to Screen Record a PowerPoint Presentation with AudioTo record a PowerPoint presentation with narration, open the deck and choose Record > From Beginning in PowerPoint…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.