Batch Convert Tool

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

STEP ONE - PASTE YOUR DATA TO CONVERT

Paste Your Data Here

STEP TWO - CONVERT FROM WHAT FORMAT

What Location Format Are You Converting From

Latitude and Longitude Grid Reference XY Location

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

STEP FOUR - FIELD SEPARATOR

What Character Separates Your Data Fields (Note: This should be auto selected for you, only change if required).

Field Separator

STEP FIVE

Press to Convert Your Data (make sure you have selected the data location columns correctly above)

STEP SIX

Output Data to Copy Here

STEP SEVEN

Press to Show Your Converted Data on a Map or export to Google Earth File

Select A Point Label Column Number For The Options Below

|

|

|

BATCH CONVERT TOOL

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