topic Re: How can I update a standalone table (.xlsx) in arcgis pro? in ArcGIS Pro Questions

How can I update a standalone table (.xlsx) in arcgis pro?

AntonioRodriguez_Garrido — Tue, 02 Jun 2020 16:23:13 GMT

We have always worked with standalone tables in arcmap and never had problems when these tables were updated, instantly changes were reflected in our map. However, now in arcgis pro we are not able to work as the same way, standalone table can't be updated, we must export to a layer or gdb to change something, this way we lose changes in our native excel files, would be better if directly we could change excel file. Thanks in advance

Re: How can I update a standalone table (.xlsx) in arcgis pro?

DanPatterson — Tue, 02 Jun 2020 17:26:19 GMT

from Edit an active table—ArcGIS Pro | Documentation

Some tables are not editable, such as text files (.xls, .xlsx, .txt, and .csv, for example). These tables are read-only when they are in a map.

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

Once the table is added to the map, you can open it in the Contents pane. However, you cannot edit the table or export records to an Excel format.

and there is a big section towards the bottom on limitations

Re: How can I update a standalone table (.xlsx) in arcgis pro?

AntonioRodriguez_Garrido — Fri, 05 Jun 2020 06:08:31 GMT

Thank you so much Dan, your help is really appreciated. It seems .xls are read-only files, however, further investigating, if we use "Make xy event layer" tool from a .csv, it's allowed to update any row in this .csv and see this change reflected straight away in our map without exporting anything.

Regards

Re: How can I update a standalone table (.xlsx) in arcgis pro?

KevinMacLeodCAI — Wed, 11 Aug 2021 20:42:45 GMT

Why would editing tables be taken away? I hope we can see this added back in Pro. Very common to use xls and csv tables and there are many business reasons to retain those formats for data. For one, gdb is not an open format like shapefiles are.