Abstract:During the period of making geological maps by using MapGIS software, there always occurred some problems on inputting lots of lines and plots datas. If these datas are directly input individually, it is not only inefficient, but also easy to input incorrect datas. In this paper, preparation function of Excel has been used to make written documents of MapGIS. It is clearly illustrated how realize the batch entry of plot and line documents. Thus, geological maps can be made more rapidly, accurately and efficiently.