Edit in Excel

This is a three-button round trip, and the buttons must be used in order:

Settings configures how both ends of the round trip behave.

• A feature layer must be selected in the Contents pane. The button is governed by the esri_mapping_featureLayerSelectedCondition condition and is disabled otherwise, with the tooltip "Select a feature layer in the Contents pane to enable this tool."
• The workbook is written to the export location configured in Settings, or to the system temp directory if none is set. For work spanning more than one session, set a real folder — a file in the temp directory can be cleared by the operating system.
• Do not add, delete, or reorder columns in the workbook, and do not change the OBJECTID values. The apply step matches rows back to features by OBJECTID; altering the structure breaks that correspondence. Edit the values in place only.
• Settings can show the OBJECTID column as read-only and apply domain value dropdowns in Excel, which keeps entry within the permitted values.
• The Max records setting caps how many rows are exported. Check it before exporting a large layer — a cap set below the layer's row count means you are editing only part of the data.
• Only one editing session is tracked at a time. Complete or abandon a round trip before starting another.

1. Open Settings and set a real Export Location. Confirm Max records is 0 or above the layer's row count.
2. In the Contents pane, select the feature layer.
3. On the KGA Toolbox tab, in the Necessary Edit Tools group, open the Edit in Excel menu and click Edit in Excel.
4. The workbook is created and opened. Edit the attribute values in place.
5. Do not add, remove, or reorder columns, and leave the OBJECTID values untouched.
6. Save and close the workbook.
7. Return to ArcGIS Pro and click Apply Excel Edits.

Requires an active KGA Toolbox license. The tool validates the license before running.