This file contains an explanation of the two data files, boreal_forest_climate_data.csv and specieslist_xylo.csv. The data set "boreal_forest_climate_data" contains 12 columns and 88 rows. Block: six different study sites are distributed from southern (1) to northern Sweden (6). 1: Tönnersjöheden 2: Asa 3: Siljansfors 4: Vindeln 5: Järpen 6: Ätnarova Plot: five study plots that contains one study site. Block 1: Plot 11-15 Block 2: Plot 6-10 Block 3: 16-20 Block 4: 21-25 Block 5: 1-5 Block 6: 26-30 Shade: three different shade level at one plot. 1: sun-exposed, 2: intermediately shaded and 3: fully-shaded. Mikro- and makrotemp: mean temperatures per Block, plot and shade. CTI: community temperature index per Block, plot, and shade. Bark: Remaining bark at every spruce log. Diameter: Diameter of the spruce logs. Regional climate: Average temperature measured by nearby weather stations for every block over the period from May-September 1990-2020 in °C. Aspect: Aspect in degrees of every plot. Species richness: Species richness per Block, plot, and shade. Totalab: Abundance per Block, plot, and shade. Dataset "specieslist_xylo" contains 6 columns and 3460 rows. Log: 15 Spruce logs distributed over different shade levels on every plot. Spruce logs 1,4,7,10 and 13 on shade level 1; spruce logs 2,5,8,11 and 14 on shade level 2 and spruce logs 3,6,9,12, and 15 on shade level 3. Sampling_date: Date, when beetle species were collected. Species: Name of saproxylic beetle species found in each spruce log. Number: Number of each species found in each spruce log. STI: Species temperature index for every beetle species.