The non-precious metal single-atom catalysts (SACs) supported on carbon materials for the catalytic transfer hydrogenation (CTH) of α,β-unsaturated aldehydes (UAL) still suffer from the problems of harsh reaction conditions and low activity. In this work, nickel SACs anchored on porous N-doped nanocarbon (Ni1/NC900) with dual reaction sites were synthesized using the high internal-phase emulsion (HIPE) template method combined with impregnation. The Ni1/NC900 catalyst exhibited remarkable catalytic activity for the CTH of furfural (FF) to furfuryl alcohol (FFA), achieving >99.0 % conversion and selectivity at 100 °C for 60 min, with a turnover frequency (TOF) of 2908.1 h−1, surpassing other reported nickel-based catalysts by 1–3 orders of magnitude. The excellent catalytic performance of Ni1/NC900 was attributed to the high mass transfer efficiency (HMTE) of the support and the dual reaction sites of Ni–N4 and pyridinic N, where Ni–N4 as Lewis acidic site for adsorption of FF and isopropanol (i-PrOH), while the adjacent pyridinic N as Lewis basic site for the deprotonation of i-PrOH. The isotope labeling experiments revealed that the hydrogenation of FF was accomplished by proton transfer with i-PrOH, in agreement with the intermolecular hydride transfer mechanism. Furthermore, Ni1/NC900 demonstrated excellent stability and well general applicability, demonstrating its potential for industrial applications. This work provides a reference for the application of carbon-based non-precious metal SACs in the CTH reaction of UAL.