Step 4: Setting Positions of Placemark and Column Title for MapĪt this moment, we need to set up the position of the map and appoint the title for the map. Read More: How to Map Data in Excel (2 Easy Methods) 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.Select the spreadsheet and click on the Open button.Go to the correct folder, where the data of the spreadsheet is saved. So, we choose Upload and click on Select a file from your device. But, we want to import the excel spreadsheet data.You will see there are several options for importing files.Now, this will display the Choose a file to import window.This will take you to the screen where you can see the import button.Next, to import the excel spreadsheet, click CREATE A NEW MAP.This is a service from Google that allows us to create our custom google maps. Then, from the Search Google or type a URL section, go to Google My Maps.In this case, we are opening the Google Chrome browser. Step 3: Import Excel Data into ‘Google My Maps’Īt this point, we have to import the data into Google My Maps. Now, click on the Save option to keep the data for further process.This will take you backstage to the excel file.In the first place, go to the File tab from the ribbon.After saving or exporting the excel data, It may be opened and edited by a program that recognizes and supports this file format. Now, we need to save or export the spreadsheet to store data in a format to recognize the file. Step 2: Save or Export Spreadsheet with Excel Data Read More: How to Create a Map in Excel (2 Easy Methods)

Thirdly, in columns C and column D, we insert the city and the state sequentially.

Secondly, we place the street address in column B.

Firstly, we put their name in column A.

Suppose, we collect some employees’ detailed addresses. To generate a google map, we need to prepare our spreadsheet data first. So, Let’s get started to create a google map with excel data. To accomplish so, we will be capable of reading a map’s scale. 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.

Maps also assist us in determining distances, allowing us to determine how distant one item is from another. Google maps help to assist individuals in getting from point A to point B. Google has the largest share of the search market. Step-by-Step Procedures to Create Google Map with Excel Data

Download google my maps