Data Entry from Google Earth to Speadsheet

I have 27 google earth files, each containing about 15 tracks. You need to open the files in google earth, you will see about 15 different tracks. You simple select each track, and save it out to the same folder, as KML files, so you end up with 15 files... i.e? ? [login to view URL], [login to view URL], 3.kml....... [login to view URL] OK, then you need open up the 2 spreadsheet I have attacheds, and enter some data into the database. for each track, you will need to enter; 1) the number... eg 1, 2,3..... or 15 2) Stage name (from the orginal goole earth file) 3) track lenght (which you can get from this site <[login to view URL]>) 4) time of stage (which you get from the link above) 5) the start and finisih ordinates (which you can get from each kml file you have created) * The co-ordinate acutally need changed around so that the big number is first... eg? 49.87310852754284,6.94283874301324 ? instead of 6.94283874301324,49.87310852754284 Ok, it may sound complicated, but it all data entry. I have attached sample file so you can have a look. ## Deliverables see high level for full details... attached are the sample files. There will be 26 further sets of these...