how do i make a csv
Thu, 12/27/2007 - 9:20pm
16 years
|
how do i make a csv if i have all the long and lat in a list
16 years
|
how do i make a csv if i have all the long and lat in a list
.csv
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.
nüvi 750 & 760
CSV's
how do i make a csv if i have all the long and lat in a list
Here is everything you need.
http://www.poi-factory.com/node/6664
******************Garmin Nüvi 1300T****************Member 6523*******************
im really lost i got a list
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
CSV files
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:
Name,latitude,longitude,altitude,description
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.
Magellan Maestro 4250// MIO C310X
best way
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
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.
******************Garmin Nüvi 1300T****************Member 6523*******************
i tried
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.
longitude,latitude,name,comment [optional]
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
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?
Lon/Lat
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.
nüvi 750 & 760
Here are some helpful links for you...
Another Geocoding site (in addition to Spider's sites):
http://stevemorse.org/jcal/latlon.php
From this site, how to create/edit POI files:
http://www.poi-factory.com/node/6664
Specifically, about formatting CSV files:
http://www.poi-factory.com/garmin-csv-file-format
Search window
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.
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
Thanks guys! I'm new here so
Thanks guys!
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.