I have coordinates in Korea 2000 EPSG:5181 projected coordinate system.

Is there a way to make a formulation in excel to convert these coordinates to lat long (WGS84)?

  • Which GIS software are you using?
    – whyzar
    Nov 7 '17 at 8:32
  • Not using any GIS software. I want to know the formulas to transform the above mentioned coordinate system because i have a lot of data to convert so I want to make an excel sheet to transform the coordinates. Can you help? Thanks for your kind response
    – Aqi
    Nov 7 '17 at 8:35
  • 1
    why you do not use gis software like gdal with batch processing ? Nov 7 '17 at 8:55
  • ... or use the official formulas from epsg.org/Portals/0/373-07-2.pdf page 45 ff with the parameters from epsg.io/5181
    – AndreJ
    Nov 7 '17 at 13:00

I would suggest looking into these two sources Converting UTM to Latitude and Longitude (Or Vice Versa)

enter image description here

and Coordinate Systems in the Plane

enter image description here

This program was recently updated using the formulas of Charles Karney (2010). His paper claims accuracy of a few nanometers. Excel has 15-digit accuracy, so the spreadsheet doesn't achieve that level, but is accurate to about 0.01mm.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.