Abstract: Data entry, editing and organization are involved in the process of nondestructive testing data collation. Because the amount of data needed to be compiled is huge and there are many kinds of data, the work is tedious, the workload is heavy and the error rate is high. This paper introduces the use of formulas, functions, numerical conversion and other functions in Microsoft Office Excel to quickly compare and compile a large number of data, which can greatly improve the working efficiency of inspectors.