'Converting Data Formats' Category

• Send Sales Territory Client Addresses from Excel or Outlook to your GPS

  

  Stacie R. writes: “Is there a GPS system that will allow me to import my sales territory which is on excel with columns such as Agency Name, Address, City, State, ZIP (similar to mappoint) onto a GPS? I could have 1000 or more addresses based on a several state territory which is why I [...]

  
  

  May 28th, 2009

• Convert GPS Tracks into Excel Spreadsheets or CSV

  Al writes: “I have a Garmin GPSMAP60CSX. I would like to create/convert the track files into spreadsheets. I can save the track file as a GPX, but I’m looking for the capability to convert that GPX file into a spreadsheet. I’m using a Mac system, but Windows options are also needed. This is to [...]

  
  

  May 28th, 2009

• Converting CSV Data to KML and SHP using Excel and ExpertGPS

  

  Arvind has a spreadsheet full of transportation routes in CSV format that he needs to be able to map. Unfortunately, the data isn’t in a standard format. Here’s how to use Excel and ExpertGPS to convert this data without any programming.

  
  

  April 3rd, 2009

• Using ExpertGPS Pro to update ArcMap layers after a GPS survey in the field

  

  JC wants to send polygon shapefiles from ArcMap to his Garmin Oregon 400t so he can conduct a field survey and mark changes on his GPS. ExpertGPS Pro will allow him to transfer shapefiles to his Garmin GPS, make changes in the field, and update his GIS database when he gets back to the [...]

  
  

  March 17th, 2009

• How to convert XY coordinates from New Mexico State Plane to a Garmin GPS

  Jim D. needs to convert XY coordinates from New Mexico’s state plane coordinate system into something he can send to his Garmin GPS. Dan Foster shows how to transfer State Plane Coordinates to a GPS using ExpertGPS Pro.

  
  

  March 2nd, 2009

• How to Convert KMZ to SHP: A Step-by-Step Tutorial

  

  Dawee M. writes: “I am looking at your programme ExpertGPS. Can the programme convert a kmz file from Google Earth to a shp file to use in GIS?” Dan Foster shows how to convert KML and KMZ placemarks and lines into shapefiles using ExpertGPS Pro.

  
  

  March 2nd, 2009

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

  

  Peter K. from Canada needs a way to export coordinate data from his GPS receiver to Microsoft Excel in a simple format: Point Name, X, Y. Dan Foster shows how to create a preset column layout in the ExpertGPS waypoint list so that Peter can just copy and paste his data into Excel in [...]

  
  

  December 15th, 2008

• Making a map of GPS data from MS Excel

  

  Otis C. asks: “I have an MS Excel document with multiple Lat/Long points listed in one column, but individual rows. Would I be able to import this info into your product and have it plot it point by point on a map, which has street level definition?”

  
  

  December 5th, 2008

• Mapping public hunting areas and walk-ins using free GIS data and ExpertGPS Pro

  

  Kevin is trying to map all of the public and walk-in hunting locations in South Dakota, and wants to be able to send the hunting area boundaries to his Lowrance XOG GPS receiver. Here’s how to create a GPS map of public hunting areas using ExpertGPS Pro…

  
  

  December 5th, 2008

• Recommended Web sites with GPS trails in GPX format

  

  Michael B. from Washington asks: “I’m interested in using my GPS for hiking and I found the Backpacker.com web-site has hikes with trail routes that I can export to ExpertGPS. I was hoping that there were other such sites you can recommend that have a more complete list of hikes/maps.”

  
  

  November 14th, 2008