topic Importing data into ArcMap in Data Management Questions https://community.esri.com/t5/data-management-questions/importing-data-into-arcmap/m-p/366342#M20913 <HTML><HEAD></HEAD><BODY><SPAN>I am having trouble importing information from Excel into ArcMap.&nbsp; I have removed all formulas from the data collection, so it consists of only values, and saved it as a .csv.&nbsp; ArcMap won't import the data due to "general function failure".&nbsp; Does anyone know how to get around this?</SPAN></BODY></HTML> Tue, 16 Oct 2012 03:34:23 GMT HayleyMaynard 2012-10-16T03:34:23Z Importing data into ArcMap https://community.esri.com/t5/data-management-questions/importing-data-into-arcmap/m-p/366342#M20913 <HTML><HEAD></HEAD><BODY><SPAN>I am having trouble importing information from Excel into ArcMap.&nbsp; I have removed all formulas from the data collection, so it consists of only values, and saved it as a .csv.&nbsp; ArcMap won't import the data due to "general function failure".&nbsp; Does anyone know how to get around this?</SPAN></BODY></HTML> Tue, 16 Oct 2012 03:34:23 GMT https://community.esri.com/t5/data-management-questions/importing-data-into-arcmap/m-p/366342#M20913 HayleyMaynard 2012-10-16T03:34:23Z Re: Importing data into ArcMap https://community.esri.com/t5/data-management-questions/importing-data-into-arcmap/m-p/366343#M20914 <HTML><HEAD></HEAD><BODY><SPAN>ArcGIS may have a problem with reading .csv due to delimiter symbol which of your regional settings which is not recognized.</SPAN><BR /><BR /><SPAN>But you don't need to export Excel spreadsheet to .csv to open it in ArcMap. If you have at least ArcGIS 9.2, you can open Excel worksheet directly in ArcMap as a table. Or use Add Data -&gt; Add XY Data wizard to create points from XY coordinates from worksheet.</SPAN><BR /><BR /><SPAN>To ensure that Excel files are read correctly follow </SPAN><A href="http://www.esri.com/news/arcuser/0312/best-practices-when-using-excel-files-with-arcgis.html">Best Practices</A><SPAN>.</SPAN></BODY></HTML> Tue, 16 Oct 2012 04:34:19 GMT https://community.esri.com/t5/data-management-questions/importing-data-into-arcmap/m-p/366343#M20914 MarcinGasior 2012-10-16T04:34:19Z