Abstract: The stratified statistics of soil test indicators is the basis of data analysis in geotechnical engineering investigation, which is the main basis for providing geotechnical parameters such as bearing capacity of foundation and pile, ground deformation analysis and foundation pit supporting. Based on Excel soil test report and Excel VBA, template of statistical analysis is prepared and statistical processing of stratified data is realized. Its Excel table can be used directly as the project document of a survey report.