Dewi said:I'm struggling to create a CSV for importing in to Garmin GPS.
I have Excel, happy to use notepad. Would rather use Excel then I can
better manage my routes etc.
I also use OS Grid references.
Anyone start me off with a sample line?
thanks.
Here are the first 8 and last 3 lines of a 225 line CSV file I made by
using the File>Save As option in the program G7toCE on my Pocket PC,
to save a track from a recent walk recorded on my Garmin GPS 12. Not
sure if it's what you need, but hopefully it will help. (I don't use
CSV personally; this was experimental.)
Version 2:CSV
Datum:,Ordnance_Survey_of_Great_Britain_36
ZoneOffset:,1.000000
"Type","Name|Color|Visibility","Lat","Long","Month#","Day#","Year","Hour","Min","Sec","Altitude
(Meters)","Depth (Meters)"
N,,51.04172170,-0.09554389,3,19,2005,13,44,4,1e25,1e25
T,,51.04222600,-0.09528635,3,19,2005,13,45,48,1e25,1e25
T,,51.04282150,-0.09472302,3,19,2005,13,46,38,1e25,1e25
..
..
etc
..
T,,51.04169488,-0.09562436,3,19,2005,16,2,16,1e25,1e25
T,,51.04171097,-0.09555998,3,19,2005,16,2,55,1e25,1e25
N,,36.83788320,-3.97367076,3,28,2005,6,52,38,1e25,1e25
--
Terry, West Sussex, UK