Abstract: Accurate acquisition of advanced geological information and experience-based decision-making remain major challenges for intelligent coal mine excavation. This study proposes a construction method for a transparent excavation geological navigation system based on comprehensive drilling geophysical exploration. Integrating the collaborative advanced detection technology of drilling geophysical exploration, multi-source geological data fusion interpretation, and navigation route planning algorithms, the study presents an integrated "detection-guidance-excavation" architecture. The innovative breakthroughs include: A collaborative mechanism for the drilling-geophysical data chain was established. By innovatively integrating borehole transient electromagnetic stereo detection, borehole ground-penetrating radar (GPR) refined imaging, and measurement-while-drilling natural gamma lithology identification technologies, synchronous and refined multi-parameter detection of concealed water-bearing bodies, geological structures, and coal seam roof/floor undulations was achieved within a 1000 m advance distance and 30 m radial range using a single directional long borehole. A multi-parameter joint inversion model based on the Bayesian framework and a spatiotemporal collaborative Kriging-STL data fusion algorithm were proposed, effectively solving the deep fusion problem of multi-source heterogeneous data under a unified spatiotemporal reference. A high-precision dynamic 3D geological model of the tunneling face featuring structural constraints and physical property filling was constructed, and a geological adaptive navigation strategy based on an improved A* algorithm was designed. This strategy quantifies geological risk areas such as water hazards and structures into cost functions for path searching. Combined with the mutual feedback update mechanism of the digital twin system, it realizes autonomous planning and real-time correction of excavation paths.Engineering practice has demonstrated that the transparent excavation geological navigation system based on comprehensive borehole geophysical exploration successfully identified a concealed goaf water accumulation anomaly in the 24104 working face of a certain mine. The excavation cycle of the roadway was reduced from the original 107 days to 67 days, increasing efficiency by approximately 37%. This work transcends the traditional “exploration-excavation” separation, establishing a new paradigm for safe, efficient coal mining in complex environments. It offers reliable and accurate geological assurance for the long-distance advance detection and high-precision geological navigation of rapid roadway excavation in future coal mines.