Import Text Command (Import CSV or Copy/Paste from Excel)

CSV data successfully imported and displayed over an aerial photo map

The Import Text command allows you to import delimited text files (CSV, tab-delimited, etc) from a spreadsheet or other data collection program. Use the Import Text command to import waypoints and trackpoints stored in comma separated or tab-delimited formats into ExpertGPS. To use the Import Text command, either copy and paste delimited data from Excel or another program into the Waypoint or Track List, or click Import CSV on the Convert menu and select a .csv or .txt file.

Step 1: Choose Text Delimiter and Coordinate Format

Import Text Wizard - Step 1 of 3

In the first step, you choose the character used to separate columns of data (comma, tab, etc) and specify the type of coordinates used in the text file.

The list at the bottom of the dialog displays a preview of the text data, and will change to reflect the choices you make for the delimiter, header row, and coordinate format.

You may work with several standard data formats in the course of your job. Once you have defined the settings for a particular data format in the Text Import Wizard, you can save these settings (in Step 3). The next time you import one of these files, ExpertGPS will automatically recognize the file's header row and fill out the Text Import Wizard for you.

Select the character that separates columns of data in your file. ExpertGPS will analyze your CSV data and try to select the column delimiter automatically.
Has Header Row
If your data has the names of the columns at the top of the file, check Has Header Row. If this box is disabled, the Text Import Wizard has determined that your file does not have a header row.
Use these settings
If this text file uses the same layout as a file you previously imported, select the proper layout and the Text Import Wizard will use those settings to import this file.
Coordinate Format
Select or add the coordinate format used in this text file. If your data uses latitude and longitude, be sure to select the appropriate format (decimal degrees, degrees and minutes, or degrees, minutes, and seconds).
The coordinates are in
The Text Import Wizard can import coordinates in a number of standard forms. Select the one used in your file.

When you have filled out the first page of the Text Import Wizard correctly, click Next to proceed to step 2.

Step 2: Assign Columns

Import Text Wizard - Step 2 of 3

In the second step of the Import Text Wizard, you specify which columns of data from your text file correspond to data fields in ExpertGPS. At a minimum, you need to identify the columns in your text file that contain the coordinates (latitude and longitude, easting and northing, etc). Following the prompts at the top of the Wizard, Click on the column that contains the requested coordinate data.

If your text file has a header row, the Import Text Wizard will compare the names of your columns with the names of data fields in ExpertGPS, and assign matching columns automatically.

You must assign data to all of the coordinate columns (latitude and longitude, or easting and northing), but the remaining ExpertGPS columns (Label, Description, etc) are optional.

Once you have assigned data to all of the coordinate columns, ExpertGPS will attempt to parse your data into geographical coordinates, and will alert you (in red) if there are any issues with your CSV data. For example, if one of your Latitude columns contains the value 93.23, ExpertGPS will alert you that 93.23 is not a valid Latitude.

When you have finished assigning coordinate columns, you can assign additional columns by clicking on the data column, and then selecting an ExpertGPS data field to receive that data. When you are finished, click Next to proceed to Step 3.

Step 3: Save These Settings

Import Text Wizard - Step 3 of 3

In the final step of the Import Text Wizard, you can name the settings as a template for use the next time you import data in this format. ExpertGPS will remember the header row and the column selections you made in the first two steps. The next time you import data which uses the same header row, ExpertGPS will recognize your data and automatically apply the settings you've saved as a template. If you don't expect to import data in this CSV arrangement again, you can leave this blank.

To complete the Import Text Wizard and import your text data, click Finish.

Step-by-Step Tutorials on Importing CSV

Here are some in-depth tutorials that will walk you through the CSV import process in ExpertGPS:

Help with Importing Text

Because there are so many different formats for CSV and delimited text data, you may have trouble the first time you try to import data into ExpertGPS. If you receive an error message when importing text data, or your data is imported in the wrong location, or you need help importing your data, send an email to ExpertGPS support with your data file, the coordinate format it uses, and the address or town where the data should be located. I'd be happy to walk you through the process and help you with any questions you have.

ExpertGPS is mapping and file conversion software for your Garmin GPS
ExpertGPS is mapping and file conversion software for your Magellan GPS
ExpertGPS is mapping and file conversion software for your Lowrance GPS
ExpertGPS works with hundreds of GPS receivers, including all Garmin Drive, nüvi, eTrex, Colorado, Dakota, echoMAP, GPSMAP, Edge, Forerunner, Montana, Oregon, and Rino models, Magellan eXplorist, Meridian, and SporTrak GPS receivers, and Lowrance iFinder, HDS, Elite, HOOK, LCX, and LMS GPS chartplotters and fishfinders. Download ExpertGPS
Find your GPS on the ExpertGPS compatibility list.

© 1998-2021 TopoGrafix – 24 Kirkland Dr, Stow, MA – Email: – Fax Orders: (815) 346-5239