I wanted to know if there is a formula in Excel to convert latitudes and longitudes(in degrees) into x and y coordiantes(in km or m), a formula that takes into account the curvature of Earth. Any help will be really appreciated.
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

What you are looking for is a great circle route formula. If you could draw a perfectly straight line through a basketball from one point to the other (you will have to go through the ball) and then transpose that line to the surface you will have the great circle route. Here is a website I use to calculate such things. http://www.movabletype.co.uk/scripts/latlong.html Here is the Haversine Formula from that website Haversine formula: c = 2.atan2(√a, √(1−a)) d = R.c Where R is earth’s radius (mean radius = 6,371km); note that angles need to be in radians to pass to trig functions! 

