Import > Import Excel table

For importing an Excel table with species and header data the following steps should be taken in Excel:

1.	Copy or cut the header data

2.	Create or select an empty sheet

3.	In the Edit menu select Past special

4.	Select Transpose and click Ok

5.	In Turboveg select the option 'Import free format species data' and select the sheet the holds the species data. For next steps click here.

6.	For importing the header data select the option 'Import free format header data table' and select the sheet with header data.For next steps click here.

Excel table with header and species data

Table number		1	2	3	4	5	6	7	8	9	10
Releve number		101787	101788	101789	101790	101791	101792	101793	101794	101795	101796
Country code		CZ	CZ	CZ	CZ	CZ	CZ	CZ	CZ	CZ	CZ
Biblioreference		401824	401824	401824	401824	401824	401824	401824	401824	401824	401824
Year		1998	1998	1998	1998	1998	1998	1998	1998	1998	1998
Author code		0122	0122	0122	0122	0122	0122	0122	0122	0122	0122
Syntaxon code		35AC	35AC	35AC	35AC	35AC	35AC	35AC	35AC	35AC	35AC
RelevΘ area (m2)		104.00	173.00	334.00	259.00	98.00	158.00	143.00	69.00	196.00	79.00
Altitude (m)		1350	1350	1350	1350	1350	1350	1350	1350	1350	1350
Aspect (degrees)		135	135	135	135	135	135	135	135	135	135
Slope (degrees)		5	10	10	10	10	10	10	10	10	10
Cover total (%)		97	97	97	97	98	98	98	98	98	98
Cover tree layer (%)		0	0	20	0	0	0	0	0	0	0
Cover shrub layer (%)		95	93	90	89	90	90	90	97	95	90
Cover herb layer (%)		97	80	80	78	40	75	80	70	80	75

Anthoxanthum odoratum	hl	1	.	.	.	.	.	+	.	+	+
Avenella flexuosa	hl	3	2	2	2	2	2	3	2	3	3
Galium saxatile	hl	1	.	+	+	.	+	+	.	.	+
Homogyne alpina	hl	1	+	1	+	+	2	2	1	1	1
Molinia caerulea	hl	+	.	.	.	.	+	+	.	+	+
Pinus mugo	s1	5	5	5	5	5	5	5	5	5	5
Trientalis europaea	hl	1	+	1	+	+	1	+	+	1	+
Calamagrostis villosa	hl	.	1	2	+	1	.	.	.	.	.
Silene dioica	hl	.	+	.	.	.	.	1	.	.	.
Vaccinium myrtillus	hl	.	1	2	1	1	1	2	1	2	3
Picea abies	t1	.	.	+	.	.	.	.	.	.	.
Sorbus aucuparia ssp. glabrata	s1	.	.	.	.	.	+	+	.	.	.
Vaccinium vitis-idaea	hl	.	.	.	.	.	+	.	.	.	.
Athyrium distentifolium	hl	.	.	.	.	.	.	+	.	+	+

Header data separated (copy or cut) from the species data, transposed and pasted into another sheet