'Converting CSV' Category

• Here’s How to Transfer Excel Fishing Waypoints to a Lowrance GPS in USR Format

  

  Ben C. needs help converting offshore and deep-sea fishing spots from an Excel spreadsheet into GPS coordinates he can convert to a .USR data file for his Lowrance GPS. Here’s how to import, map, and download the Excel data to his GPS using ExpertGPS.

  
  

  July 22nd, 2009

• Converting Marine Chartplotter CSV Data to GPX

  

  Andrew H. asks: “I have track files acquired as CSV data via some custom software interfacing with a marine chart plotter that I would like to easily convert to gpx format. The important thing is I want to capture position and time, plus depth if possible, in the conversion, as I am using time code [...]

  
  

  July 9th, 2009

• Determining the correct coordinate format for X,Y data

  

  Sometimes you’re given a set of X,Y or Easting,Northing data in an unknown coordinate format. Here are some tricks to make it easier to determine the correct coordinate format using ExpertGPS.

  
  

  July 8th, 2009

• How to Transfer GPS Data to and from an Excel Spreadsheet

  

  Jordan Z. asks: “The description says that Excel data can be uploaded to a GPS. Does that go the other way too? I’m mostly interested in buying a GPS and being able to export waypoints to my computer for use in Excel.”

  
  

  May 29th, 2009

• 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

• 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

• 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