Using of combining MapGIS with VB and PivotTable of Excel is given in this paper. The methods could not only be used to solve the problem of data format transformation to MapGIS of 123 mineralization prospective area and 50 000 work data but also to compute the area and get the data tables of 19 mineralization belts. The method has provided technical support for the study of regional geophysical and geochemical planning.