https://community.esri.com/t5/arcgis-pro-questions/problematic-excel-spreadsheets/m-p/1577005#M92100 <P>We regularly have users come to us thinking ArcGIS Pro is missing microsoft drivers and such when they have problems importing excel spreadsheets.&nbsp; Sometimes it imports but is unusable and the xy event doesn't work.&nbsp; What I'm finding is that there are issues with the spreadsheets.&nbsp; Sometimes I'm able to manually clean column heading or the lat long data which can be time consuming.&nbsp; Recently I had a spreadsheet with only 12 rows but I couldn't find the reason it wouldn't convert to points.&nbsp; Finally, I export it to a csv and brought it back into excel.</P><P>I'm wondering, does anyone know of a excel utility that can go through a field and cleanup the formatting, data, etc so I don't have to export to and import back into excel?&nbsp; This would probably need to be an ArcGIS specific cleanup utility based on the various issues I've run into.&nbsp; In one case the column names were illegal but the error messages generated by Pro are useless.</P> Sat, 18 Jan 2025 00:54:50 GMT WDFWAdministrator 2025-01-18T00:54:50Z https://community.esri.com/t5/arcgis-pro-questions/problematic-excel-spreadsheets/m-p/1577005#M92100 <P>We regularly have users come to us thinking ArcGIS Pro is missing microsoft drivers and such when they have problems importing excel spreadsheets.&nbsp; Sometimes it imports but is unusable and the xy event doesn't work.&nbsp; What I'm finding is that there are issues with the spreadsheets.&nbsp; Sometimes I'm able to manually clean column heading or the lat long data which can be time consuming.&nbsp; Recently I had a spreadsheet with only 12 rows but I couldn't find the reason it wouldn't convert to points.&nbsp; Finally, I export it to a csv and brought it back into excel.</P><P>I'm wondering, does anyone know of a excel utility that can go through a field and cleanup the formatting, data, etc so I don't have to export to and import back into excel?&nbsp; This would probably need to be an ArcGIS specific cleanup utility based on the various issues I've run into.&nbsp; In one case the column names were illegal but the error messages generated by Pro are useless.</P> Sat, 18 Jan 2025 00:54:50 GMT https://community.esri.com/t5/arcgis-pro-questions/problematic-excel-spreadsheets/m-p/1577005#M92100 WDFWAdministrator 2025-01-18T00:54:50Z https://community.esri.com/t5/arcgis-pro-questions/problematic-excel-spreadsheets/m-p/1577010#M92102 <P>just advice</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/help/data/excel/work-with-excel-in-arcgis-pro.htm" target="_blank">Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation</A></P><P>I haven't seen a utility that covers all the issues that a user can create by using a spreadsheet for data input or as a source</P> Sat, 18 Jan 2025 01:57:19 GMT https://community.esri.com/t5/arcgis-pro-questions/problematic-excel-spreadsheets/m-p/1577010#M92102 DanPatterson 2025-01-18T01:57:19Z