Legacy File Converter logoLegacy File Converter
History Lesson8 min read

History Lesson: What Is a .xlsx File? A ZIP of SpreadsheetML Excel Made the Default

Excel’s default workbook since 2007 — a ZIP package of SpreadsheetML parts that grew out of Microsoft’s early-2000s XML experiments and became Ecma-376 and ISO/IEC 29500 after a contested standards fight.

·By the Legacy File Converter team
A cream spreadsheet grid with a zipper opening to teal and amber part cards beside a dim old binary block, no logos

TL;DR

A .xlsx file is a ZIP package of SpreadsheetML XML parts: the Office Open XML format that Excel 2007 made its default in place of the binary .xls. Its first bytes are PK, the ZIP signature, and inside sit text files such as xl/workbook.xml, which lists the sheets, and sharedStrings.xml, which stores each unique string once. Microsoft announced the format for standardization in November 2005, Ecma International approved it as Ecma-376 on 7 December 2006, and ISO and IEC published it as ISO/IEC 29500 in November 2008 after a contested vote. Legacy File Converter converts .xlsx locally on Windows; nothing is uploaded.

What is inside a .xlsx file?

A .xlsx file is a ZIP archive wearing a different extension. Open one in a hex viewer — a program that shows a file’s raw bytes — and the first two characters are PK, the initials of Phil Katz, who created the ZIP format at PKWARE; the full signature is the four bytes 50 4B 03 04. That is why any ZIP tool can list a .xlsx, and why Microsoft’s developer documentation tells programmers to rename the extension from .xlsx to .zip to see the parts inside.

The standard calls each file in the archive a part, and its packaging rules the Open Packaging Conventions (OPC). The Library of Congress describes a minimal package with three top-level folders — _rels, docProps, and xl — plus [Content_Types].xml, which says what type each part is. The _rels/.rels relationships file points at the main office document, normally xl/workbook.xml. That workbook part lists each sheet by name, sheet ID, and relationship ID; a separate XML file under xl/worksheets/ (for example sheet1.xml) holds the cell grid for each sheet. Real workbooks add styles.xml for cell formatting, charts, tables, and embedded pictures as ordinary image files.

One spreadsheet-specific part is the shared string table, usually xl/sharedStrings.xml. SpreadsheetML stores each unique text value once in that table and puts a zero-based index in the cell, so a label repeated across thousands of rows is not written thousands of times. Microsoft’s Open XML documentation notes that Excel always creates a shared string table when it saves, even though a valid SpreadsheetML file can put short strings inline instead. That text-deduplication step is distinctive compared with Word’s .docx, where runs keep their text in the main document part.

Look inside a copy, not the original

Copy the file, rename the copy to .zip, and open it. Excel finds each part through the relationships and content-type lists, so a hand-edited package that breaks them may not open again. Keep the untouched original.

Why did Excel 2007 leave binary .xls behind?

Before 2007 Excel saved the binary .xls workbook, documented later as the Binary Interchange File Format (BIFF) family (see History Lesson: What Is a .xls File?). Microsoft’s 2006 developer overview of Office Open XML was frank about why the binary formats had to change: they reflected the in-memory structures of the applications, built for low-memory computers with slow hard drives, and editing them outside Office was a leading cause of file corruption. The new design kept one file for the user but wrapped separate parts in a ZIP container, so a program could read or replace a single sheet or the shared string table without rewriting the whole workbook.

XML had already appeared in Excel. A timeline posted by Microsoft’s Brian Jones in January 2007 lists an XML format for Excel with Office XP, and Microsoft’s 2006 overview notes that the Office 2003 XML formats worked for Word and Excel only — and that only Word’s was truly full-fidelity. SpreadsheetML in the 2007 release made the ZIP-of-XML design the default for new workbooks, alongside WordprocessingML for Word and PresentationML for PowerPoint.

2005 to 2008: from Microsoft’s format to an international standard

