UK Grid Reference Finder

BATCH CONVERT TOOL

Batch Convert Latitude, Longitude to UK Grid Reference or UK Grid Reference to Latitude longitude

Instructions

Follow the steps below to convert location data from one format (osgb36 to wgs84 or wgs84 to osgb36) to another. Your data can be tab or comma separated (the character between your data fields).

You can paste data directly from your Excel spreadsheet or Google spreadsheet document (the format will be detected automatically as tab and you only need to identify the columns holding your location data i.e. the columns holding the lat lng, grid reference or X Y values.

When the location data columns are identified press convert. You can copy the converted data directly back in to your spreadsheet.

For postcode data use our Batch Postcode Converter here

Example Data
Copy and paste the three lines below. Paste them in to the text box in Step One and then press convert. The data will have the grid reference and X Y co-ordinates appended to it in the text box in Step Six below.

54.970520,-1.6246033,Point A
54.891616,-1.3774109,Point B
54.812061,-1.5716002,Point C

1
STEP ONE - PASTE YOUR DATA TO CONVERT
Paste Your Data Here
2
STEP TWO - CONVERT FROM WHAT FORMAT
What Location Format Are You Converting From
3
STEP THREE - WHICH COLUMNS HOLD THE LOCATION DATA
Which Columns Hold Your Location Data
Latitude Column Longitude Column
Grid Reference Column
X Column Y Column
4
STEP FOUR - FIELD SEPARATOR
What Character Separates Your Data Fields (Note: This should be auto selected for you, only change if required).
Field Separator
5
STEP FIVE
Press to Convert Your Data (make sure you have selected the data location columns correctly above)
6
STEP SIX
Output Data to Copy Here
7
STEP SEVEN
Press to Show Your Converted Data on a Map or export to Google Earth File
Point Label Column Number
   or       or