[BaseCamp] from Excel xls to BaseCamp waypoint gpx

[saddle sore]

Lynne

I've never played with a KML.  So when I googled it, I found
https://www.earthpoint.us/ExcelToKml.aspx.  I browsed for the same Excel
file as I used in GPSVisualizer.  It placed all my sites on Google Earth
(but since I had over 200 sites in my Excel file it wanted paid for
anything over 200 lines from an Excel file).  But I clicked on a few sites
and selected Properties to see what info it was storing from my Excel file.
Admittedly this is my first try at converting xls to kml then to gpx, but
my attempt did not bring over anything from the Excel file other than name,
longitude and latitude.  I'll try some other iterations and see if I get
other/better results.

Thanks, Joe





On Sun, Mar 22, 2015 at 8:25 PM, Lynne Carey <gijane42104 at gmail.com> wrote:

> I believe you can import the KML file into basecamp and it brings that with
> it doesn't it?  I seem to remember playing with it last year.  I then
> exported as GPX file
>
> On Sun, Mar 22, 2015 at 7:00 PM, saddle sore <ironbutter at gmail.com> wrote:
>
> > Maura
> >
> > I have City location info already filling the Notes portion of the BC
> > waypoint.  I've been playng with column names in the Excel file prior to
> > running GPSV, as well as shifting what is in the Excel columns so that
> GPSV
> > sees the info at different times in the conversion process.  I was hoping
> > to match the Excel columns with the BC columns, but haven't figured that
> > out yet.  The ordering of the columns in Excel does not seem to make
> > much/any difference in the way it comes out in BaseCamp.  Thus, I haven't
> > been able to get the columns aligned (yet).
> >
> > BTW, when sorting waypoints in BC for an entire List of waypoints, why
> are
> > the columns not the same as when opening BC waypoint properties box for a
> > single waypoint?  For a List, there is a column for Notes right after the
> > column for waypoint name, but for an individual waypoint properties box
> the
> > Notes is a tab rather than a line item category.  Not a big issue, just
> > noticed it.
> >
> > Joe
> >
> >
> >
> > On Sun, Mar 22, 2015 at 7:38 PM, -=maura=- <moteramaura at gmail.com>
> wrote:
> >
> > > Put the state in the NOTES column. Put the state alone, or first,
> before
> > > any other info.
> > > You must match the columns in BaseCamp and Excel- BC has limited and
> > > specific columns, you must have those columns in excel for GPSV
> convert
> > >
> > > Give this a try,
> > > I have not done it and am unable to test at the moment.
> > >
> > > Maura
> > >
> > >
> > >  On 22/03/2015 4:23 PM, saddle sore wrote:
> > >
> > >> Hi
> > >>
> > >> I'm getting ready for 2015 Tour of Honor.  I want to make a gpx file
> of
> > >> the
> > >> 2015 info when it is all posted on April 1st, so I'm practicing with
> the
> > >> 2014 data.  I did a lot of cutting and pasting from the 2014 map to
> make
> > >> an
> > >> Excel spreadsheet containing columns of:  memorial name, city, state,
> > lat,
> > >> long.
> > >>
> > >> I initiated GPSVisualizer for the conversion from xls to gpx.  I read
> > >> through the tutorial at
> > >> http://www.gpsvisualizer.com/tutorials/waypoints.html and figured out
> > >> some
> > >> of the column names MUST be specific names.  Then I used the
> conversion
> > >> box
> > >> on http://www.gpsvisualizer.com/convert_input?convert_format=gpx to
> > have
> > >> GPSVisualizer create a gpx file that I could download and then open in
> > >> BaseCamp.
> > >>
> > >> I want to be able to be in BaseCamp and sort the waypoints by state.
> I
> > >> have one Excel column for State, and BaseCamp waypoint properties box
> > has
> > >> a
> > >> place for State, but when converting to gpx from xls using
> > GPSVisualizer,
> > >> that State information is not coming over.  All I get from
> GPSVisualizer
> > >> is
> > >> name, desc, lat, and long.
> > >>
> > >> Does anyone have any hints on how I get the State information to be
> > >> converted from the Excel file to the BaseCamp waypoint properties box?
> > >>  (I
> > >> realize that after the BaseCamp waypoints are created that I can
> > highlight
> > >> certain waypoints and give them all the same State abbreviations
> > manually.
> > >> But since I already have this in the Excel file along with the lat,
> long
> > >> and name, I'm thinking that the conversion process should include the
> > >> State
> > >> info, not just name, lat and long.  The GPSVisualizer conversion
> process
> > >> places the City info into the BaseCamp waypoints' Notes properties
> line
> > >> since I have the Excel column header as Desc.  Why can't I pick up the
> > >> State from Excel and have that show up in the BaseCamp waypoint
> > >> properties?
> > >> )  Any ideas?  Any better ways than using GPSVisualizer?
> > >>
> > >> Thanks, Joe Y
> > >> western PA
> > >>
> > >> To make _ANY_ changes, including unsubscribing from this list, click
> > >> ----->http://micapeak.com/mailman/listinfo/basecamp
> > >>
> > >>
> > >>
> > >
> > > To make _ANY_ changes, including unsubscribing from this list, click
> > ----->
> > > http://micapeak.com/mailman/listinfo/basecamp
> > >
> > >
> >
> > To make _ANY_ changes, including unsubscribing from this list, click
> ----->
> > http://micapeak.com/mailman/listinfo/basecamp
> >
> >
>
> To make _ANY_ changes, including unsubscribing from this list, click ----->
> http://micapeak.com/mailman/listinfo/basecamp
>
>