Plain Single-Sheet XLSX
A single-sheet workbook of plain tabular values with no formulas: a baseline fixture for spreadsheet importers.
Rendered preview of the xlsx file (4.9 KB). Download above for the original.
Specifications
- Sheets
- 1
- Rows
- 11
- Formulas
- none
Testing contract
Expected to pass- Scenario
- Exercise Plain Single-Sheet XLSX in its excel workflow. A single-sheet workbook of plain tabular values with no formulas: a baseline fixture for spreadsheet importers.
- Expected result
- ZIP package contains 9 members; worksheet names: Sheet1; package contains 0 formulas and 0 chart parts. Declared feature checks: sheets=1; formulas=none.
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.
How to use this file for testing
“Plain Single-Sheet XLSX” is a deterministic Testaroo fixture for Spreadsheet testing. Multi-sheet workbooks with documented formulas and plain sheets for testing spreadsheet parsers and importers.
Documented properties for this file: 11 rows · 1 sheets. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Document fixtures list their internal structure (pages, fields, tracked changes, embedded objects) in the spec table. Test extractors, converters, and OCR against that known structure, and compare searchable↔scanned or format-twin companions when present.
Code examples
from openpyxl import load_workbook
wb = load_workbook("plain-single-sheet.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)Generated by generation/docs_office.py. Free for any use, no attribution required, license.
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.
- 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.
- xlsxXLSX with Merged Cells, Conditional Formatting & Data ValidationA 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.
- xlsxAlder Table Bistro: Cost of goods sold workbook with live formulasCost of goods sold workbook with live formulas for Alder Table Bistro. Four sheets. COGS computes opening plus purchases less closing for 6 ingredients; Reconciliation proves the identity usage and waste at standard, plus the purchase price variance, less the count variance, equals the reported figure; Summary lands on 1574.81 CAD against 15780.80 CAD of net menu sales, a food cost of 9.98 percent. The purchases line is the sum of the 24 shared purchase rows dated inside 2026-08-20 to 2026-09-02.
- xlsxAlder Table Bistro: Inventory variance workbook with live formulasInventory variance workbook with live formulas for Alder Table Bistro. 6 ingredients over two sheets. Theoretical closing, the variance quantity, the variance priced at standard cost, the below-par flag and the total are formulas. Theoretical usage is built from the sales table multiplied by the yield-adjusted recipe quantities, so it already carries the yield adjustment.
- xlsxAlder Table Bistro: Procure-to-pay workbookProcure-to-pay workbook for Alder Table Bistro. 9 worksheets holding the same rows as the CSV exports plus a 'Deliberate defects' sheet naming all 6: Price list 48 rows; Purchase orders 12 rows; Goods received 12 rows; Invoice lines 14 rows; Credit notes 2 rows; Statement 13 rows; Remittance 13 rows; Three-way match 14 rows; Deliberate defects 6 rows. Money cells are numbers formatted 0.00 rather than text, so a spreadsheet reader can sum a column without parsing strings.
