Spreadsheet Schema Manager

GitHub | Releases | Issues | Release notes

Spreadsheet Schema Manager (SSM) is a web app for standardising spreadsheet metadata and improving data consistency across projects and teams. Define your data columns once as Fields, generate ready-to-fill Excel workbooks from them, and bring existing spreadsheets into line with the same standard.

Spreadsheet Schema Manager overview

What you can do

  • Centrally define Fields: column definitions (Category, Measurement, Text, Number, Date) reused across projects, with import/export to and from Excel.

  • Generate Excel workbooks: group Fields into a Template, then create a Workbook with pre-filled headers and data validation, ready for data collection.

  • Standardise existing spreadsheets: upload legacy data as a Dataset, map its columns and values onto your Fields, and download a standardised copy. You can also use a legacy spreadsheet to bootstrap a new set of Fields.

Note

SSM currently supports spreadsheets containing a single table with a fixed set of columns and simple, single-row headers.

Where to start