Transferring GPX file data in and out of a spreadsheet.
Aim:
To load GPX file data into a spreadsheet, manipulate the data and recover the modified GPX file.
Files:
The gpx input file is gpx_spreadsheet_input.gpx, the spreadsheet file is gpx_spreadsheet_dataset.xls and the ouput file will be gpx_spreadsheet_output.gpx.
Process:
1) Go to
GPS Visualizer at
https://www.gpsvisualizer.com/convert_input?convert_format=gpx
2) Select
Output Format as Plain Text
3) Upload your GPX file by using the
Browse button
4) Click the
Convert button
5)
Download the resulting text file (it will have a numeric name)
6) Open the downloaded file in Windows notepad (or another text editor) and
copy all contents (ignore the apparent lack of line breaks)
7) Open spreadsheet,
paste downloaded file content into spreadsheet - if queried for 'delimiter' select 'tab'
8) Manipulate data - see gpx_spreadsheet_dataset.xls
Save modified GPX file
9) Select block of GPX data together with orginal heading
10) Copy block
11) Go to
GPS Visualizer at
https://www.gpsvisualizer.com/convert_input?convert_format=gpx
12) Select
Output Format as GPX
13)
Paste into the text window
14) Click the
Convert button
15)
Download the resulting GPX file
16) Rename downloaded file to something sensible
If there is a problem loading data into OpenOffice Calc, check this dialogue box. Note that in the Separator options section only the Tab box is ticked.
If there is a problem loading data into MS Excel, check the Text Import Wizard. Note that in the Delimiters section only the tab box is ticked.
Cartography Community Mapping, CCM, Entry Page
