XLSX: the Excel workbook format
XLSX is the default format of Microsoft Excel since 2007 and, like DOCX, part of the Office Open XML standard (ECMA-376, ISO/IEC 29500). A workbook holds one or more sheets of cells, and each cell keeps either a value or a formula that is recalculated when inputs change. Inside the ZIP package, XML files store the cells, shared strings, styles, charts and defined print areas.
Key facts
- Extensions
- .xlsx
- Media type
- application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
- Standard
- ISO/IEC 29500 (Office Open XML)
Where it is used
Spreadsheets run budgets, price lists, inventories, timesheets, sales reports and the tables accountants exchange every month. Banks and online services often let you download statements and transaction lists as XLSX, and LibreOffice Calc, Google Sheets and Apple Numbers all work with it.
Strengths
Formulas keep totals up to date, filters and sorting make large tables manageable, and the data stays structured, so it can be analysed, charted or imported elsewhere. Several sheets travel in one file, and number formats keep dates, currencies and percentages readable.
Limitations
A workbook is not made for reading on paper: wide sheets split across pages, and hidden rows, comments and formulas can confuse or reveal more than intended. Formatting depends on the program, and anyone can change values, so it is a poor format for a final record or an invoice.
Converting it to PDF
Excel to PDF prints the workbook through LibreOffice using the page setup saved in the file, such as print area, orientation and scaling. Set these in your spreadsheet first, or a wide table may spread over several pages. The PDF shows calculated values, not the formulas behind them.
Getting it back from a PDF
PDF to Excel looks for tables on each page and writes their rows and columns into an XLSX file, ready to sort and sum. Results are best when the PDF has a real text layer and clear columns. A scanned statement needs OCR first, and merged or ruled-less tables may need checking.
Convert with these free tools
Side-by-side comparisons
PDF terms explained
- Table extractionTable extraction turns tables printed in a PDF into rows and columns you can edit in a spreadsheet. Learn how it works, its limits and how to check results.
- OCR (optical character recognition)OCR turns the picture of a page into text you can search and copy. Learn how it works, what affects its accuracy and why a scanned PDF needs it.
Guides that put it into practice
- Invoices for your accountantStep by step: merge a month of PDF invoices into one file, stamp a reference on every page, turn the bank statement into Excel and send it all at an e-mail-friendly size.
- Print Office files as PDFStep by step: convert Word documents and Excel sheets to PDF, combine them into one file and add blank pages so each part starts on a new sheet in double-sided printing.
Common questions
- Does converting XLSX to PDF keep my formulas?
- No. A PDF only shows the values as they were calculated at the moment of conversion. Keep the XLSX if you need to recalculate.
- Why is my spreadsheet split across many PDF pages?
- The sheet is wider or longer than the page. Set a print area, landscape orientation or fit-to-width scaling in the workbook before converting.
- Can I convert an XLS or ODS file too?
- Yes. Excel to PDF also accepts the older .xls format and OpenDocument .ods spreadsheets.