Nerd alert!

I'm used to working in hot, sunny places, and so doing archaeology in the UK is a bit of a shock for me. The problem isn't actually the rain, wind, and general unpleasantness of fieldwork, but the annoying Ordnance Survey Grid system. What's with all these letters? GISs don't like letters, they need an actual XY coordinate.

So, I did some detective work and have now created the magical OS Grid Reference conversion spreadsheet.* Just enter your OS grid reference (no matter how long) into the pretty pink box and - Bob's your uncle - it'll convert it into a usable 6 figure number. Don't say I never do anything for you!


~~~
* The only way I could host it was on Google Docs, and it's therefore editable by enyone. If you find it doesn't work, drop me a line.