Import Text Command
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.
Step 1: Choose Text Delimiter and Coordinate Format
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
In the second step of the Import Text Wizard, you specify which columns of data from your text file (bottom table) correspond to data fields in ExpertGPS (top table). Click on a column in the top table, click on the corresponding column in the bottom table, and click the Apply button.
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 columns, click Next to proceed to Step 3.
Step 3: Save These Settings
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 the
To complete the Import Text Wizard and import your text data, click Finish.
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 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.
Find your GPS on the ExpertGPS compatibility list.