Abstract: In view of the problems that track dynamic detection data by manual statistics is low efficiency, error prone, non-standard and unconformity, on the basis of standardizing the thinking, method, process and format of data analysis, through Excel VBA programming technology, this article designed and developed an application program for statistical analysis of track dynamic detection data. It was implemented the automatic statistical analysis of the daily report of railway vehicle shaking instrument, and comprehensive analysis of detection data for vehicle shaking instrument, portable multiplying instrument and mobile railway inspection vehicle with the program. The function of automatic evaluation of operation quality, automatic early warning for track control weak areas, dynamic quality trend analysis of track control, and automatic generation of inspection report forms for EMU (track) inspection vehicles were also realized. The analysis time is saved, the analysis quality and efficiency are improved, and the analysis result guides production and improves the quality of equipment.