Legacy File Converter logoLegacy File Converter
History Lesson9 min read

History Lesson: What Is a .fods File? The Spreadsheet Written Out as Plain Text

LibreOffice’s Flat XML ODF Spreadsheet: a whole .ods workbook spelled out in one uncompressed XML file — a form the OpenDocument standard defines but lets programs skip, which is why Excel opens .ods and not .fods.

·By the Legacy File Converter team
A long cream spreadsheet scroll unrolling past an open teal box, with a magnifying glass over its grid and an amber seal, on navy, no logos

TL;DR

A .fods file is a Flat XML ODF Spreadsheet: an OpenDocument Spreadsheet — the workbook format behind .ods — written out as one uncompressed XML file instead of a ZIP package. The OpenDocument standard defines that single-file form but does not require programs to read it, which is why Excel, which opens .ods, does not list .fods. LibreOffice’s source history shows the flat spreadsheet filter in place by September 2010 and rewritten without style sheets in January 2011, and since May 2016 .fods files have served as the test sheets that check Calc’s own formulas.

What is a .fods file?

A .fods holds the same thing as a .ods — sheets, cells, formulas, styles, and settings described in OpenDocument markup — but packs none of it. XML (Extensible Markup Language) is the tag-based text format that markup is written in. A normal .ods is a ZIP archive holding several XML parts; its story, from StarCalc to the ODF standard, is in History Lesson: What Is a .ods File?. A .fods is one long XML file you can open in Notepad.

The Library of Congress, which describes file formats for its digital collections, puts it plainly: the ODF specification covers “a flat form as a single XML file and a package form,” and in “a flat ODF spreadsheet file, usually given a file extension of .fods,” the outermost office:document element carries an office:mimetype attribute that names it a spreadsheet. The extension is a convention rather than part of the standard. LibreOffice uses .fods for spreadsheets just as it uses .fodt for text documents — the flat text format has its own History Lesson.

Why won’t Excel open a .fods file?

Microsoft’s support page on file formats supported in Excel lists OpenDocument Spreadsheet (.ods) and says Excel can open and save it. The flat .fods is not on that list, and the standard leaves room for that. Section 2.4 of OpenDocument 1.4, Part 3 says a conforming consumer — any program that reads ODF — “shall” be able to read at least one ODF document type, but only “may” be able to read documents “stored as a single XML document.” A program can support OpenDocument properly and still never open a .fods.

Renaming it to .ods will not help

A .ods is expected to be a ZIP package that begins with a small mimetype file. A .fods is plain XML with no ZIP inside, so changing the extension leaves a file that matches neither. Open the .fods in LibreOffice Calc and save it as .ods or .xlsx, or convert it with a tool that reads flat OpenDocument.

How the bytes work: a grid spelled out in text

A .fods reads from top to bottom: an XML declaration, the office:document root, then metadata, settings, fonts, and styles, and finally the body, where each sheet is a table:table made of table:table-row elements holding table:table-cell elements. The cell markup itself — value types and formulas — is the same as in a .ods and is covered in the .ods lesson. What stands out in a flat file is how the format avoids writing out empty space. The standard’s table:number-columns-repeated attribute lets one cell element stand for adjoining cells that have “the same content and style,” and table:number-rows-repeated does the same for rows. One of LibreOffice’s own test files ends a row with a single empty cell marked table:number-columns-repeated="28": twenty-eight blank cells in one short tag.

Formulas sit in the open, too. In the same file a check cell carries table:formula="of:=[.A720]=[.B720]" — the of: prefix marks OpenFormula, the formula language standardized with ODF 1.2 — and right beside it the last calculated result, office:boolean-value="true", with the displayed text TRUE. Because results are stored next to formulas, a program that cannot calculate can still show the numbers. LibreOffice recognizes the file by its content: its type registry accepts the extensions fods, ods, and xml for the flat spreadsheet type, looks for office:mimetype="application/vnd.oasis.opendocument.spreadsheet" on the root element, and files the type internally under the media type application/vnd.oasis.opendocument.spreadsheet-flat-xml.

2010–2013: from style sheet to built-in filter

The flat form was in the standard from the start, and the first way to save it from OpenOffice.org was an XSLT style sheet — a set of rules for transforming one XML file into another. That early story belongs to the .fodt lesson. For spreadsheets, the useful dates are in LibreOffice’s source history: the configuration file for the flat spreadsheet filter, alongside its text, presentation, and drawing siblings, was in place in LibreOffice’s code by 30 September 2010, two days after the project was announced.

On 10 January 2011, contributor Peter Jentsch committed an “alternative implementation of flat xml filter w/o xslt.” Instead of running a style sheet, his code “simply dumps the SAX events” to the output file. SAX (Simple API for XML) is a stream of messages — element starts, text, element ends — and LibreOffice’s XML filter machinery already produced that stream for its own OpenDocument export. The commit message admitted that the new filter still lacked the “advanced pretty printing” of the XSLT route. Today’s filter definition still points to that native service, OdfFlatXml, and since a 10 November 2013 change by Bryan Quigley the Save As entry has read Flat XML ODF Spreadsheet.

The spreadsheet that tests the spreadsheet

One busy modern home of .fods files is LibreOffice’s own source code. On 14 May 2016, Calc developer Markus Mohrhard added a framework for “new calc function tests,” and the first test sheet, yearfrac.fods, arrived the same day from a contributor credited as Raal. Each file is an ordinary workbook. Its rows list a formula, the expected answer, a TRUE/FALSE check, and the formula written out as text; the test program loads every .fods in the folder, recalculates it, and fails if the summary cell B3 on the first sheet is not true.

Volunteers filled the folders quickly. Zdeněk Crhonek added database functions such as DAVERAGE and DGET in May 2016, and in September 2016 a LOOKUP sheet that was 19,515 lines of XML on its own. At the end of 2016 the tests were split into folders by function category. Because they are plain text, a change shows up in review as readable lines: a June 2025 LOOKUP test by Xisco Fauli added 17 lines to that same file.

Readable is not the same as safely editable

You can fix a typo in a .fods with a text editor, but a single missing closing tag makes the whole file invalid XML, and editing a stored result does not change the formula that produced it. Work on a copy, and let a spreadsheet program recalculate before you trust the numbers.

Why .fods files still exist in 2026

OpenDocument 1.4, approved as an OASIS Standard on 6 October 2025, still defines the single-XML-document form and still makes reading it optional. LibreOffice still offers Flat XML ODF Spreadsheet in Save As. The .fods files people meet today tend to come from places where readable text matters more than a small file: test suites and templates kept in Git, budgets and reports generated by scripts that write XML directly, and LibreOffice users who picked the flat option once and kept it. Sent to someone with Excel, they arrive as legacy files that the recipient’s spreadsheet program does not list.

Legacy File Converter lists .fods (OpenDocument Spreadsheet, flat) among supported spreadsheets on Supported File Types and converts it on your own Windows PC — to XLSX for Excel, CSV when only the values matter, or PDF, Markdown, or HTML — without uploading it anywhere. Keep the original .fods as well: it is plain text, and it records the formulas along with their last results.

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.