Advertisements

MkrGeo

An original point of view

GIS

Input a multiple address list to Google Maps and Google Earth – the quickest way

Address list from MS Excel to Google MyMaps

Random address list in London shown on the Google MyMaps platform

 

Google Maps as well as Google Earth are a very useful tools in terms of the location finding. An user can find a proper address quickly in any place in the World. Sometimes we are obligated to find a multiple location for different purposes. Then it can be a problem for someone, who must have a multitude of locations in a really short time. There are some solutions shown in the web how to input a lot of addresses to Google Map, however in my opinion they doesn’t show the quickest way of this process. I would like to show you the quickest and most convenient way to input a multiple locations from Excel to Google Maps and Google Earth at once. Moreover the aim of this article is also showing the ways, that we shouldn’t do when transferring the location data to Google Maps.
We can input the multiple location data in 2 ways: as a full address  (property number, street, postcode) or only a postcode  (valid for some countries like UK). Input the street with property number only for particular location may not have a sense, especially in big cities, where streets can be repeatable (eg. Like in Budapest). Let’s get started then.

I will show you the process in a few steps, which you can follow afterwards. Firstly I consider the task with full address details only.

  1. There is an excel spreadsheet underneath, where you have a column with full address (Pic. 1). It’s good to keep this column as it stands. All address elements are comma separated and better to leave it for the time being. Once you divide this data for more than one column then your address may not be shown in Google Maps properly. Why? You will read about it later in this article.
    MS Excel address list for London

    Pic. 1 An address list in Excel, ready to input onto Google Mymaps.

    MS Excel postcode list without address for London

    MS Excel address without postcode

    Pic. 2, 3. An alternative ways to prepare the address list in Excel, at least for UK addresses.

    MS Excel address list with UPRN

    Pic. 4 Google MyMaps allows us to put the table with max. 2 columns. Make sure, that they are nice and tidy as per in the picture above.

  2. Open your Google MyMaps account or create it first, if you don’t have it yet. Next create a new map with a name what you want (Pic. 5). Then your new map will be opened automatically. Focus on the main menu located on the left side of the screen.

    Google MyMaps add layer option

    Pic. 5 A blank GoogleMyMaps template with “Add layer” option marked.

  3. Click “Add new layer” and next name it as you want or leave it without name (Pic. 6).

    Google MyMaps add and edit layer

    Pic. 6 Changing name of the layer in Google MyMaps.

  4. Before you will import the data, go through your Excel worksheet and check is everything fine or not (Pic. 1-4). I mean are the single adresses in a correct column or is it clearly shown, etc. Some mistakes are described later in this article.
  5. Click “Import” link, located below (Pic. 7).

    Google Mymaps import layer option

    Pic. 7 The import option in Google MyMaps.

  6. Once you get the “Import” box opened, drag your excel file (Pic. 8). Alternatively you can select the file from a path in your computer, but it won’t be the quickest option then.

    GoogleMyMaps import option

    Pic. 8 Choosing file to import in Google MyMaps.

  7. Once you drag your file, the tool will ask about the main column, that data is going to be switched on as a placemark (Pic. 9-10). Obviously, when you decide to input more than 1 column.
    GoogleMyMaps import layer solumn selection

    Pic. 9 Choosing columns to position your placemarks.

    GoogleMyMaps import layer column selection address

    Pic. 10 Choosing a columns to title your placemarks.

  8. You should get your layer ready. See the effect on your map. Now you have all locations from your Excel spreadsheet.
    GoogleMyMaps layer finished address on the map

    Pic. 11 The address data from excel spreadsheet is arleady been placed on your Google MyMaps layer.

     

  9. Next step is up to you. If you are happy with locations placed on Google Map you can go straight to point 12 in order to transfer them into Google Earth. If not, then you can change the appearance of your signatures. In this case you must place your cursor on the list of your items, default called “All items”. When you do it, on the right side the brush signature should appear. Click on it to run more options (Pic. 12).

    Google MyMaps point colour settings

    Pic. 12 Colour and signature settings option in Google MyMaps.

  10. Once your items setting box pop up, then you can change both signatures and their colours as you want (Pic. 13).

    GoogleMyMaps layer finished change data properties

    Pic. 13 Colou and signature settings in Google MyMaps.

  11. The other option is clicking on the “Uniform style” label, placed just underneath the name of your layer, where you have got a few another options like sequence of numbers, etc. (Pic. 14 – 16).
    GoogleMyMaps layer finished change data properties for particular style

    Pic. 14 The uniform style settings in Google MyMaps.

    GoogleMyMaps layer finished change data properties_ coloured range

    GoogleMyMaps layer finished change data properties_legend

    Pic. 15, 16 Styling by data included in one of the column.

  12. Your particular places are listed in the metadata table. Here you can do some amendments like data sorting or add up some columns & rows. Here you can also find the stuff quickly. A click on a particular address redirect you instantly to place on the map (Pic. 17).

    Google MyMaps address list complete

    Pic. 17 When you have your data table opened, then after clicking on some random item you got it shown on the map instantly.

  13. Sometimes we may encounter a problem with address location. Google sometimes is not detailed enough (Pic. 20).

    Google MyMaps location defect

    Pic. 20 Google Maps defect – the addresses are not accurate enough sometimes.

  14. The procedure is the same for addresses in different countries (Pic. 21, 22).
    MS Excel address list Krosno

    Pic. 21 A random address list for some flats in Krosno (Poland).

    Google MyMaps address list map Krosno

    Pic. 22 …and their appearance on Google MyMaps.

  15. Now let’s download our address map as a .kml file in order to open it in Google Earth or a different GIS software (Pic. 23).

    Google MyMaps export as a KML

    Pic. 23 A .kml/.kmz download options in Google MyMaps. You can create a .kml file from both entire map, including all your layers or from a single layer only.

  16. Once you select your own way to download the .kml file, it will be saved in your “Downloads” directory. Having it shown on the bottom left of your screen as usual, open it. When you do this, your address list is going to be shown on Google Earth. Bear in mind, that a default zoom level may not meet your expectations, because a lot of labels located nearby is going to make their appearance really messy. However everything is going to improve, when you zoom in (Pic. 24). Alternatively you can remove some addresses from the list, comprising of your .kml file (Pic. 24).
Google Earth address list from Google MyMaps

Pic. 24 An example of  the .kml address list file, attached to Google Earth. The labels look quite congested, but you can remove some single addresses to make their appearance more tidy.

That’s all. You are done. Maybe the elaboration of this process was quite big, but trust me, you can do this whole process within 5 minutes!

The procedure shown above refers to the situation, when everything is alright so far. If not, some errors appear, as usual. A major case, that can generate an error is nonuniform data in address list. When your stuff is messy, then won’t be transferred properly into Google MyMaps (Pic. 25, 26).

MS Excel wrong address list

Pic. 25 An example of messy address list in MS Excel spreadsheet.

GoogleMyMaps layer finished_error

Pic. 26 And the result given in Google MyMaps.

When issue is too big, then you won’t see your addresses on the map at all. Google MyMaps also doesn’t like a tabs with multiple columns, that I have mentioned above. These are rejected automatically.

Mariusz Krukar

Links:

  1. An another example of transferring the data from Excel to Google MyMaps.

Youtube:

Read also:

1. How to show the coordinate grids in Google Earth and Google Maps?

 

 

 

 

 

 

Advertisements

Theme by Anders Norén

%d bloggers like this: