Abstract: Aiming at the key problems of large number of the traditional train route data, tedious procedure of manual production and verification of route data table, and the error-prone for large scale station, this article used Visual Studio 2017 as software development platform, VBA and Active X Automation as development tools, designed a software for route data table compilation based on train control data to ensure the accuracy of route data table compilation. The software was applied in train control data compilation of Beijing-Shijiazhuang passenger dedicated railway, TianjinBaoding railway and other projects. The results show that the software meets the accuracy requirements of train route data table compilation and improves the efficiency and accuracy of train route data compilation.