Can ExpertGPS output points to MS Excel in Name, X, Y format?


Peter K. from Canada asks:
quoteIs it possible to simply take the coordinates from your GPS receiver and have them exported to MS Excel in a simple point name,X,Y style? We are looking at this software after having looked into buying a Trimble GPS unit for GIS and simple plotting uses. Thank you for your time and effort!quote

How can I export GPS coordinates to Excel in “Name, X, Y” format?

GPS data in Excel in X,Y, Name format

ExpertGPS allows you to copy waypoint and trackpoint data from the List (left side of ExpertGPS window) and paste it directly into Excel, OpenOffice Calc, or any other spreadsheet or text editor. By defining a custom column layout in the Waypoint List in ExpertGPS, you can create a template that will be used whenever you copy and paste data. This allows you to set up your columns in ExpertGPS so the data you paste into Excel will be formatted exactly as you need it.

Peter specifically mentioned X,Y coordinates, rather than lat/lon. To switch between lat/lon, UTM, US state plane, or other coordinate systems, click Edit/Preferences in ExpertGPS, click on the My Coordinate Formats tab, and change the location to Canada (or your own country). Select your preferred coordinate format from the list of options for your local area.



Select data columns in ExpertGPS map software

Switch to the Waypoint List in ExpertGPS, and then click Select Columns on the View menu. The Select Columns dialog will appear. Check off the columns of data you need. In Peter’s case, these are the Coordinates (X,Y or lat/lon) and Waypoint columns. Since Peter wants his data in Name, X, Y format, drag the Waypoint column header to the left, so it appears before Easting and Northing.



Save column presets in ExpertGPS software for GPS mapping

If you are going to be using the column layout on a regular basis, save it as a preset so you can quickly switch back to it. On the View menu, click Save Columns, and enter a name for this layout.



Transfer GPS data to Excel using ExpertGPS

Now just Select All of the waypoints in the Waypoint List, click Copy on the Edit menu, and switch to Excel. Click Paste, and you’ll have your GPS point data in Name, X, Y format.


2 Responses to Can ExpertGPS output points to MS Excel in “Name, X, Y” format?

  1. almoudi says:

    almoudi libya:-

    (Is it possible to simply take the coordinates of libyan map. thank you for your time and effort! )

  2. Dan Foster says:

    Almoudi, yes, you can get coordinates off of almost any map. Here are some links to get you started:
    http://www.expertgps.com/help/calibrating-a-scanned-map.asp

Comments are closed.