Notices
Marine Electronics Forum

converting .csv to .gpx help

Old 08-23-2017, 07:37 AM
  #1  
Senior Member
Thread Starter
 
Join Date: May 2012
Posts: 144
Likes: 0
Received 3 Likes on 3 Posts
Default converting .csv to .gpx help

Ok guys, last night I spent some time converting a bunch of my coordinates from excel spreadsheets to .gpx files to load onto the new NSS evo3. I got several files to convert over no problem using GPSBabel. On the last couple, I cannot get them to convert....it will convert the first line of the file and nothing else. I did them all the exact same way and have no idea whats going on. Anyone got any ideas?
Old 08-23-2017, 07:45 AM
  #2  
Senior Member
 
Join Date: May 2016
Posts: 259
Likes: 0
Received 33 Likes on 17 Posts
Default

can you give us an example line of csv that converted and a sample of the one that didn't? I'm guessing there is a slight format error in the csv that is causing gpsbabel to buck, but that's just an extremely wild guess. Also make sure the csv file is using the .csv extension and not a .txt extension.
Old 08-23-2017, 08:34 AM
  #3  
Senior Member
Thread Starter
 
Join Date: May 2012
Posts: 144
Likes: 0
Received 3 Likes on 3 Posts
Default

its a simple lat, long, name format. The ones that will not convert seems like the software is not recognizing an "enter" command that normally drops the info down to the next row. Once saved as a .csv file, excel will open it and it looks fine... all three columns are there and all info is rowed up perfectly. However, if you open the file in Text editor all the info just runs together in a single row. Its almost like excel isnt putting a comma at the end of the name column to let the software know to start a new row.


Not sure if that makes any sense at all....Im a fish out of water when it comes to this stuff
Old 08-23-2017, 05:14 PM
  #4  
Admirals Club Admiral's Club Member
THT sponsor
 
Join Date: Aug 2011
Location: St. Petersburg, FL 33707
Posts: 2,110
Received 206 Likes on 132 Posts
Default

How many numbers do you have in the file? You need to convert the csv or gpx file to .usr.
Old 08-23-2017, 05:20 PM
  #5  
Senior Member
Thread Starter
 
Join Date: May 2012
Posts: 144
Likes: 0
Received 3 Likes on 3 Posts
Default

Simrad will read gpx...only got about 20 in this particular file. Some of the other successful ones had several hundred.
Old 08-23-2017, 05:32 PM
  #6  
Admirals Club Admiral's Club Member
 
Join Date: Feb 2011
Posts: 8,393
Received 1,372 Likes on 761 Posts
Default

There is a way to append a special character to the end of each cell in a column like line feed.

Is there by chance a comma in the name? Is the name field limited to a certain number of characters?

Have you tried deleting the first line and trying it?
Old 08-23-2017, 07:27 PM
  #7  
Senior Member
Thread Starter
 
Join Date: May 2012
Posts: 144
Likes: 0
Received 3 Likes on 3 Posts
Default

Yeah I looked for a way to add comma to every block but couldn't figure it out. I'll try to delete first line and try again. No commas in the name and names are pretty short
Old 08-24-2017, 08:31 AM
  #8  
Admirals Club Admiral's Club Member
 
Join Date: Feb 2011
Posts: 8,393
Received 1,372 Likes on 761 Posts
Default

https://www.extendoffice.com/documen...d-of-cell.html
Old 08-24-2017, 09:31 AM
  #9  
Admirals Club Admiral's Club Member
 
Join Date: Jul 2016
Location: Bradenton, FL
Posts: 309
Received 28 Likes on 21 Posts
Default

Purchase the Andren 'SeaMarks' program.
Old 08-24-2017, 11:25 AM
  #10  
Senior Member
 
Join Date: Jun 2003
Location: Palm Harbor, FL
Posts: 2,065
Received 443 Likes on 234 Posts
Default

Try saving the Excel file as .csv, opening it in your Text editor, hit "enter" to manually break each row onto a new line. If it's only 20 rows or so it won't take long.
Old 08-24-2017, 11:27 AM
  #11  
Senior Member
 
Join Date: Jun 2003
Location: Palm Harbor, FL
Posts: 2,065
Received 443 Likes on 234 Posts
Default

You could also try running your file through this:
http://www.fileformat.info/convert/text/unix2dos.tr
Old 06-24-2018, 04:50 AM
  #12  
Junior Member
 
Join Date: Jun 2018
Posts: 1
Likes: 0
Received 0 Likes on 0 Posts
Default

Hello everyone! I am brand new to things here so please bear with me on this. My friend has a CSV file with several hundred coordinates as a .csv file. It has names, descriptions, and I would assume coordinates on it that he would like me to get onto an SD to put in his Simrad GO 7xse. Is there a good way of doing all of this with out manually typing in everything or having to copy and paste every single coordinate? Here is a sample line for the Excel spreadsheet that I have it on.

"266 AR-398 Crushed Concrete 3848 ""Crushed Concrete: Herber G. """"Buddy"""" Phillips NC 17 Bridge Rubble"" 77° 22.564' W 34° 39.553' N 11/1/2010 0.088339749"

Any help or links would be greatly appreciated. Thank you!
Old 06-24-2018, 04:34 PM
  #13  
Senior Member
Thread Starter
 
Join Date: May 2012
Posts: 144
Likes: 0
Received 3 Likes on 3 Posts
Default

Csv can be opened in excel. Make sure long coordinates are denoted as W or - . You can have 4 fields...lat long name and description. Resave as csv file and then use gpsvisualizer.com to convert to a gpx file
Old 06-24-2018, 05:31 PM
  #14  
Senior Member
 
Join Date: Aug 2016
Location: Kalbarri, WA
Posts: 835
Received 353 Likes on 194 Posts
Default

You can also use GPS Utility for this, GPSU is a very powerful tool that will handle anything. Freeware version has a constraint on the size of file you can load, not sure what it is. Free download, give it a try. One common problem I see repeating is the character numbers in the name, if any. It may convert OK, but the machine it is loaded into will not recognise it, due to this constraint. Some people get awfully long-winded in their descriptions.
I have just been through a process of breaking up a file of almost 29,000 marks from my commercial fishing days, into useable blocks of less than 10,000 each, to fit in my Axiom.The filtering tool in GPSU proved invaluable, as getting them into blocks where you can be sure of staying within that block on any given day's fishing, isn't as easy as it sounds. I didn't want to be having to re-load at sea, just for conveniences sake.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information -

Copyright © 2021 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.