# How to Plot Addresses on Google Map from Excel (2 Suitable Examples)

Get FREE Advanced Excel Exercises with Solutions!

Google Maps is one handy app nowadays that helps navigate or locate unknown areas easier and more accessible. You can have your locations updated on Google Maps. This helps you find specific locations faster and share the locations you want with other people. In this tutorial, I am going to show you how to plot addresses on Google Maps from an Excel file.

## How to Plot Addresses on Google Map from Excel: 2 Suitable Examples

The main goal of this process is to plot our addresses on Google Maps. To do that, we need either a CSV, XLSX, KML, or GPX file. Microsoft Excel helps us to easily make an XLSX file. To summarize the process- we need to make an Excel file, import it into maps, and then save it as our map.

There are two examples of the process to help the steps better- one for plotting addresses within a state and one for plotting addresses in different states. You can use the same steps to plot addresses on a global scale too. Follow the methods for a better understanding or find the one you need from the table of contents above.

### 1. Plot Addresses from Same State on Google Map from Excel

To plot addresses on Google Maps from Excel, you need information about the addresses. This can be the city, state, actual detailed address, latitude-longitude of the locations, etc.

In this case, we are going to plot different addresses that are within a state on Google Maps. We are selecting the following dataset to plot them.

The dataset contains addresses of different companies within California. As shown above, the dataset starts at cell A1. Always have your dataset starting at this position as Google Maps can only read files that are or mimic the CSV format. Follow these steps to see how we can plot them on Google Maps.

Steps:

• Once you have the Excel file ready in your hand, save and close it. Then go to the Google Maps.
• Now select the menu on the upper-left side of the map interface.

• Then go to the MAPS tab and click on CREATE MAP at the bottom of it.

• After that, a new window will open up. On the upper left side of the tab, you can find the option called Import as shown in the figure below. Click on it.

• Next, select Select a file from your device in the new window, navigate to your file location, and open the file.

• After the upload is complete, select the columns that should be used while plotting the address on the map. We are selecting the Address, City, and State from our dataset.

• Once you have done that, click on Continue.
• Next, select the title for your marker. And then click on Finish. We are using the name column as our marker name.

As a result of these steps, the addresses of the Excel file will be plotted on Google Maps.

You can double-click on the Untitled map as shown in the figure.

And then add a name and description of the map that helps find it later on and share it with others.

The final output will look something like this.

### 2. Plot Addresses from Different States on Google Map from Excel

In this example, we will plot addresses across different states on Google Maps from an Excel file. We are choosing the following dataset that contains locations from different states.

As has been noted, the dataset should start from cell A1. Follow these steps to see how you can plot addresses in a country on Google Maps with the help of Excel.

Steps:

• Upon completing the dataset, save and close the Excel file. Then go to Google Maps.
• Then select the menu on the upper-left side of the map interface.

• Then go to the MAPS tab and click on CREATE MAP at the bottom of it.

• After that, a new window will open up. On the upper left side of the tab, you can find the option called Import as shown in the figure below. Click on it.

• Next, select Select a file from your device in the new window, navigate to your file location, and open the file.

• After the upload is complete, select the columns that should be used while plotting the address on the map. We are selecting the Address, City, and State from our dataset.

• Once you have done that, click on Continue.
• Next, select the title for your marker. And then click on Finish. We are using the name column as our marker name.

Consequently, the addresses of the Excel file will be plotted on Google Maps.

To change the name, you can double-click on the Untitled map as shown in the figure.

And then add a name and description of the map. This is helpful for finding it later on and sharing it with others.

Finally, it will look something like this.

Read More: How to Plot Cities on a Map in Excel

## Things to Remember

• The dataset containing the information for the addresses should start at cell A1.
• While creating more than one map, use different files for each one. Google Maps can only detect the first worksheet of an Excel file up until now.
• You can also use latitude and longitude instead of city or state to locate and plot addresses. Replace each with the other and the plotting would work fine.

You can download the workbooks with the sample dataset used for the demonstration from the links below.

This is the workbook containing the dataset to plot addresses within a state from Excel.

And this is the one containing the dataset for plotting addresses from different states.

## Conclusion

This concludes the method and examples to plot addresses on Google Maps from Excel. Hope you can comfortably plot your addresses now that you have gone through the article. I hope you found this guide helpful and informative. If you have any questions or suggestions, let us know below.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Abrar-ur-Rahman Niloy

Hi! my name is Abrar-ur-Rahman Niloy. I have completed B.Sc. in Naval Architecture and Marine Engineering. I have found my calling, if you like, in Data Science and Machine Learning and in pursuing so, I have realized the importance of Data Analysis. And Excel is one excel-lent tool do so. I am always trying to learn everyday, and trying to share here what I am learning.