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
Announcement
Collapse
No announcement yet.
Exporting shot data - CSV to Exel
Collapse
X
-
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.
-
Well there you go that worked perfectly! Thanks!
-
Comment