Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a list of 40+ points for each work day in a month. I need to somehow calculate the distance between each of those points for each day.

I have a list of addresses in a database, house number, street, city, zip and state are all in separate columns so I can generate any output using some simple programming.

But I am stuck at importing addresses to MapPoint. I have tried import wizard but all it does is plots points on map and does not add to route planning.

Maybe there is an alternative to this? Or other way around it?

Thanks much.

share|improve this question

migrated from Oct 14 '11 at 13:11

This question came from our site for computer enthusiasts and power users.

When your data is imported as pushpins, select all the pushpins by holding down your right-mouse button at the upper left of the screen and drag a selection rectangle to the bottom right of the screen.

Go to the Route menu and choose Route Planner. In the newly opened pane, choose Add pushpins as stops.

This issue stucked me too.. I feared I should add all the pushpins one by one!... :D

Then you can click Get directions to calculate the route.

share|improve this answer
This will create the route in an arbitrary order, but you can manually set the order. Or set the start & end and then run "Optimize" to find the probable best order. (we also sell a product called MPRouteWriter which can automate some of this multi-point route management) – winwaed Sep 23 '14 at 13:21

If you right click on the imported group list in the Legends and Overview Panel, you can select add points as stops.
My only problem is that they do NOT add the stops if you have them in order on your excel sheet.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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