Harvesting of near infrared (NIR) light in the abundant and environmentally friendly solar spectrum is particularly significant to enhance the utilization rate of the cleanest energy on earth. Appreciating the unique nonlinear optical properties of upconversion materials for converting low-energy incident light into high-energy radiation, they become the most promising candidates for fabricating NIR light-active photocatalytic systems by integrating with semiconductors. The present review summarizes recent NIR light-active photocatalytic systems based on a sequence of NaYF4-based, fluoride-based, oxide-based and Ln3+ ion-doped semiconductor-based photocatalysts for degradation of organic molecules. In addition, we provide an in-depth analysis of various photocatalytic mechanisms and enhancement effects for efficient photo-redox performance of different upconversion semiconductor photocatalysts. We envision that this review can inspire multidisciplinary research interest in rational design and fabrication of efficient full-spectrum active (UV-visible-NIR) photocatalytic systems and their wider applications in solar energy conversion.