Problematic Excel spreadsheets

133
1
3 weeks ago
Labels (1)
WDFWAdministrator
Emerging Contributor

We regularly have users come to us thinking ArcGIS Pro is missing microsoft drivers and such when they have problems importing excel spreadsheets.  Sometimes it imports but is unusable and the xy event doesn't work.  What I'm finding is that there are issues with the spreadsheets.  Sometimes I'm able to manually clean column heading or the lat long data which can be time consuming.  Recently I had a spreadsheet with only 12 rows but I couldn't find the reason it wouldn't convert to points.  Finally, I export it to a csv and brought it back into excel.

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?  This would probably need to be an ArcGIS specific cleanup utility based on the various issues I've run into.  In one case the column names were illegal but the error messages generated by Pro are useless.

Tags (1)
0 Kudos
1 Reply
DanPatterson
MVP Esteemed Contributor

just advice

Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation

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


... sort of retired...
0 Kudos