HomeMicrosoft


Unable to import CSV files to Microsoft Streets and Trips
on the road again
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
Marvin Hlavac
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
Ken in Regina
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...
on the road again
Quote:
Originally Posted by Ken in Regina
Linda, I'm confused. You said you are trying to import a CSV file but then you said you downloaded a Garmin fille
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
on the road again
Quote:
Originally Posted by Ken in Regina
Or maybe just try using the Data > Import GPX file to import the file and see if that works for you.
...ken...
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
Marvin Hlavac
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.
SpadesFlush
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.
SpadesFlush
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.
phays
You can download a rest area file for S&T from http://www.discoveryowners.com/cginfolinks.htm
on the road again
Thanks everyone ... will download the file from Discover....
Larry
Hi All,

DiscoveryOwners has just recently updated their CGinfolinks website.
There is now a new version available which is much easier to use.

See Discovery Owners Free Overlay POI Website Gets A Makeover
laptopgpsworld.com About