Abstract: From the requirement management process, it was developed a tool of requirement traceability matrix based on Excel and VBA. The function of requirements allocation, partition, mergence and coverage were implemented in the Excel. The window interface was easy to use, the tool was highly portable. The informatization of requirement management could improve the efficiency of daily work.