Tags Spreadsheet, Import data, Excel
Due On 2019-05-05
Pasting data from Excel to Spreadsheet
OLDen shared this question 4 years ago
When I copy data from Excel and paste the data to the spreadsheet I experience differences.
When I copy one column in the Excel sheet the data is pastet to two columns in Geogebra when there is a , in the data.
In Denmark we use , as decimalseparator.
When I copy two columns in the Excel sheet the data is pastet correctly in to two columns in Geogebra.
Can you explain this difference?
Files: Galton.xlsx DataPastetFromT...
- Feedback & Questions
- +43 677 6137 2693
GeoGebra uses the dot . as decimal separator, and the comma , as field separator.
You need to check if your data file matches these settings before importing.
> When I copy two columns in the Excel sheet the data is pasted correctly in to two columns in GeoGebra.
Probably in that case Excel is putting the data on the clipboard correctly, ie something like
If it's like this then 2 columns are assumed as Simona says
do a copy of file
then open it
select file options
then select . and , instead , .
then you can copy from excel to GG
reset the options
Comments have been locked on this page!