Confused on downloads

 

Hello all:

I have a Garmin 200W nuvi. When I try to download some POI files, it trys to save some of them as .xls files even though the download screen says it's a .csv file.

Of course the garmin won't read the .xls as a POI file.

What am I doing wrong?

Thanks,

David

They should be all csv

They should be all csv files. but it is easy enough to open it up and do a "save as" and select comma delimited.

--
Charley - Nuvi 350 - Bel STI Driver - Cobra 29 w/ wilson 1000 - AIM: asianfire -

I tried that, but it said i

I tried that, but it said i had a corrupted .csv file, but I'll try it again. Thanks for the reply

.

You should be able to just rename the file (without opening it in any program). And just change the extension. Are you sure it was xls and not xml? Doesn't really matter. But try changing the file extension and see what happens.

CSV Files

MS Excel by default will associate/open CSV files on PCs with MS Office installed. CSV files are plain text files whose fields are separated by commas, thus called Comma Separated Values. You can open the CSV files with a plain text editor such as notepad. If opened with Excel then saved, it will tell you that you will lose the formatting of the file. Since it is a text file, you don't really care about the formatting.
Try opening the POI file that you downloaded with notepad. POI file will be in the format:
Longtitude,Latitude,Name

--
nuvi 2460LMT

I don't think that will work

Motorcycle Mama wrote:

You should be able to just rename the file (without opening it in any program). And just change the extension. Are you sure it was xls and not xml? Doesn't really matter. But try changing the file extension and see what happens.

if a file is truely a xls file, you can't simply name it a csv and have it work right. xls is not a comma delimited format and that is what garmin is looking for.

--
Charley - Nuvi 350 - Bel STI Driver - Cobra 29 w/ wilson 1000 - AIM: asianfire -

POIConverter

Try POICONVERTER at this web site,

http://tinyurl.com/ykgbvp

.

asianfire wrote:

if a file is truely a xls file, you can't simply name it a csv and have it work right. xls is not a comma delimited format and that is what garmin is looking for.

Yes, you are absolutely, 100% correct. That's why I asked if it was really an xls file because I didn't think that there were any xls files on the site. And some people have reported that their downloaded get saved as a xml due to a browser issue. And renaming the file worked for them.

Otherwise, I would recommend downloading the file again.

Ah, I gottcha! My bad.

Ah, I gottcha! My bad. Yes, you can rename the xml file.

--
Charley - Nuvi 350 - Bel STI Driver - Cobra 29 w/ wilson 1000 - AIM: asianfire -

Choose SAVE

On some computers, you're given a choice to OPEN or SAVE when you click on a download link. It's best to choose SAVE.

Choosing SAVE puts the file into a folder without opening Excel.

If you open a file with Excel and are not careful, it's easy to end up converting the file to Excel format.

JM