Python (v3.5) script to generate a KML file to mark points on googlemaps from an excel sheet, with custom icons' colors.
# pip3 install openpyxl# pip3 install unidecode
Firstly, there has to be a column with the places' names as you provide their range on the script.
Then, point the column which have the respective pair of (Latitude,Longitude) coordinates.
Finally assign whether there is a colors column for the markers if you intend to have custom ones. (Attention: The default color is RED for no custom colors)
If everything worked as intended you shall have the kml file fully functional waiting to be imported.
Access "My Maps", and in any map on a empty layer, you'll see the Import button. Just upload the kml file and it will mark every point, with it's color, on the right spot on the map.
Voilá!
- Add more colors possibilities.
- Option to have column with points descriptions.
- Point if user have Lat,Long or Long,Lat format.
- If cell is blank on colors column -> default color.
- Get user input for default color as well as Input for layer's name and Map's name.