The invention discloses an Excel-based tube plate diagram generating method during nuclear power steam generator heat exchanging pipe detection. The method includes the steps of S1, building a coordinate system in the preset area of an Excel worksheet, wherein each cell of the preset area corresponds to one coordinate; S2, collecting the heat exchanging pipe information of the preset loop of a steam generator; S3, inserting icons representing heat exchanging pipes in the corresponding cells of the coordinate system to generate an initial tube plate diagram; S4, importing coordinate lists of the heat exchanging pies which need to be tracked and detected; S5, marking the icons, corresponding to the coordinates in the coordinate lists, in the cells. The method has the advantages that the tube plate diagram is generated automatically according to the imported coordinate lists of the heat exchanging pies which need to be tracked and detected, the process is simple, a large amount of repeated work is reduced, and work efficiency is increased.