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.
- 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.
- 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.
- Click “Add new layer” and next name it as you want or leave it without name (Pic. 6).
- 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.
- Click “Import” link, located below (Pic. 7).
- 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.
- 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.
- You should get your layer ready. See the effect on your map. Now you have all locations from your Excel spreadsheet.
- 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).
- Once your items setting box pop up, then you can change both signatures and their colours as you want (Pic. 13).
- 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).
- 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).
- Sometimes we may encounter a problem with address location. Google sometimes is not detailed enough (Pic. 20).
- The procedure is the same for addresses in different countries (Pic. 21, 22).
- 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).
- 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).
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).
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.