Only partial import from CSV to spreadsheet

andesan shared this problem 6 years ago
Answered

    "Navn","Aktivitetstype","Beskrivelse"

    "2015-10-12 08:52","sykling",""


    "Segment","Punkt","Breddegrad (grader)","Lengdegrad (grader)","Høyde (m)","Kurs (grader)","Nøyaktighet (m)","Hastighet (m/s)","Tid","Styrke (W)","Takt (rpm)","Puls (bpm)"

    "1","1","63.402554","10.326991","254.0","","10","0","2015-10-12T06:52:13.915Z","","",""

    "1","2","63.402498","10.326884","252.0","231.0","3.9","0.6676","2015-10-12T06:53:02.069Z","","",""

    "1","3","63.402473","10.326787","252.0","231.0","3.9","0.5501","2015-10-12T06:53:07.110Z","","",""

    "1","4","63.402473","10.326777","255.0","","4","0","2015-10-12T06:54:03.114Z","","",""

    "1","5","63.402474","10.326778","255.0","351.0","4","0.2214","2015-10-12T06:54:04.094Z","","",""

    "1","6","63.402474","10.326778","255.0","351.0","4","0.2214","2015-10-12T06:54:04.217Z","","",""

    "1","7","63.40248","10.326775","254.0","332.0","3.9","0.4052","2015-10-12T06:54:05.099Z","","",""

    "1","8","63.40248","10.326775","254.0","332.0","3.9","0.4052","2015-10-12T06:54:05.203Z","","",""

    "1","9","63.402478","10.326737","258.0","","3.9","0.11","2015-10-12T06:54:06.071Z","","",""

https://ggbm.at/1811247

Comments (5)

photo
1

My problem is that only the first 4 colums of the data set are imported to GeoGebra.

photo
1

I was able to duplicate your 4-columns by pasting the entire CSV code; however, if you paste the two title lines separately from the body lines it works.


I do not know if this is a "bug" or just the way one must paste into GeoGebra, but it works...d07d7dc06e1b1eca42745f0006d0c27aTony

photo
1

Thank you!

This solves my problem as I can copy and paste without the first few lines.


I first tried to import the CSV data by rigth-clicking and importing from file. This does not work as expected.

photo
1

Thanks, fixed for next release

photo
1

5.0.161.0 online now!

© 2022 International GeoGebra Institute