Category Archives: Converting CSV

Using ExpertGPS as a CSV Converter.

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

Posted on July 22, 2009 by Dan Foster

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 … Continue reading →

Posted in Converting CSV, Fishing & Boating, Lowrance | Tagged , , , , , , , , | Comments Off

Converting Marine Chartplotter CSV Data to GPX

Posted on July 9, 2009 by Dan Foster

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 … Continue reading →

Posted in Converting CSV, Converting Data Formats | Tagged , , | Comments Off

Determining the correct coordinate format for X,Y data

Posted on July 8, 2009 by Dan Foster

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.

Posted in Converting CSV, Coordinate Conversion, Mapping Tips and Tricks, State Plane Coordinates | Tagged , , | Comments Off

How to Transfer GPS Data to and from an Excel Spreadsheet

Posted on May 29, 2009 by Dan Foster

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 … Continue reading →

Posted in Converting CSV, Converting Data Formats | Tagged , , , , , | Comments Off

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

Posted on May 28, 2009 by Dan Foster

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 … Continue reading →

Posted in Converting CSV, Geocoding Addresses, Mapping Property, Real Estate and Property Mgmt | Tagged , , | Comments Off

Convert GPS Tracks into Excel Spreadsheets or CSV

Posted on May 28, 2009 by Dan Foster

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. … Continue reading →

Posted in Converting CSV, Converting Data Formats | Tagged , , , , | Comments Off

Converting CSV Data to KML and SHP using Excel and ExpertGPS

Posted on April 3, 2009 by Dan Foster

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 … Continue reading →

Posted in Converting CSV, Converting Data Formats, Converting KML, Converting SHP, GIS | Tagged , , , , | Comments Off

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

Posted on March 2, 2009 by Dan Foster

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.

Posted in Converting CSV, Converting Data Formats, Coordinate Conversion, State Plane Coordinates | Comments Off

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

Posted on December 15, 2008 by Dan Foster

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 … Continue reading →

Posted in Converting CSV, Converting Data Formats, Mapping your Data | Tagged , , | 2 Comments

Making a map of GPS data from MS Excel

Posted on December 5, 2008 by Dan Foster

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 … Continue reading →

Posted in Converting CSV, Converting Data Formats, Mapping your Data | Tagged , , | Comments Off