topic Re: Converting an excel spreadsheet into a map in ArcMap 10.4?? in ArcGIS Mapping and Charting Questions https://community.esri.com/t5/arcgis-mapping-and-charting-questions/converting-an-excel-spreadsheet-into-a-map-in/m-p/139371#M466 <HTML><HEAD></HEAD><BODY><P>Do you need open excel sheet in Arc GIS or Join it with table in Arc GIS?</P><P>about your excel sheet with name( nomis_2017_08_19_194923) it is like a report and it isn't table. so I can answer your question with&nbsp;<STRONG>NO </STRONG>but&nbsp;you should separate each table in Independent sheets</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P><SPAN style="font-size: medium;">if I need just an area do I remove the others parts of the sheet (e.g. need bolton, should i remove the other cities etc or just leave them?? </SPAN></P></BLOCKQUOTE></BODY></HTML> Sun, 20 Aug 2017 21:44:03 GMT AbdullahAnter 2017-08-20T21:44:03Z Converting an excel spreadsheet into a map in ArcMap 10.4?? https://community.esri.com/t5/arcgis-mapping-and-charting-questions/converting-an-excel-spreadsheet-into-a-map-in/m-p/139370#M465 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 11.5pt; color: #3d3d3d; background: white;">I basically need to show employment level, education level etc etc, in a specific area of the UK, however, in the moment that I try to add the excel sheet in arcmap it gives me an error, and I'm stuck at this stage. So, I attached some file just to give you an idea, I really need it urgently. Also, if I need just an area do I remove the others parts of the sheet (e.g. need bolton, should i remove the other cities etc or just leave them?? If you need any more clarification please do not hesitate to ask. Will really appreciate your help.</SPAN></P></BODY></HTML> Sun, 20 Aug 2017 21:02:15 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/converting-an-excel-spreadsheet-into-a-map-in/m-p/139370#M465 AminPinilla 2017-08-20T21:02:15Z Re: Converting an excel spreadsheet into a map in ArcMap 10.4?? https://community.esri.com/t5/arcgis-mapping-and-charting-questions/converting-an-excel-spreadsheet-into-a-map-in/m-p/139371#M466 <HTML><HEAD></HEAD><BODY><P>Do you need open excel sheet in Arc GIS or Join it with table in Arc GIS?</P><P>about your excel sheet with name( nomis_2017_08_19_194923) it is like a report and it isn't table. so I can answer your question with&nbsp;<STRONG>NO </STRONG>but&nbsp;you should separate each table in Independent sheets</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P><SPAN style="font-size: medium;">if I need just an area do I remove the others parts of the sheet (e.g. need bolton, should i remove the other cities etc or just leave them?? </SPAN></P></BLOCKQUOTE></BODY></HTML> Sun, 20 Aug 2017 21:44:03 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/converting-an-excel-spreadsheet-into-a-map-in/m-p/139371#M466 AbdullahAnter 2017-08-20T21:44:03Z Re: Converting an excel spreadsheet into a map in ArcMap 10.4?? https://community.esri.com/t5/arcgis-mapping-and-charting-questions/converting-an-excel-spreadsheet-into-a-map-in/m-p/139372#M467 <HTML><HEAD></HEAD><BODY><P>The answer to working with excel... try not to, but if you have to, you need to replicate the format of a table as seen in arcmap or ArcGIS pro.&nbsp; Column headers, no blank rows etc etc.</P><P></P><P><STRONG><A _jive_internal="true" href="https://community.esri.com/groups/esri-training/blog/2017/05/26/working-with-excel-data-in-arcgis-pro">A good link to start....</A></STRONG></P></BODY></HTML> Sun, 20 Aug 2017 21:53:19 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/converting-an-excel-spreadsheet-into-a-map-in/m-p/139372#M467 DanPatterson_Retired 2017-08-20T21:53:19Z