Mutual conversion between GPX and Excel files in GPS

Conversion of GPX and Excel files in GPS (Chinese supported)

(14:33:49)

Reprinted

Tags: Gpsgpx file execl file conversion mapsource

Summary

 

GPX files are common map information files that can be recognized by various navigators and map software. Excel tables have powerful data editing and processing capabilities. This document describes how to export GPX map data and Excel tables.

 

 

1. Software Used

Windows XP SP3 Chinese Version

Excel 2003 Chinese Version

Mapsource 6.9.1 Chinese Version

Gpsbabel1.3.6 English version

 

2 Method

2.1 Excel files to GPX files

2.1.1 create an Excel file containing GPS data (see figure 1)

               Figure 1 Excel file containing GPS Data

Mutual conversion between GPX and Excel files (Chinese supported)Mutual conversion between GPX and Excel files (Chinese supported) "src =" http://s7.sinaimg.cn/bmiddle/53ca7b39g6e6863547336&690 ">

 

The Excel file must have the following features:

1st behavior latitude and longitude format:

A1 = "grid"    B1 ="Latitude/longitude hddd. ddddd °"

2nd behavior geocoordinate mode:

A2 = "datum" B2 = "WGS 84"

4th title of a behavior flight point:

A4 = "Header"B4 = "name"  C4 = "description" D4 = "type"    E4 = "position"

6th rows and subsequent actual data for destinations

A6 = "waypoint"    B6 ="Flight point name"C6 ="Flight POint Description"D6 = "User waypoint"   E6 ="Longitude and latitude"

 

2.1.2 save the file as a TXT file in Excel.

Click "file/Save as" in Excel. Select the Save type as "text files (tab-separated )"

 

2.1.3 use gpsbabell software to convert TXT files to MPs files

Open the GUI of the gpsbabell software.

Input Format: Select "Garmin mapsource-txt (tab delimited) (.txt )"

File: select the TXT file to be converted.

Select "Garmin mapsource-MPs (. MPs)" for output format )"
File: select the MPs file to be generated.

 

Click let's go. The MPs file is generated.

 

2.1.4 convert the MPs file format to the GPX file format.

Run the mapsource software, open the MPs file, and save it as a GPX file.

 

2.2 GPX file to Excel File

2.2.1 GPX file to TXT file

Use the mapsource software to open the GPX file and save it as a TXT file.

 

2.2.2 TXT file to Excel File

Run the Excel software, click "file/Open", and select "Open Text File ". In the import wizard, you can directly contact us.

 

At this point, the conversion from Excel to GPX is complete, and there are many steps in this article, because the TXT to MPS process is added to avoid Chinese garbled characters during the conversion process.

 

From: http://blog.sina.com.cn/s/blog_53ca7b390100e2cd.html