The invention discloses a spring unit modeling method of an SRC component finite element model based on Excel. The spring unit modeling method comprises the steps: establishing a finite element modelof an SRC component, and storing an inp file; copying profile steel node information in the inp file to the first column of Sheet1 and dividing the profile steel node information into four columns; copying the concrete node information to the fifth column and dividing the concrete node information into four columns; copying the first column of profile steel node numbers to the tenth column, searching concrete node numbers with the same coordinates as the profile steel nodes in the 2nd, 3rd and 4th columns of the first row from the concrete nodes, and obtaining profile steel and concrete node numbers with the same coordinates in the 10th and 11th column of each row; obtaining section steel and concrete joint numbers required by the spring units; obtaining a spring unit required by the inp file in the twelfth column; and copying the twelfth column of spring units to a required position in the inp file, and adding attributes of the spring units in front of the first spring unit. Accordingto the spring unit modeling method, the addition of the spring unit can be efficiently and accurately completed, so that the spring unit modeling method is used for finite element simulation analysisof the SRC component or structure considering the bonding slip performance.