XLSX with Merged Cells, Conditional Formatting & Data Validation
A dashboard sheet exercising the features importers miss: a merged title cell, a three-colour conditional-formatting scale, a data-validation dropdown, cell borders, and frozen panes.
Rendered preview of the xlsx file (5.5 KB). Download above for the original.
Specifications
- Merged Cells
- A1:E1
- Conditional Formatting
- 3-colour scale on Closed
- Data Validation
- Status dropdown (Open/Won/Lost)
- Freeze Panes
- A3
What is a .xlsx file?
XLSX is the default Microsoft Excel format, an Office Open XML spreadsheet stored as a ZIP archive containing worksheet XML, shared strings, styles, and formulas. It supports multiple sheets, cell formatting, charts, and calculated values. It is the standard for editable tabular workbooks.
How to use this file
Use an example XLSX to test spreadsheet parsing, formula and multi-sheet handling, shared-string extraction, and pipelines that read or generate Excel workbooks.
Related files
- xlsxMulti-Sheet XLSX with FormulasA two-sheet workbook where a Summary sheet references a Data sheet with SUM and arithmetic formulas — for testing spreadsheet parsers, formula evaluation, and converters.
- odsODS — OpenDocument SpreadsheetAn OpenDocument Spreadsheet with the same tabular data as the plain XLSX and legacy XLS — a member of an XLSX↔ODS↔XLS conversion set for spreadsheet importers.
- xlsXLS — Legacy Excel WorkbookA legacy Excel 97–2003 (.xls / BIFF8) workbook holding the same tabular data as the plain XLSX and ODS — for testing legacy-format readers and XLS↔XLSX conversion.
- xlsxXLSX with Embedded ChartsA workbook with a data table plus a native bar chart and a line chart bound to the cells — for testing whether spreadsheet parsers and XLSX-to-PDF converters preserve and render embedded charts.
- xlsxPlain Single-Sheet XLSXA single-sheet workbook of plain tabular values with no formulas — a baseline fixture for spreadsheet importers.
- docDOC — Legacy Word 97The formatted Word document saved as legacy binary .doc (Word 97-2003, OLE compound file) via LibreOffice. For testing legacy-Office parsers and DOC→DOCX conversion.
Generated by generation/docs_advanced.py. Free for any use, no attribution required — license.