V. Formatting the Data for Code

Remove GPS .csv file Meta Data Rows (top & bottom)

Remove Blank Columns

Highlight Column to Split

Split TimeLocal Column > Date | Time to make sorting easier

Separate Route Data

Add comments, type and iconColour for each waypoint

Sort Type Column

Copy location data to code template; see Concatenation formula for javascript waypoint code

Top row code to copy down

Finished javascript waypoint code

Copy Converted LeafletMarker coordinate data code

Paste LeafletMarker Data code into Map LayerGroup; replace last comma with semicolon