Supercritical CO2 shows great potential as a working fluid in power plant cycles due to its moderate critical pressure of 7.38 MPa and critical temperature of 30.98 °C, closely matching typical heat sink temperatures. Understanding the heat transfer characteristics of sCO2 is crucial for designing cycle components. This publication presents a systematic analysis of sCO2 heat transfer in two heated vertical pipes with 4 and 8 mm inner diameters, with both upward and downward flow at pressures of approximately 7.75, 8.00, and 9.50 MPa, and flow inlet temperatures between 5 and 40 °C, based on 196 experiments. The study investigates a range of mass fluxes from 400 to 2000 kg/m2s and heat fluxes from 10 to 195 kW/m2, resulting in a heat to mass flux ratio of 6 to 275 J/kg. The findings reveal enhanced, normal, and deteriorated heat transfer within the experimental dataset. Buoyancy effects are identified as the main cause of deteriorated heat transfer in the investigated parameter range, with flow acceleration showing no significant influence on heat transfer. A new proposed dimensional criterion categorises 36 out of 119 experiments with upward flow in the deteriorated heat transfer regime, accompanied by temperature peaks rising to 47 K. Thermal inflow lengths range from 0 to 480 inner pipe diameters, with some experiments not achieving a thermally fully developed flow over the entire pipe length. Based on a comparison with approximately 8950 experimental data points, two Nusselt correlations are found, capable of reproducing the experimental results with a mean absolute deviation of around 30 %. This publication provides valuable data for validating numerical models and developing correlations to predict the heat transfer of supercritical fluids.