I am trying to create a shapefile in DIVA-GIS from a CSV file. Map charts have gotten even easier with geography data types. Pick the column that contains the area name and press import.
For step-by-step gudiance, see our MapShaper tutorial. Browse to your project area, expand the Battle_Mountain folder, then expand the XLSFiles folder. Ideally, I would like to have a third column specifying the coordinate system of the x,y coordinate pair, and have the excel file contain heterogenous coordinate systems. Use the Excel To Table tool to convert the Microsoft Excel file into a table in ArcMap.
I would like to be able to convert this to a point geometry shapefile, with each row's x,y pair representing a point.
Select format (ESRI Shapefile), name the file, and browse to the location you want to save the shapefile. Once all of the field data for the tables have been mapped, click Next. mxd file and review the layer files and the geodatabase layers in the Battle_Mountain file geodatabase. Create shapefile from excel The file contains occurrence data for a species and contains four fields: ID, Country, Latitude, Longitude.