POI Editor and converter

[BertM]

After starting with Excel to convert POI I have changed to Java script in Google Sheets.
The main reason is that I do not have Excel on my home computer, but have a google account.
pre is that I can convert the POI data everywhere when there is a computer available, downside is that you need a Google account.
After some playing around and some help from my new friend Chatgpt I have managed to do the following in Google sheets:

• Import and export KML and GPX files.
  Import is done from a folder Named "Import" in Google Drive.
  Export can be done to Google Drive and downloaded.
  (Import from the computer gave some issues and unstability due to the restrictions of Google to import files
  into the server side, so I removed this function.)

• Geocode the sheet with name, address, city and country with the help of Google.

  • Geocode for the Garmin navi, Google MyMaps etc with different fields
    (Google only fills in the field known to the coordinates, so sometimes not all the field are inserted.)
  • Geocode for MRA in the Name field of the GPX, as MRA only imports this field.:
    Brackets can be inserted after the name and the address in inserted between the brackets.
    The color of the address can be changed for better visibility in the Sheet.

Geocoding can be done on a single field or on multiple fields.

• Check the POI in Google Maps

I am not a programmer, so the programm is not 100% but it does what it needs to do.

If there is interest in the program I can post it on Github and share the Google Sheet, but I then must add some documentation to it.
So if more then 5 people are interested I will do the above effort

some screen shots:

Imported file

file menu

Geocode the first 5 rows by selecting Latitude and Longitude

"Special MRA tools" to fill in address in the Name field.

Screenshot with added address in namefield ( in different colors) and the export dialog.

POI GPX imported in MRA where in the Namefield the address is added between brackets.