Coordinate Conversion Spreadsheet (Lat Lon, Eastings, Northings, Grid Reference UK)

Coordinate conversion spreadsheet (UK)

Use a coordinate conversion spreadsheet to convert between:

• Latitude and longitude
• Eastings and northings (XY)
• OS grid references

All directly in Google Sheets, with no setup.

How the spreadsheet works

The spreadsheet includes three simple tables:

• Lat/Lon → Eastings/Northings + Grid reference
• Eastings/Northings → Lat/Lon + Grid reference
• Grid reference → Lat/Lon + Eastings/Northings

Paste your data into any table and the results update automatically.

Spreadsheet vs official OS tools

Ordnance Survey provides official coordinate conversion spreadsheets and tools.

These are highly capable but can feel more feature-rich than necessary for simple workflows.

For quick workflows, a simpler spreadsheet can be easier to use, especially when working directly in the browser.

Convert a single coordinate

If you only need to convert one point or need to view results on a map, you can use the online converter.

Summary

A coordinate conversion spreadsheet is the fastest way to convert multiple latitude and longitude, eastings and northings, and OS grid references in one place.

It works directly in Google Sheets and is ideal for batch and repeat use.