The invention relates to system and method for detecting the transformer winding state by using constant-current sweep frequency power source excitation. A measurement and control analysis module controls sweep frequency power source and applies output constant-current sweep frequency excitation signals by an exciting transformer at a high-voltage side of the transformer to be detected; a vibration sensor measures vibration response signals of a transformer winding to be detected at different excitation frequencies; a vibration signal collector collects and preprocesses the signals measured by the vibration sensor; and the measurement and control analysis nodule carries out spectrum analysis to the received and processed vibration response signal data, displays and records a resonant frequency curve of the transformer winding on a frequency domain, compares with the resonant frequency curve previously measured and recorded as well as the vibration frequency curve of a transformer three-phase coil, and judges the state of the transformer winding to obtain the measuring result. The invention can effectively and sensitively detect the states of looseness or deformation of the transformer winding for prompt repair or replacement so as to avoid a fault of abrupt short circuit of the transformer caused by damage of the winding structure.