HomeMicrosoft


Importing from Excel to Streets & Trips - keeping order of stops
navigate1
Trying to import latitude and longitude from Excel into Microsoft Streets and Trips - which is not the problem. The issue is that I want to keep them in order. Example in .txt attachment.

When I import into Streets & Trips, the pushpins do not keep the same stop sort #. Stop 1 might become pushpin # 18 and so on. I must maintain the stop # or a time label for reference.You can go in and sort manually by moving each stop from the legend but this would take a long time. I am looking at an average of 50 lat/longs per trip. Any suggestions appreciated.
Attached Files
File Type: txt stopslatlong.txt (2.7 KB)
Marvin Hlavac
Hi navigate1,

Welcome to Laptop GPS World.

RouteWriter: Export Microsoft MapPoint Route WayPoints to Excel - that's an add-on that addresses the issue. Unfortunately it doesn't work with Microsoft Streets & Trips. It only works with the more expensive Microsoft MapPoint.
navigate1
Thanks for the information - Have access to MapPoint, will try it.
laptopgpsworld.com About