Known latitude and longitude coordinates import ARCMAP generate SHP format file

First, the preparatory work:

1. Firstly, the obtained latitude and longitude coordinates (generally latitude and longitude) are converted to the degree format, and the conversion formula is =left (c3,3) +mid (C3,find ("°", C3) +1,2)/60+mid (C3,find ("′", C3) +1,4)/3600 (Note: Each parameter depends on the specific circumstances)

2. Regenerate an Excel table, the corresponding x,y coordinates generate two columns, the first behavior column name (such as X,y) in order to arrange the coordinates of the information.

3. Save the secondary Excel table as a. csv file.

can also be made accordingly. TXT file, but personally feel relatively troublesome, TXT file input content format is as follows

X,y

117.4333333, 30.82433333

Second, import data and generate SHP files:

Method One:

1. ArcMap below, the menu Tools-add XY Data ..., as shown in the following figure: