Garmin Xero chrony

[Muddydogs]

Is there an easy way to export data from the Xero to the computer / Excel. I've used the export to CVS but the resulting Excel file needs a lot of work to separate the data strings from one cell to multiple cells. I'm thinking there has to be an easier way?

 

[alfsauve]

CVS or did you mean CSV?

If the latter then Excel should ask you if you’d like to separate the data into columns based on a comma.

 

[Laphroaig]

Is there an easy way to export data from the Xero to the computer / Excel. I've used the export to CVS but the resulting Excel file needs a lot of work to separate the data strings from one cell to multiple cells. I'm thinking there has to be an easier way?

I know what you are saying. When I exported sessions to a CSV file it did separate into columns in Excel, but even then it would take a fair amount of editing and reformatting to get it into anything useful. When I first got mine I had these plans to create a big database on my laptop. Once I saw the format of what was imported I started asking myself if is worth the trouble.

My unit is now overwriting sessions but the phone app has saved everything that I have done, so I can refer to past sessions when desired. For now that's good enough for me.

 

[DustyRusty]

The phone app export to CSV takes the clunky 4 button chronograph into the WINDOWS environment.
I've been asking my son who works with EXCEL all day to make me a "Macro" to automate all that manipulation required.
If he ever comes thru for me, I'll pass it along.

 

[Soonerpesek]

The phone app export to CSV takes the clunky 4 button chronograph into the WINDOWS environment.
I've been asking my son who works with EXCEL all day to make me a "Macro" to automate all that manipulation required.
If he ever comes thru for me, I'll pass it along.

Much appreciated…….in advance…

 

[Varminterror]

Mine exports .CSV with column separations. A simple macro for copy & paste, with use destination format or paste only values is easy enough if you don’t want to expand columns once exported.

 

[DustyRusty]

Garmin CSV files.:
I started looking at help articles about "squished Excel screens."
One comment helped a little.

I start with my CSV imported Excel file looking like this.


Click on any empty cell to ensure the sheet is selected.
On the keyboard do a (Ctrl) + A to select ALL the cells
All the cells will turn gray like indicating your next action will apply to all.
If you have additional sheets at the bottom of your Excel window like mine, click on them as well.



Grab the right side of B column thusly, and drag it right a couple columns width
to the right and release.


ALL the columns will open up like this


Click here to center the text in the columns


Experiment by grabbing the "A" column instead of "B" or "C" etc.
If I find better information, I'll pass it along.

 

[MEHavey]

We start with the sheet looking like this

Yikes !
What were you shooting with numbers like that ?
(Inquiring minds want to know )

 

[DustyRusty]

If you have tabs down at the bottom, click them while holding the (Ctrl) key.
The changes will apply to them

 

[DustyRusty]

Yikes !
What were shooting with numbers like that ?
(Inquiring minds want to know

PM me.

 

[Walkalong]

Slingshot............

 

[DustyRusty]

The subject matter of my post was manipulating the spreadsheet.
Thanks for pointing that out though.
I don't want confusion in the record.

I have edited the OP to use meaningful data.