On 21 November 2005 Microsoft announced that it would co-sponsor submitting the new formats to Ecma International. Ecma formed technical committee TC45 that December, with members including Apple, Barclays Capital, BP, the British Library, Essilor, Intel, Microsoft, NextPage, Novell, Statoil, Toshiba, and the United States Library of Congress, and the specification grew to roughly 6,000 pages. Ecma’s general assembly approved it as Ecma-376 on 7 December 2006, by 20 votes to 1; IBM cast the single no vote, saying OpenDocument was the better future.

The product shipped first. Office 2007 reached business customers on 30 November 2006, a week before the Ecma vote, and shops on 30 January 2007. The rival spreadsheet format had already won its own approval: OpenDocument became an ISO standard in 2006 (see History Lesson: What Is a .ods File?).

Ecma then sent Office Open XML to ISO and IEC under their fast-track procedure. In the vote that ended in September 2007 it was disapproved, with about 3,500 comments. A ballot resolution meeting in Geneva on 25–29 February 2008 worked through just over 1,000 distinct issues, many countries changed their votes, and on 2 April 2008 ISO announced the approval thresholds had been met, with 75% of votes cast positive and 14% negative. ISO/IEC 29500:2008 was published in November 2008. InfoWorld reported that many had opposed it as unnecessary, since OpenDocument was already an international standard.

The ISO text defines two levels of conformance, Strict and Transitional, and keeps a part called Transitional Migration Features for compatibility with existing documents. The Library of Congress notes that Excel’s everyday .xlsx output is the Transitional variant, and that Office 2013 and later can write Strict but do not use it as the default because of backwards-compatibility concerns.

ZIP plus XML does not mean interchangeable

A .xlsx, a .docx, and an .ods are all ZIP packages of XML, but each uses its own vocabulary — SpreadsheetML, WordprocessingML, or the OpenDocument spreadsheet schema. Renaming one extension to another converts nothing. See History Lesson: What Is a .docx File? and History Lesson: What Is a .ods File?.

The extra x, .xlsm, and why old Excel could not open it

Microsoft’s overview explains the naming: the new extensions borrow from the binary ones by appending a letter, so .xls became .xlsx, .doc became .docx, and .ppt became .pptx. Macro-enabled workbooks get an m instead — .xlsm — so anyone can tell before opening that VBA code is inside, and Excel does not run macros from a file saved with the x extension. This lesson covers .xlsx only; .xlsm is a sibling package with an extra macro part.

Excel 2003 and earlier knew nothing of the new package. Microsoft published a free Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats, its download page dated 6 November 2006, which lets Excel 2000, XP, and 2003 open, edit, and save the new formats — the same pack family Word users needed for .docx. Microsoft also claimed the files could be up to 75 percent smaller than comparable binary ones, because XML compresses well and ZIP compresses the parts; treat that as a vendor figure that varies with the workbook.

Why .xlsx files still sit on disks in 2026

A .xlsx is not an obsolete format; it is the one Excel has saved by default for nearly two decades, so budgets, inventories, member lists, and lab sheets from every year since 2007 sit in it. The Library of Congress lists XLSX among preferred formats for datasets, and notes that properties such as author and last-saved date live in their own package parts. The files become legacy files when something around them changes: a PC without Excel, an old Excel without the pack, or a person who needs CSV, PDF, or another sheet format instead — including when a CSV export later trips Excel’s guessing (see History Lesson: What Is a .csv File?).

Legacy File Converter lists .xlsx among supported spreadsheets on Supported File Types and converts it locally on Windows. Nothing is uploaded. This article stays the history. For the binary format .xlsx replaced, see History Lesson: What Is a .xls File?; for the OpenDocument spreadsheet side of the story, see History Lesson: What Is a .ods File?.

Ready to open your old files?

Start free, then unlock unlimited conversions with a one-time $79.95 Standard license. Download the Windows installer — full features for up to 10 files.

Free trial

Full app features · up to 10 files

Windows 10 or 11

Free trial — convert up to 10 files. Download the Windows installer and convert locally on your PC.

Start free trial — Download installer

Direct Windows installer · offline MSI

Is this safe? — publisher, installer, and SmartScreen help

Requires Windows 10 or 11. No subscriptions.