Skip To Content

Edit an active table

A database is only as good as the information it contains. It's important to edit the information in your database to keep it accurate and up to date. You can update and modify spatial (features on a map) and nonspatial data (a stand-alone table of sales figures for example) through the Table view.

ArcGIS Pro automatically starts an edit session when you modify existing data or create new data. There are no buttons to start or stop an edit session. When you make edits in the table view, the edit session remains active until you save or discard your edits.

Some tables are not editable, such as text files (.xls, .xlsx, .txt, .csv for example). These tables are read-only when they are in a map. If you edit this data externally, for example in Excel, you will need to add the text file to the project again.

Some attributes are not editable in the table. All managed fields such as ObjectID, Shape_Length, and Shape_Area are not editable. You are also restricted from editing fields that have been demarcated as read-only for the layer in the Fields view of the table. You can edit joined tables, but only the base table fields. Fields from the joined table are read-only.

Edits can include editing a value in a table cell, and editing a field with contingent values.

Note:

Use the Fields view to create, modify, and delete fields.

The importance of ObjectIDs

ObjectIDs are necessary for managing data. Tables without ObjectIDs, also referred to as non-OID tables, will have limitations. To use non-OID, or read-only tabular data, the best practice is to create a standalone database table.

For Excel tables this can be done using the Excel To Table tool. For other file formats, the Table To dBASE tool or Copy Rows tool will convert your tables to they can be used in ArcGIS Pro. Additionally, the Table To Table tool gives you control over the output location. For data with spatial information, the XY Table To Point tool will create a new point feature class based on the x- and y-coordinates defined in the table.

Related topics