Insert empty column to the right of the merged coordinates column. In Excel 2010 you can separate those rather easily. Notice, that both Latitude and Longitude in in the same column, separated by comma.
If your data had polygons, each field will have two lines, sort by coordinates column and erase empty lines. Agree to everything! If all goes well you should see the table with all your data similar to It will recognize it as XML table and suggest schema. In File tab, hit Open and open the NEWFILENAME.xml file. Open a new MS Excel file (or the file with your tabulated data information you want to bring KML location data in). Then type NEWFILENAME.xml together with extension Go to File/Save As and select “all files” option. It will show XML formatted text in Notepad. Right click the KML file and select “Open with” Notepad:
So, you will need to re-name the KML file so it has XML extension. If you click Yes, Excel will recognize the file as XML, but will fail to import it nevertheless. Google Earth KML files are essentially XML files with geographical information, but Excel will not open them directly. There are a few little tricks to it, though… If you have some data in table format with IDs for fields or point locations on the map and Google Earth KML file with those fields having same IDs, it is generally possible to bring spatial information to Excel and merge those data sources together to use in further spatial analysis in other GIS software and in newly released FREE ESRI Maps for MS Office Beta 2.
0 kommentar(er)
