Skip to content

Good Practice Tables (gptables)

Actions build statusPyPI release

gptables produces Excel spreadsheets that follow much of the Analysis Function guidance on releasing statistics in spreadsheets. This aims to implement digital accessibility standards like WCAG 2.2 as well as follow other good practice, such as the use of notes on cover sheets. gptables helps users by creating spreadsheets consistently and more quickly than implementing this manually.

Features

Some of the key features of gptables outputs are:

  • A minimalist presentation style
  • Coloured and underlined hyperlinks
  • Default text formatting in legible fonts and sizes
  • Formatted tables of contents and cover sheets
  • The ability to use custom themes to adapt gptables outputs to your needs

Note: This package does not create perfectly accessible spreadsheets. Users should refer to the releasing statistics in spreadsheets guidance and the spreadsheet accessibility checklist to ensure the standards are completely met.

Get in touch

Get in touch at ASAP@ons.gov.uk if you use gptables - we'd love to feature your work on the examples page, and get any feedback on how we make gptables even better.

Got a feature request, or found a bug? Raise an issue on GitHub.

gptables is built on top of XlsxWriter, bringing with it much of the XlsxWriter functionality. Users may also be interested in aftables, an R native equivalent to gptables, and csvcubed, a package for turning data and metadata into machine-readable CSV-W files.