Gallery
Seven real spreadsheets published by UK government bodies, redistributed here exactly as they were released, under the Open Government Licence. Each one has a specification file of a few lines, and each produces a readable HTML report.
They were chosen for their awkwardness as much as their content: sheet names with spaces
in them, column headings running to twenty words, padding cells, mixed precision, -
markers for nil, and one workbook of nineteen sheets from which the specification takes a
single statement. Between them they cover most of what a real workbook will do to you.
- flat release retail A statistics release with a cover sheet, a contents sheet and a named Excel Table.Office for National Statistics
- ledger slgfs A council revenue account: subservice lines rolling up to All Services.Scottish Government
- ledger pesa A three-tier spending statement across six years of outturn and plans.HM Treasury
- ledger dwp Estimate lines under Resource and Capital budgets, on a sheet named with a space.Department for Work and Pensions
- ledger wales A revenue account whose columns mix pounds, percentages and per-head figures.Welsh Government
- ledger cra Spending classified by international function, with dashes marking nil.HM Treasury
- large workbook nbs Nineteen sheets, from which the specification takes one headline statement.Office for National Statistics
