New answers tagged excel
At this time ArcGIS Pro cannot see or use Excel spreadsheets. This functionality might be added later, but I haven't seen any firm indication of when that might be. It is currently in Pre-release and due to come out with ArcGIS 10.3.
you could also use the built in tool "export feature attribute to ascii". This is ascii file and not excel, but very easy to import in excel. It adds XY coordinates automatically and you can check the fields that you want to keep.
One option you could try: Make feature layer of your source field layer Turn off fields or make them HIDDEN via the fieldInfo.setVisible() Method sourcing from the user defined parameter. Turning fields on and off using arcpy FieldInfo (arcpy) Finally, you may use the Table to Excel method for creating the excel table from the feature layer as ...
Try to save as .dbf file your record sheet and then add to ArcGIS, and create Event layer.
See http://hilo.hawaii.edu/~sdalhelp/docs/ht_xls_to_shp.pdf A little dated but concepts are still valid. Typical issues are (1) no projection or coordinate system chosen, excel header formatted improperly, and or (3) starting out with a number as opposed to a letter for the shape file name.
The problem may not be in the output file name but in the Excel sheet field names, you need to have done some initial prep on the spreadsheet before importing it into Arc, see this article in the ArcUser Spring 2012 edition Importing Data from Excel Spreadsheets. This article also shows how to create the Geodatabase from the files.
when you are at the step of exporting, look at the bottom of the dialogue box and make sure the type is set to shapefile, sometimes it defaults to dbf. Hope that helps.
If the Excel sheet contains point coordinates and you want to make a shp, you first need to create an event layer. File, Add Data, Add XY data. Then you can go to Data, Export Data to create your shp.
Import the Excel data into either a blank (new) data frame, and it should set it to decimal degrees automatically. Right now, it's inheriting the units of your current data frame, which are set to meters because of the road shapefile. Once you've imported it as decimal degrees, you can export to a new shapefile or feature class and transform the projection ...
When you Display X/Y Data, setting the Coordinate System to GCS_WGS_1984 should give you values in decimal degrees.
Cities can be reasonably approximated as points, and it is therefore possible to put columns for latitude and longitude in the Excel file and then import them into ArcMap. To find those coordinates, there are a wide array of websites; some have well-known cities in a table [example], others let you look up the city [example], and a quick Google search will ...
In your case, getting coordinates will make points that don't help to visualize the countries. I would rather recommend to download a shapefile with the administrative boundaries (e.g. on gadm), then you can use a GIS software (e.g. QGIS) to link the names of your countries/province with your table in excel
Top 50 recent answers are included