The display of the individual entries on a map is based on the latitude and longitude values, which must be contained in your Excel file. Recognition by the "simple" address is not possible.
Add two columns to your Excel spreadsheet, which is used to maintain the values for longitude and latitude values in decimal notation.
The data for our headquarters are
- Longitude: 11.532224
- Latitude: 48.173812
It does not matter if these columns are at the beginning or end of your file. It is important to note the longitude and latitude values in adjacent columns.
You can name the columns in your source file as follows:
How do I get the geodata?
There are tools with which the longitude and latitude values of a conventional address can be found. Keyword: Geo-coding. As one tool is more appropriate than another, it is difficult to make a precise recommendation.
Using a Google script in Google Sheets, you can geocode Lat and Lon coordinates from address data (and vice versa). This tutorial will guide you through the steps necessary to set up a custom Google script and execute the geocoding functionality:
The link forwards you to an external site for their content and correctness we assume no liability.
The Open as App Wizard automatically detects that latitude and longitude values are present in your spreadsheet and suggests a "list & map" or "map" as a template.
The "List & Map" app created in this way consists of the classic list and an additional page on which the map is located. The individual entries are symbolized with a needle. Click on it to open the detailed view
Also with the "contact list" template your app consists of a list and map.