How do I add a map to my app?

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. A 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:

• longitude
• latitude

How do I get the geo data?

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:

http://willgeary.github.io//data/2016/11/04/Geocoding-with-Google-Sheets.html

The link forwards you to an external site for their content and correctness we assume no liability.

Select template

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 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.