Abstract:EBOM(Engineering Bill of Material) applied in Aircraft field is the deliverable which Design Department of Aircraft Engineering should provide to Procurement, Methods and Project Department as the basis of purchasing and manufacturing controlling. Whether the information is ample or deficient, whether the format is standard or nonstandard, whether it is easy to read or not, they all represent the work quality of Design Department to some extent. Taking the relatively standard EBOM practically applied in one Civil Airplane Project as the original version, and the Excel tables as applying platform, the necessary property information has been customized, and one set of method and workflow has been customized by use of the functions of Excel. The workflow of formatting EBOM has been programmed, which tremendously improved the efficiency and quality of making and updating EBOM.