Import Excel tabular data containing latitude and longitude point information into arcmap and output to Shapefiles

Import the Excel tabular data that contains the latitude and longitude information into arcmap and output it as a shapefile, followed by the following. Use this method to point out each data containing the latitude and longitude information in ArcMap.

First, prepare the data

　　Create a new Excel table with the suffix named. xls (that is, the 2003Excel table) when you save it. Create field names in the first row of the table, with information about latitude and longitude, for calibrating locations in the map. Enter each record attribute and arrange it into a table.

Second, add X-y events in ArcMap

In the dialog box that opens, select the longitude and latitude for the data table and X, Y. Select coordinate system, here because our X, y corresponds to the data is latitude and longitude, near (118°,32°), so select a geographic coordinate system instead of the projection coordinate system. It can then be projected into the specified projected coordinate system after it is converted to geographic coordinates.

　　

　　Because our Excel table does not object-id this field value, so we import the data is only X-y event data, and the general shapefile data is not the same, can not be selected, query and so on. The X-y event data can be converted to shapefiles, so you can do it accordingly.

　　

iii. converting X-y events into Shapefile data

Right-click to select the X-y event data and select Export.

　　

You can see that the data type is already a shapefile data format. The data range (Extent) value is also normal and can be used for the next projection transformation.

Iv. Problems in existence

With this method, the truncation of the field name occurs when you import directly. (No workaround found)

Import Excel tabular data containing latitude and longitude point information into arcmap and output to Shapefiles