A lot of field work data is reported in the form of tables and spreadsheets. A field staff will normally document his or her field data in excel tables and then file them in with the report. Therefore, it is usually the first source to retrieve locational data from. We will be demonstrating this process using the DNR GPS software as an intermediary to do the conversion to GPX files as well as to upload the data into the GPS receiver.
In this demonstration, we will do the following:
– Save Excel data in a format that DNR GPS will recognize- Text Tab delimited.
– Convert using DNR GPS to GPX format
– Upload to the GPS as Waypoints, routes or tracks.
1. Launch microsoft Excel. Navigate to where the file is and Open in excel.
How to Check the Garmin GPS receiver for GPX files
Go to the Drive on your computer- Garmin Drive E
Open the drive and Click on the Garmin Folder
In the Garmin Folder, locate the GPX folder
Open the folder and look for the uploaded file.