In order to solve the problems of high error rate and low work efficiency in the manual statistical analysis of large-scale construction and installation engineering data of power plants, the author developed a large-scale data analysis system suitable for various work scenarios based on VBA language, which realizes the batch, automation and rapidity of data collection, query, matching and merging, and releases productivity. It makes the office staff free from the statistical analysis of a large number of tabular data, and improves the work efficiency and the accuracy of data.