... the user friendly GPS tool


Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Editing NMEA file with Microsoft Excel ?
#2
Hi seligman, welcome at RouteConverter forum!
  • Take a short track for evaluation
  • The track should contain Description, Longitude, Latitude and Height information
  • Save this track as Columbus V900 Standard (*.csv) format
  • Open this file in Excel - all data are shown in one column, comma separated
  • Use Excel Data/Text in Columns to split one column into several columns (select commas as separator)
  • Copy data of column 'Height' into column 'Vox' (don't copy content of description line)
  • Insert new columns between each existing column, fill each field of new columns with one comma
  • Mark all existing data and copy the whole stuff into the clipboard
  • Use RouteConverter File/New to create a blank file
  • Put the curser into the blank position list, press RMB, Insert
  • Save the resulting track in *.kmz format
--
Matthias
Reply


Messages In This Thread
RE: Editing NMEA file with Microsoft Excel ? - by kumo - 27.11.2011, 11:43

Forum Jump:


Users browsing this thread: 1 Guest(s)