Speedy Route Tips and Tricks #2

Export


So you've successfully calculated an optimal route for your locations, and can see the route displayed on Speedy Route's map. But what if you need to make the calculated route available to another system or store it in Excel? That's what the 'Export' tab in Speedy Route is for!

Click on the 'Export' tab above the map (next to the 'Directions' tab), and you'll see your route displayed in a CSV (comma separated values) format. Experiment with the checkbox settings (Headers, Order, Location, Lat/Long) to alter the format and content of the export as appropriate.

There is now also an option to export GPX files instead of CSV files. GPX files can be used by some SatNavs such as TomTom and Garmin devices. (Please see your GPS device instructions for how to upload GPX files to your SatNav).

Once you have set the export format correctly, click in the middle of the export results and Select All (Ctrl-A on a PC keyboard or Command-A on a Mac keyboard). You can then copy (Ctrl-C / Command-C) and paste (Ctrl-V / Command-V) the results into Notepad or Excel etc.

Excel Import Settings


If you copy the route export results and paste them into a new Excel Sheet, a small popup menu appears in Excel that provides full access to the Excel Text Import option. Click on this Excel menu, or press the Ctrl button on your keyboard immediately after pasting in the export results. Then choose 'Use Text Import Wizard' from the dropdown Excel menu.

Choose the options 'Delimited', ensure that both 'Comma' and 'Space' are selected as Delimiters, and also select 'Treat consecutive delimiters as one'.

Finish the Excel Text Import wizard and you'll now have a perfectly imported calculated route list in Excel!

No comments:

Post a Comment