HomeGarmin


Convert Microsoft Excel to Garmin Mapsource
loomis71
Hi. I have a file in Microsoft Excel and I want to convert it so I can put it in Garmin Mapsource. Is this possible?

mvh peter
Ken in Regina
Hi Peter,

What kind of data is in the Excel file? Without knowing that, it's impossible to say if it can be converted.

The simple answer is that there are conversion programs and web sites out there that can convert between a large variety of formats. It all depends on what data you want to convert.

...ken...
loomis71
sorry it´s xls file
Ken in Regina
Yes, I know that Excel makes .xls files. We need to know what kind of data is actually in the file. Is it addresses? Is it waypoints with latitude and longitude coordinates? Is it Points of Interest?

Exactly what is in each column?

...ken...
loomis71
Yes, it's waypoints, and the line look as this:
Code:
580780 11166235 Måseskär
loomis71
or you have the line look like this
Latitud: 58 01,263 Longitud: 11 14,951

and if i can look in lowrance waypoint file
Ken in Regina
You might need to use Excel to save your file as a .CSV file before doing the conversion.

Here is one possible solution. It seems to be a popular one.

http://www.poiedit.com/

Here is another:

http://download.cnet.com/G7ToWin/3000-12940_4-10676231.html

And another:

http://sites.google.com/site/lschwabe/

And another:

http://geepeeex.googlepages.com/

I hope one of them will work for you.

...ken...
loomis71
thanks i try
rudd1982
Hello I also have a similar problem.

I have coordinates in ArcGIS which were created as point data. They are projected by British National Grid. I have managed to get them into an Excel file. But, I now want to get them into Mapsource so I can upload them to my Garmin GPS. But, I can't seem to manage it. Can anyone help me please? I have been trying to use gabel.
Ken in Regina
You could try saving the worksheet as an XML file, then rename the file to be a .GPX file (just a particular type of XML) and see if Mapsource will accept it. It only takes a minute to try and it can't hurt anything.

...ken...
rudd1982
Hi Ken. I tried that, but when I tried to save it as XML, it said it did not contain any XMP mapping. :-( any other ideas?
Ken in Regina
save as CSV. Convrt 2 GPX w/gpsbabel. Chk for correct colmn ordr.
rudd1982
That's what I have been doing. Convert to CSV. Maybe I'm using the wrong CSV type within the Gpsbabel as there is a couple. What do you mean with regards to the column.

I'm using British National Grid, which might make it tricker to work with? No GSW 84 etc, but could convert.
rudd1982
I have also tried it another way. To create a shape layer out of my Excel file. Give it British National Grid as its source, but convert it to WSG 84. Then load it into DNR. Then, upload it to my Garmin device. Which it does, but the coordinates are always out, sometimes as far as the other side of the world. Ie I'm UK, and they're near South America. Hmm...
Ken in Regina
When using GPS Babel to convert files you need the columns to be in the correct order in Excel before you save the CSV file. You need the latitude and longitude coordinates to actually be latitude and longitude coordinates. I'm not familiar with the British National Grid so I don't know how GPS Babel will handle them.

You have not told us enough about the details of what you have tried and the results to do any more than offer these general suggestions.

1. What columns do you have in the Excel file?

2. What order are the columns in from left to right?

3. Are there Latitude and Longitude columns?

4. Is the first row in the spreadsheet a row with the titles in it?

5. After you create the CSV file, if you look at it in a text editor do you see everything looking as it should? E.g. the first line should contain the titles separated by commas. Each subsequent line should have the data as they were in each row with the data that was in each column separated by commas.

6. What happens when you try to convert the file to a GPX file in GPS Babel? Does it produce a GPX file for you?

7. If GPS Babel produces a file for you, what happens when you try to load it into Mapsource?

...ken...
© laptopgpsworld.com About