Announcement

Collapse
No announcement yet.

Exporting shot data - CSV to Exel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Exporting shot data - CSV to Exel

    Hey Guys, I'm looking to export my shot date into exel, but it has export to CSV... Could someone tell me how I could make exel read this format? thanks

  • #2
    Here you go: https://support.office.com/en-us/art...b-339e391393ba

    Comment


    • #3
      Huh... Pretty Cool. Learned something new today. Time to go home... Thanks for the tip.

      Comment


      • Stingreye
        Stingreye commented
        Editing a comment
        Here is the method I use:

        If you just double click the csv, it will open in excel (usually).
        1) Then click the data tab on the top,
        2) look for a button called "text to columns", click it
        3) Select delimited, hit next
        4) uncheck everything except "semicolon"
        5) Look in the preview, it should look like it separated the data
        6) Hit next
        7) Hit finish


        The bummer is that there is no carry number in the data. When I tried to look up formulas to try to calculate it, my head exploded and I gave up.

      • Wyzyguy
        Wyzyguy commented
        Editing a comment
        That is how I did it as well.

      • Cklguy2013
        Cklguy2013 commented
        Editing a comment
        Well there you go that worked perfectly! Thanks!
    Working...
    X