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.
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.
When you have filled out the first page of the Text Import Wizard correctly, click Next to proceed to step 2.
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.
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.
Here are some in-depth tutorials that will walk you through the CSV import process in ExpertGPS:
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.