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.
There are countless websites where you can find out the latitude and longitude values of a conventional address. Add two columns to your Excel spreadsheet - here you will put in the values. It does not matter whether these columns are at the beginning or end of your file. The important thing is that the latitude and longitude columns are side by side.
The Open as App Wizard automatically detects that latitude and longitude values are present in your spreadsheet and proposes 'List & Map' as template for your app.
Switch between list and map
The app thus created will then consist of the classic list and an additional page on which the map is located. The individual entries are symbolized with a needle and can be clicked.