@@VoiceOfPeopleToday when i opened the excel the coordinates are in latitude and longitude( ex. 127.25824,7.72507), is it possible to get a northing and easting result( ex. 854878,197549) without converting it?
All the items in the kml file are copied in the excel list. Make sure to check all the columns of the produced excel file. All the items must be in one of the column
This didn't work for me - all the points had the same lat/lon when I tried it on a point set. Doesn't appear to work in this video either - notice that the graphical locations of points a&b for example at the start of the video are at different locations. But the coordinates in the Excel sheet at the end of the video are exactly the same. Same for points c&e, and f&g, and there is no point d.
When you open the kml file with excel there are several columns. Two of these columns (towards the end of the file) have unique coordinates for each point
Thanks for the feedback. The video will have the cover music soon. That's the maximum I can do on this (relatively) old video. If you have any preference/request about Excel/GE tricks feel free to propose for a new video. Everything will be considered. Regards.
@@VoiceOfPeopleToday sorry but im new here, my google earth crash and all my datas were lost. i tried to export from excel but only 10 was trasported. in my excel it has 59 items but only 10 was plotted to GE. does this mean that the other ccordinates that are not plotted are wrong
@@jonahroa9428 For sure there's something wrong woth the format of the coordinates. For more info regarding excel data to Googel Earth follow this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vqx9a8yIHI0.html