I am on the POI.com site and am trying to download a combined reststop file which is in CSV format. It will not open when I attempt to put it onto my template using the Import Data Wizard ... does Microsoft Streets and Trips not accept csv files or am I doing something wrong? It gave a choice for download using a Garmin and some other so I chose Garmin ...is this a totally wrong thing for me to do

Thanks for any help ... I love these POI files; what a time saver. Kudos to all those hardworking contributors.

Linda

Hi Linda. What are the other formats beside Garmin? Perhaps give a try to those. It should work.

P.S. The following POI file may be of interest to you: http://www.laptopgpsworld.com/2595-poi-mega-file-pushpin-collections-truckers-rvers-other-travelers

Linda, I'm confused. You said you are trying to import a CSV file but then you said you downloaded a Garmin file.

Garmin downloads are normally GPX files. They are not normally CSV files (because Garmin programs don't know how to use them).

Can you see the file extension on that file to be sure that it's a .csv file and not a .gpx file? (eg. filename.csv or filename.gpx)

Or maybe just try using the Data > Import GPX file to import the file and see if that works for you.

...ken...

Hi Ken
I am also confused. The download on POI had two download buttons .. one for 'Garmin' and one for 'Tomtom'. In a line below the buttons info. was supplied that named the raw file witch had a csv extension. I downloaded it by selecting the Garmin button thinking that because it was a csv it would be able to be imported into S&T. It wouldn't. I guess it was strictly for those particular GPS devices.
Thanks
Linda

It is definitely a csv file but S&T has problem opening it. Just scrutinized it and the file extension has a period after it .csv. I am thinking it is a file fault now.
How do I import a GPX file .. I have ver. 9 and i have data-import data wizard and I don't see a GPX option?

Linda

Linda, try to remove the last dot from the file name. Right-click the file name somename.csv. and then name it just somename.csv by removing the second dot.

P.S. Version 2009 is not able to import .gpx. Import/Export GPX is a brand new feature introduced in Streets and Trips 2010.

Linda, try opening the .csv file in Excel (or Open Office). That will give you a spreadsheet of data. Note what 'Sheet' the data is on (tabs at the bottom), probably 'Sheet1'. Then, save that as an .XLS (standard spreadsheet extension) and close Excel. CSV files are not an Import file option.

Now, go to Import Data Wizard (not Import GPX File) and select your newly-created .xls file. It will prompt you for which sheet as per above, again probably 'Sheet1'. Then follow the steps taking care to assure that the column headings (especially latitude and longitude) are appropriately named and you should wind up with a mess of Pushpins.

As none of this is GPX, stay away from that function.

I take that back! I now see that CSV is an import option; I just never used it, sorry.

Therefore, I conclude that something is wrong with your CSV file. It should not have a period after it. Can you re-download the CSV file so that it does not have the trailiing period? Or try another download altogether.

You can download a rest area file for S&T from http://www.discoveryowners.com/cginfolinks.htm

Thanks everyone ... will download the file from Discover....