Excel distance calculator is developed using Visual Basic macro. For those who are not really into programming, we have made this tool as easy as possible to use (refer to screenshot below). Just enter coordinates of two locations and press “Calculate” button to run the program and show the distance.