Form data efficient input method based on note mode

The invention relates to the field of informatization, in particular to a form data efficient input method based on a note mode, which comprises the following steps of: establishing a formal form Excel template; establishing a note form Excel template; defining an operation rule between the key column data in the note form Excel template and the key column data in the formal form Excel template byutilizing an automatic calculation function of the Excel; generating an input interface according to the note form Excel template; when a user fills in the note form Excel template through the inputinterface, automatically filling corresponding data in the formal form Excel template according to the operation rule, and then using the filled formal form Excel template as a final form to be submitted. According to the method, the data is automatically generated according to the defined calculation rule through the automatic calculation function provided by the Excel, so that a user can be helped to more efficiently com