• home

UKCP09: Format of time series text files

For daily data, the first two rows contain the British National Grid easting and northing of the grid point (i.e. the centre point of a 5 x 5 km grid cell). Subsequent rows contain the date in the first column, followed by values of the climate variable for each grid square. Columns are separated by commas. The files are provided in 50 x 50 km blocks (170 files to cover the UK) so that the full time series can be provided in a single file, and so that the files do not exceed the column limit of Microsoft Excel 2003.

easting,    352500, 357500, 362500,...
northing,   302500, 302500, 302500,...
1960/01/01, value,  value,  value,...
1960/01/02, value,  value,  value,...
1960/01/03, value,  value,  value,...
etc.

For monthly and annual data, the first two columns give the British National Grid easting and northing of the grid point. Subsequent columns contain values of the climate variable for a monthly or annual time series. Columns are separated by commas, and headings are given in the first row. The monthly files are provided in 20-year blocks so that they do not exceed the column limit of Microsoft Excel 2003.

easting, northing, Jan-1980, Feb-1980, Mar-1980,…
352500,    302500,    value,    value,    value,...
357500,    302500,    value,    value,    value,...
362500,    302500,    value,    value,    value,...
etc.

To identify the grid cells that cover a particular location, please use this map or refer to Q19 in the list of FAQs.


Related internet links

Department for Environment, Food and Rural Affairs (Defra)

The Met Office is not responsible for the content of external internet sites.


Get updates