topic Re: Excel table appears empty in ArcMap in Data Management Questions https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46239#M2602 <HTML><HEAD></HEAD><BODY><SPAN>The formatting of some of the fields in this spreadsheet have functions related to them. I just got done troubleshooting a similar issue. Make sure every field is formatted and not a function of other cells.</SPAN></BODY></HTML> Fri, 30 Sep 2011 20:24:56 GMT denisedavis 2011-09-30T20:24:56Z Excel table appears empty in ArcMap https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46237#M2600 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to geocode the attached table, however when I bring it into ArcMap and open it I see an empty table.&nbsp; Why?</SPAN></BODY></HTML> Mon, 26 Sep 2011 18:51:50 GMT https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46237#M2600 Anonymous User 2011-09-26T18:51:50Z Re: Excel table appears empty in ArcMap https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46238#M2601 <HTML><HEAD></HEAD><BODY><SPAN>I think you need to get rid of the spaces in the field names.</SPAN></BODY></HTML> Fri, 30 Sep 2011 19:55:32 GMT https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46238#M2601 MarcGuidry 2011-09-30T19:55:32Z Re: Excel table appears empty in ArcMap https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46239#M2602 <HTML><HEAD></HEAD><BODY><SPAN>The formatting of some of the fields in this spreadsheet have functions related to them. I just got done troubleshooting a similar issue. Make sure every field is formatted and not a function of other cells.</SPAN></BODY></HTML> Fri, 30 Sep 2011 20:24:56 GMT https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46239#M2602 denisedavis 2011-09-30T20:24:56Z Re: Excel table appears empty in ArcMap https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46240#M2603 <HTML><HEAD></HEAD><BODY><SPAN>You might also try getting rid of most, if not all, of the empty columns. I'm not sure, but a limit on the number of fields. In any case, they just bloat the file. Also, as well as no spaces in the column names, maybe Excel column names need to be under 13 characters like a dbf. It doesn't hurt, anyway. If you wanted to make a shapefile out of the data, you'd need to do it then.</SPAN></BODY></HTML> Fri, 30 Sep 2011 23:32:01 GMT https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46240#M2603 Zeke 2011-09-30T23:32:01Z Re: Excel table appears empty in ArcMap https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46241#M2604 <HTML><HEAD></HEAD><BODY><SPAN>shot in the dark..... but I don't deal with .xlsx files they just gave me too many issues </SPAN><BR /><BR /><SPAN>I always save mine as 97-2003 .xls files</SPAN><BR /><BR /><SPAN>this could have been fixed though I haven't checked on it in quiet a while</SPAN></BODY></HTML> Tue, 04 Oct 2011 20:59:13 GMT https://community.esri.com/t5/data-management-questions/excel-table-appears-empty-in-arcmap/m-p/46241#M2604 CoryAlvarado 2011-10-04T20:59:13Z