Add bunch of numbered locations?

Question

To avoid carrying books and optimize things while traveling, I like to build a Google Map with sights and cafés/restaurants. I usually print it on paper or keep a PDF in my phone so that I don't pay for a data connection.

But single Google Map is unable to take a bunch of addresses as input and doesn't offer a way to number locations, it's very time-consuming. I had to find and download numbered thumbtacks. Here's an example of Prague I started today.

Are there add-on's to either Google Maps or OpenStreetMap that provide a better solution?

Ideally, I could just paste a list of addresses, it would add all the locations on a map, each with a number, and let me re-order the locations easily.

---

Google Maps has the option of importing date from a KML, KMZ, or GeoRSS file.

Could this be the solution?

Answer 1

Geographic data that describes a location can be geocoded and placed on a map very easily by using Google Fusion Tables which you can find under Google Drive.

Here is an example I made to show you how to add a list of addresses on Google Map.

Step 1:

Organize your address information into a excel or CSV table similar to this one below.

Step 2:

Open your Google Drive and create a new fusion table. Select the excel table you generated from Step 1 as your input table.

You will have a new Fusion table looks like this one below:

Step 3:

Click the column name "Address" and select the first option which is "Change"; then change the type of your address column to "Location" and click OK.

Step 4:

After that, go to file and click the option "Geocode" to map these addresses on Google map.

Step 5:

Click OK when the geocoding is done and you should have all of your addresses mapped. You will be able to customize the symbol and style of your results.

I believe this will give you what you want, and here is a documentation provided by Google about how to geocode addresses.