Google Maps serves as a search engine to locate any place that people are looking for, as well as a map to lead them to that place. Sometimes we have some place details but we don’t know how to get there. We have no idea about the exact location. And that’s the reason we need Google Maps. And we can create it on our own with some information. In this article, we will demonstrate the procedures to create a Google Map with Excel data.
How to Create Google Map with Excel Data: Step-by-Step Procedures
Google has the largest share of the search market. Google Maps helps to assist individuals in getting from point A to point B. Maps also assist us in determining distances, allowing us to determine how distant one item is from another. We should be capable of determining locations on mapping since all maps scale the planet or its areas down to a fraction of their true size. To accomplish so, we will be capable of reading a map’s scale. So, Let’s get started to create a Google Map with Excel data.
Step 1: Prepare the Worksheet
To generate a Google Map, we need to prepare our spreadsheet data first. Suppose, we collect some employees’ detailed addresses.
- Firstly, we put their name in column A.
- Secondly, we place the street address in column B.
- Thirdly, in columns C and column D, we insert the city and the state sequentially.
Read More: How to Create a Map in Excel
Step 2: Save or Export Spreadsheet with Excel Data
Now, we need to save or export the spreadsheet to store data in a format to recognize the file. After saving or exporting the Excel data, It may be opened and edited by a program that recognizes and supports this file format.
- In the first place, go to the File tab from the ribbon.
- This will take you backstage to the Excel file.
- Now, click on the Save option to keep the data for further processing.
Step 3: Import Excel Data into ‘Google My Maps’
At this point, we have to import the data into Google My Maps.
- Open a web browser. In this case, we are opening the Google Chrome browser.
- Then, from the Search Google or type a URL section, go to Google My Maps. This is a service from Google that allows us to create our custom Google Maps.
- Next, to import the Excel spreadsheet, click CREATE A NEW MAP.
- This will take you to the screen where you can see the import button.
- So, click on the Import button.
- Now, this will display the Choose a file to import window.
- You will see there are several options for importing files.
- But, we want to import the Excel spreadsheet data. And the file extension for the data is .xlsx. So, we choose Upload and click on Select a file from your device.
- You can see your computer window. Go to the correct folder, where the data of the spreadsheet is saved.
- Select the spreadsheet and click on the Open button.
- Instead of clicking on the Open button, you can select the Excel spreadsheet and double-click on the file to import it to create the map.
Read More: How to Map Data in Excel
Step 4: Setting Positions of Placemark and Column Title for Map
At this moment, we need to set up the position of the map and appoint the title for the map.
- After importing the Excel spreadsheet, this will display the dialog where all the columns will be imported.
- From Choose columns to position your placemarks, tick marks the boxes beside Street Address, City, and State. We want to be that specific so that it actually gets the street address accurately.
- Further, click on Continue to proceed.
- Furthermore, we need to decide how we want our placemarks to be titled when users see the map. So, in our case, we will choose Name.
- Finally, click Finish to complete the setting.
- The screenshot below shows the map we have just set up. You can see how they look on the map. The blue location pin is all of the exact locations of the employee arenas.
Read More: How to Plot Points on a Map in Excel
Step 5: Change Base Map
Now, we can do more with the map. Suppose we change the Base Map.
- Firstly, click on the tiny little triangle which is on the left side of the Base Map.
- Then, pick your base map as the requirements. So we picked Simple Altas.
Step 6: Change Style
We can change the placemark on the map. Right now, they are all blue, and they all have the same style. Let’s change that up a bit. For this, we need to change the style of the map.
- In the beginning, click on the Format Painter icon shown in the below picture.
- And, select the Name.
- This will change the placemark color and we can see that this will now be Styled by Name. Almost every name has a different color for its placemark.
Read More: How to Make a Population Density Map in Excel
Step 7: Open Data Table to Edit Data
If you want to edit data you can also do that.
- You can see the worksheet from where the data was pulled. Now, click the three dots on the right side of the spreadsheet.
- And, click Open data table.
- This will display the data which was prepared on the spreadsheet and is now shown up in the google map. You can now edit any data if you want.
And, the final step for creating the map is to share the map with users.
- To share the Google Map with other people, click on the Share button.
- This will open the Add name and description before sharing dialog box.
- Now, write the Map Title. So, we give the map title Employee Arenas.
- And, also we give a description for that map.
- Finally, click OK.
- Then, switch on the option for Anyone with this link can view and Let others search for and find this map on the internet.
- Next, just click on the copy option beside the link.
- Lastly, click on the Close button to complete the procedures.
- And that’s it! By following the above steps we can create a Google Map with Excel data. You can now view the Employee Arenas map.
Note: If you upgrade the spreadsheet after importing the spreadsheet into Google Maps. That will not change any data on the maps. You can only change the spreadsheet data by following Step 7.
Read More: How to Plot Addresses on Google Map from Excel
You can download the workbook and practice with them.
Watch Video – Create a Google Map with Excel Data
Conclusion
The above procedures will assist you in creating a Google Map with Excel Data. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section.
