how do i make a csv if i have all the long and lat in a list
A csv is just a comma delimited text file.
If your list is in a text format with "longitue, lattitude, name 1, and name 2" (e.g. "-105.000, 40.000, Denver coordinate, located in north suburb"), then you can just rename the text file with a .csv extension.
I prefer to make a list in MS Excel, and "save as" a .csv file.
Here is everything you need.
im really lost i got a list of long and lads in a txt format and i want to make it into a csv but im not sure how. I dont understand all the vaules and stuff in the blocks and what about commas
Take a deep breath. This is really simple.
CSV stands for Comma Seperated Values.
So for my Magellan, a CSV file entry looks like this:
That's it, you just need to put a comma between each of the fields in your text file. If there is no altitude, there would be two commas in that position:
WalMart #74,123.45,88.66,,95 W. State Chicago IL
(The placement of fields may be different on your machine.) And note that the actual data fields can NOT have any commas.
Download a file here on site, open it and see how others did it. This is the best way. See examples of others and replicate them.
I tried that but when i upload it to garmin it says invaild format
Try a different file.
But here's the format for Garmin units.
Open your text file using Notepad. Immediately, use the File > Save As ... command to save it as a CSV. Just type the name you want in the box followed by .csv.
Then place a comma between the longitude and latitude. Place one between the latitude and the name. And place one between the name and the comment, if you have one in the file. Note that if the comment field contains an address or something else that has commas in it, place quotation marks around it.
For example ...
117.77777,42.54445,John's House,third house on the right
117.43234,45.22300,Mary's House,"1234 Main Street, Anytown, USA"
Don't have more than four columns. Be sure the longitude is in the first column.
If one wanted to make a POI file, where does one get the "longitude and latitude" information?
Do I have to drive to all of the locations?
There are number of sites that give longitude and lattitude of any given location, and we've had many discussions as to which one is the best.
I've used http://geocoder.us/, http://www.poieditor.com/, http://www.batchgeocode.com/, and Google Earth (http://earth.google.com/) with varying degree of accuracy. I haven't used MapSource, so someone please fill me in on this one.
Another Geocoding site (in addition to Spider's sites):
From this site, how to create/edit POI files:
Specifically, about formatting CSV files:
Using the search window above will give you all the information you want, and then some. As someone else mentioned, this question and most others have been asked and answered over and over again. It would really be benificial if more would use the search window. Thanks.
I'm new here so it will take a bit to figure out how to use everything available to me. It's not like most boards I belong too.
terms | privacy | contactCopyright © 2006 - 2014