How To Import

solved
(cue tipper) #1

I have an excel spread sheet with my addresses. How can I import them?

(Gerry Shaw) #2

I don’t believe it’s possible to import an Excel spreadsheet or even CSV file of addresses. You would need to get the addresses converted to long/lat values as waypoints and import the GPX or KML file.

Converting street addresses to locations on a map is beyond the capabilities of MapHub.

(cue tipper) #3

Thank you for your response. As it turns out I do have lot / lan on the excel sheet. What is a gpx file? Can I convert from xl to it? How?

(cue tipper) #4

Please disregard. Found the answers. Thanks.

(Zsolt Ero) #5

Hi Cue,

There are two questions here, which I’m trying to answer.

How to convert a large list of addresses to lat-lon coordinates. This is called “geocoding”, and MapHub cannot do this at the moment, but here are two websites which can do this:

  1. GPS Visualizer, using Google, Bing, MapQuest API keys
  2. MapLarge Geocoder, minimum $10

How to convert an Excel file to GPX/KML. The best solution is to export as CSV and convert using GPS Visualizer.

You say you’ve found the answers, can you share which solution worked for you?