Abstract: In order to effectively manage and utilize large number of water chemistry data accumulated in long-term in coal mine, this paper introduces the method of data management based on Microsoft Excel, it is convenient for analysis of water chemical characteristics and is conducive to quality standard construction, the designed data table can be used as a template for the prevention and control of water by technical personnel; through application examples proved the importance of water chemistry data in the prevention and control of water.