index.md

layout	title
default	Introduction

Introduction

QuickCode On-Premises for the Office of National Statistics automates conversion from spreadsheets to datasets.

The layout of a particular spreadsheet is configured in a recipe. A recipe is a short script which explains where to find the observations in the spreadsheet, and how to find the values of dimensions for each observation.

A command-line tool called DataBaker then uses this recipe to convert Excel spreadsheets into usable data.

You can think of this as "unpivoting" and cleaning a spreadsheet, in a very general and powerful way.