new & interesting places for your GPS

how do i make a csv

 

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

fish wrote:

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, StreetPilot c330 *******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

fish wrote:

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

fish wrote:

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. smile

--
********Garmin Nüvi 1300T, StreetPilot c330 *******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

KenLunde wrote:

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: Don't believe half 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.

sponsored links