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?
They should be all csv files. but it is easy enough to open it up and do a "save as" and select comma delimited.
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.
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:
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.
Try POICONVERTER at this web site,
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. Yes, you can rename the xml file.
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.
terms | privacy | contactCopyright © 2006-2020