The invention provides a method for inputting floating row data. The method comprises the following steps of: (S102) reading a worksheet; (S104) judging whether the worksheet is exported from a system and confirming floating row judgment conditions to be used according to a judgment result; (S106) scanning the worksheet and generating a floating row according to the floating row judgment conditions; (S108) adding the generated floating row to a system template to form a system table; and (S110) importing the data of the floating row to the system table under the condition that the system table has the same format as the worksheet, or else, prompting on import failure. The invention can solve the problem on compiling floating row data added, modified or deleted by a user in Excel to a corresponding datasheet. The technical scheme of the invention can be used for accurately identifying the region of the floating row, analyzing the dimension members of the floating row and copying the corresponding data to the datasheet. The invention also provides a method for inputting the floating row data into the Excel.