Spreadsheet fixtures

Multi-Sheet XLSX with Formulas

A two-sheet workbook where a Summary sheet references a Data sheet with SUM and arithmetic formulas — for testing spreadsheet parsers, formula evaluation, and converters.

File: XLSX · Excel
Use case: Spreadsheet testingConversion testing

Plain Single-Sheet XLSX

A single-sheet workbook of plain tabular values with no formulas — a baseline fixture for spreadsheet importers.

File: XLSX · Excel · 11 rows
Use case: Spreadsheet testing· Conversion set

ODS — OpenDocument Spreadsheet

An 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.

File: ODS · Excel · 11 rows
Use case: Spreadsheet testingConversion testing· Conversion set

XLS — Legacy Excel Workbook

A 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.

File: XLS · Excel · 11 rows
Use case: Spreadsheet testingConversion testing· Conversion set

XLSX with Embedded Charts

A 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.

File: XLSX · Excel
Use case: Spreadsheet testingConversion testing

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.

File: XLSX · Excel
Use case: Spreadsheet testingConversion testing

Monthly Budget Template (XLSX)

A monthly budget workbook with budgeted-vs-actual categories, per-row difference formulas, and column totals.

File: XLSX · Budget
Use case: TemplatesSpreadsheet testing

Expense Tracker Template (XLSX)

A simple expense tracker with date, category, description, amount, and a total formula.

File: XLSX · Expense Tracker
Use case: TemplatesSpreadsheet testing

Project Task List Template (XLSX)

A project task list with task, owner, status, and due-date columns.

File: XLSX · Task List
Use case: TemplatesSpreadsheet testing

Weekly Timesheet Template (XLSX)

A weekly timesheet that computes hours from start and end times minus breaks, multiplies by an hourly rate for pay, and totals the week with live formulas — good for spreadsheet and formula testing.

File: XLSX · Timesheet
Use case: TemplatesSpreadsheet testing

Content Calendar Template (XLSX)

A monthly content calendar tracking posts across channels with owner and status columns and a COUNTIF that tallies published items — a realistic marketing planning sheet.

File: XLSX · Content Calendar
Use case: TemplatesSpreadsheet testing

Gantt Chart Template (XLSX)

A lightweight Gantt chart: eight project tasks with start and end weeks and a coloured cell bar spanning each task's duration across an eight-week grid.

File: XLSX · Gantt Chart
Use case: TemplatesSpreadsheet testing

Habit Tracker Template (XLSX)

A weekly habit tracker with a checkbox grid across seven days, a COUNTIF that counts completed days, and a goal column — a simple personal planning sheet.

File: XLSX · Habit Tracker
Use case: TemplatesSpreadsheet testing

Event Planner Template (XLSX)

A two-sheet event planner: a budget sheet with estimated-versus-actual difference formulas and totals, plus a task sheet with owners, due dates, and status.

File: XLSX · Event Planner
Use case: TemplatesSpreadsheet testing

Grade Tracker Template (XLSX)

A gradebook that computes a weighted average from homework, midterm, and final scores, assigns a letter grade with nested IF, and averages the class — good for formula testing.

File: XLSX · Grade Tracker
Use case: TemplatesSpreadsheet testing

Budget Template (ODS, with formulas)

A budget template as OpenDocument Spreadsheet — budget-versus-actual rows with live SUM formulas for the totals. A usable planning template and a fixture for testing ODS formula parsing and recalculation.

File: ODS · Budget
Use case: TemplatesSpreadsheet testing+1· Conversion set

Project Risk Register (XLSX)

A scored delivery-risk register with owners, mitigations, triggers, and review dates. This Excel workbook adds filters, frozen headers, print settings, typed cells, and live formulas where the model defines them.

File: XLSX · Planning · 8 rows
Use case: TemplatesConversion testing+1· Conversion set

Event Run of Show (XLSX)

A minute-by-minute production schedule with cues, ownership, locations, and contingencies. This Excel workbook adds filters, frozen headers, print settings, typed cells, and live formulas where the model defines them.

File: XLSX · Planning · 11 rows
Use case: TemplatesConversion testing+1· Conversion set

Vendor Evaluation Scorecard (XLSX)

A weighted comparison of fictional vendors with evidence notes, decisions, and review ownership. This Excel workbook adds filters, frozen headers, print settings, typed cells, and live formulas where the model defines them.

File: XLSX · Business · 5 rows
Use case: TemplatesConversion testing+1· Conversion set