How do I upload results via excel with one competitor per line?

Question

I made an attempt to upload the results but probably my Excel file is not suitable. All results per child are on 1 line as required. I have also already put all categories in the file under each other. How can I import this file?

cat	Name	geb dd	Clubs	40mH*	far	high	vortex	balst	Make
MpM	Diva Epker	2009	AAV'36	9.46	2.45	0.80	14.50	3.40	800
MpM	Indy van Tol	2009	AAV'36	8.70	2.40	0.85	11.00	3.20	900
JpM	Fosse de Rijk	2009	AAV'36	10.87	2.20	0.70	9.00	4.10	700
JpM	Jayden Vondeling	2009	AAV'36	10.08	2.35	0.75	9.50	2.80	750

This has been automatically translated into English

Answer 1

A very good question and great example. We provide full support for this common format. From the column names, the events are recognized. However, you must indicate in which columns the events are. This is done with "Events from/to this column". 

Added is an image of how to set the columns in this case 

Please note that all lines between "Events from this column" and "Events to this column" must be set to "Not available". 

See also the answer to How can I register athletes on single events via import

.

This has been automatically translated into English