The invention provides a method and a platform for quickly and dynamically generating a form based on EXCEL. The method for quickly and dynamically generating the form based on the EXCEL comprises the steps that form data trends are analyzed, and a form scheme is established; according to an existing or new EXCEL document, a form frame is adjusted or established; data are organized, converted into data items which can be recognized by a system and written into all cells; a template is uploaded to a server; template cell data descriptive analysis is executed, processing is carried out cell by cell, and information is recorded into a form scheme detail table item by item; after analysis is completed, master-slave correlation is carried out on a form data model and data items, a structure is converted into a database script, and a data format is generated after execution; the form is accessed through a menu. According to the method and the platform for quickly and dynamically generating the form based on the EXCEL, encapsulation is carried out by accessing the database, programming is transformed into configuration, and the common office software EXCEL is used as the template, developing workload can be reduced effectively, the object of reducing 10%-60% of form making workload can be achieved, and adjustment is easy.