Research into the factors influencing university-industry collaboration on public university spin-offs creation has focused on management, entrepreneurship, technology and innovation. This research began with a careful systematic literature review of 4427 scientific papers published in the last ten years (2014-2023) and accessible in the prestigious Web of Science core collection. A quantitative methodology was used, complemented by the use of the visual analysis tool Posit PBC™, formerly known as R Cloud Studio. This comprehensive approach facilitated the seamless ingestion of raw data into Biblioshyni, which is a web-based platform specialised in bibliometric analysis. This review has revealed compelling trends, particularly in terms of increasing diversity, the emergence of United Kingdom as a major player, and the central role of university-industry collaboration. Our systematic review identified influential authors in the field, including the prolific contributions of scholars such as D. Radicid, S. Ropers, Y. Li and R. Owen. We also identified important research institutions, such as Utrecht University in Netherlands, Lund University in Sweden and The University of Manchester in the UK. In addition, we have shown that countries such as the United Kingdom, China and USA have made a significant contribution to the volume of publications. The results highlighted a marked increase in the phenomenon of univeristy spin-offs over the past decade, as evidenced by the exponential growth in both publication output and citation rates. This empirical revelation was underpinned by a rigorous exploration of the Web of Science database, using a carefully crafted set of keywords. Thirty-seven pivotal studies were selected for in-depth review through a sophisticated selection process that adhered to the rigorous standards of the PRISMA methodology. The aim of this review is to improve understanding and encourage deeper exploration of spin-off-based public universities through collaboration between academia and industry.