topic Uploading Excel data in ArcGIS Analyse Questions https://community.esri.com/t5/arcgis-analyse-questions/uploading-excel-data/m-p/824858#M79 <HTML><HEAD></HEAD><BODY><P>I have been trying to upload my excel .cvs data file to arcmap, but can not get the data to show for spatial and statistical analysis. What can I do?</P></BODY></HTML> Sun, 04 Aug 2019 17:49:36 GMT James_LYNCH 2019-08-04T17:49:36Z Uploading Excel data https://community.esri.com/t5/arcgis-analyse-questions/uploading-excel-data/m-p/824858#M79 <HTML><HEAD></HEAD><BODY><P>I have been trying to upload my excel .cvs data file to arcmap, but can not get the data to show for spatial and statistical analysis. What can I do?</P></BODY></HTML> Sun, 04 Aug 2019 17:49:36 GMT https://community.esri.com/t5/arcgis-analyse-questions/uploading-excel-data/m-p/824858#M79 James_LYNCH 2019-08-04T17:49:36Z Re: Uploading Excel data https://community.esri.com/t5/arcgis-analyse-questions/uploading-excel-data/m-p/824859#M80 <HTML><HEAD></HEAD><BODY><P>You may have some issues since your field names contain unsavory characters and some of your fields might be interpreted as 'math' ie...</P><P></P><P>WBID,Site Code,Date,Waterbody&nbsp; Name,Latitude,Longitude,Elevation (feet),"Hardness (mg/l) (Ca, Mg)",Total Unfiltered Ca (ppm) ,Total Mg (ppm),Dissolved Pb (ppm),Dissolved Zn (ppm)<BR />1934,1934/6.1,3/25/2009,Shoal Cr.,37.82020200,-91.13719500,895.67,171,34.6,20.5,0.000250,0.002090</P><P></P><P>field names... remove spaces&nbsp;</P><P>Hardness_CaMg</P><P>Total_Ca</P><P>Total_Mg</P><P>Diss_Pb</P><P>Diss_Zn</P><P>perhaps.</P><P>1934/6.1 hmmm math? probably not, if you could fix to 1934_6_1 it would be guaranteed to be a string</P><P>Latitude and Longitude are good? IF there are not blank spaces in that column AND Longitude is specified as X and Latitude as Y when you make the event layer.</P><P></P><P>In short, I would fix in Excel, ensure that you have no blank cells in any column by assigning an appropriate null value and clean up the field names</P></BODY></HTML> Mon, 05 Aug 2019 16:27:10 GMT https://community.esri.com/t5/arcgis-analyse-questions/uploading-excel-data/m-p/824859#M80 DanPatterson_Retired 2019-08-05T16:27:10Z