Abstract: Monitor and analysis on working resistance of hydraulic support is an important component of analyzing ground pressure in mining field. The results of data processing can not only reflect the law of rock pressure in working face, but also analyze the characteristics of relationship between support and the surrounding rock. Meanwhile, it is also the data support for the design and selection of the hydraulic support. To make full use of monitoring results, it is necessary to process data quickly and accurately. There are more characteristics in Excel such as simple operation, powerful data processing function, good intuitiveness in processing results and so on. Based on advantages of Excel, the calculation and graphic output of hydraulic support monitoring data are realized.