Below are some common table-related tasks with links to find more information. In addition, there are many geoprocessing tools that allow you to perform tasks such as data conversion and management on tables and attribute data. Create datasets in a geodatabase. Create Table. Make Table View. Creating a layer from a table with x,y coordinate data. Add x,y coordinate data as a layer. XY Table To Point. Copy Features.
Importing, copying, and converting tabular data sources. Import data. Copy feature datasets, feature classes, and tables to a geodatabase. An overview of the Excel toolset. Table To Table. Table To Geodatabase. Adding and modifying fields, domains, and subtypes.
An overview of fields. Create, modify, and delete the fields of a layer or table. View and edit fields, domains, and subtypes. An overview of the Fields toolset. An overview of the Domains toolset. An overview of the Subtypes toolset.
Add Geometry Attributes.
Open tabular data. Sort records in a table. Filter data in the table. Hide columns in a table. Freeze columns in a table. An overview of the Layers and Table Views toolset. Make Query Table. Select records in a table interactively. View all or only the selected records.
Highlight records within a selection set. Edit an active table.
Portal for ArcGIS
Edit feature attributes. Add data to an existing table.If you have privileges to update a feature or table layer, you can edit attributes in these layers. If the layer also has attachments enabled, you can add related photos and files to the table.
Tip: Layer owners and organization administrators manage editing and attachment settings for feature and table layers. They can also perform bulk editing operations, such as calculating field values and appending data, and they can alter the attribute table by adding or deleting fields.
If a feature layer is editable and the layer owner allows updates to the layer, anyone who has privileges to edit can alter the attribute values in the layer's attribute table and in any related tables. If the layer has related records, they are represented as columns with italicized headers on the right side of the table.
Owners and administrators of a layer manage how others can edit the layer and its attributes. If the layer is editable, data curators and members of shared access groups can edit or delete attributes. Tip: To create a feature layer that contains related records, you must publish the layer from ArcMap. Follow these steps to edit values in a table in Map Viewer :. Follow these steps to edit values in a related table:. Columns from related tables appear on the right side of the table and have italicized headers.
You may need to scroll to the right to see the column you need.
When the related table opens, the related value is selected. Due to space limitations, you will see a limited number of columns from the related table. Feature and table layers can include related photos or other files as attachments, which you can view from the attribute table.
If you have privileges to edit the layer, you can attach related photos and files to records in the table. Follow these steps to add related photos and files:.
Feedback on this topic? Skip To Content.If you have privileges to edit a feature or table layer, you can edit attributes in these layers. If the layer also has attachments enabled, you can add related photos and files to the table. Tip: Layer owners and portal administrators manage editing and attachment settings for hosted feature and table layers. They can also perform bulk editing operations, such as calculating field valuesand they can alter the attribute table by adding or deleting fields.
If a feature layer is editable, its attribute table is always editable. If you have privileges to edit the layer, you can edit or delete the attributes in the layer's attribute table and in any related tables. Owners and administrators of a layer manage how others can edit the layer and its attributes.
If the layer is editable, data curators and members of shared access groups can edit or delete attributes.
If the layer has related records, those attributes can also be edited by users with the correct privileges. You will see these related records represented as columns with italicized headers on the right side of the table.
Follow these steps to edit values in a table in Map Viewer :. Follow these steps to edit values in a related table:. Columns from related tables appear on the right side of the table and have italicized headers. You may need to scroll to the right to see the column you need. Feature and table layers can include related photos or other files as attachments, which you can view from the attribute table.
If you have privileges to edit the layer, you can attach related photos and files to records in the table. Follow these steps to add related photos and files:. Feedback on this topic? Back to Top. Add the feature or table layer to Map Viewer and open its attribute table. Click inside the cell that contains the value you want to edit and type a new value, or remove the value if you want to delete it.
Press Enter to save your changes. Find the attribute for which you want to edit a related value and open the related table by clicking Show inside the cell of the related column. Be sure you click the cell for the row you want to edit. Scroll to the far right of the table to access the Photos and Files column. Click Add in the cell for the row to which you want to attach a photo or file. Click Choose Filebrowse to the file you want to attach, and click Open.
Click Upload. When you see the message Upload Successful! In this topic Edit attributes and related records Add related photos and files.When you want to add, delete, or update attribute values, you can use either the Attributes window or the table window.
The Attributes window allows you to view and edit attributes of features you have selected.
Edit feature attributes
You can open it by clicking the Attributes button on the Editor toolbar. While the window can be reoriented, it is vertical by default. The top of the window lists the features you have selected. Features are listed by their display expression and grouped by layer. Use the Fields tab of the Layer Properties dialog box to customize how the fields appear by setting up field aliaseshiding fields, and changing the field order. The bottom of the Attributes window contains two columns: the attribute fields of the layer you are viewing and the values of those attribute properties.
The attribute values that appear depend on what you click in the tree at the top. You can use keyboard shortcuts to navigate the Attributes window and attributes grid.
In the top of the window, use the up and down arrow keys to navigate through the list of selected features and the right arrow key to expand the tree. In the attributes grid, press the up and down arrows to move to the previous and next rows. For fields containing drop-down menus, such as coded value domains or subtypes, press the ENTER key to open the menu.
You can type the first letter of the list item to move to it or use the up and down arrow keys, then press ENTER to choose the value.
You can also edit attributes in the table window. An attribute table window can show you the values for all features in a layer. Editing attributes through the table window also allows you to quickly make changes to several features records at once using the field calculator. Arc GIS Desktop. Editing attributes in the Attributes window Editing attributes in the table window.Technical Support. New and Improved Support App! Learn more. Close and Don't Remind. Back to results. Print Share.
Content feedback is currently offline for maintenance. Please try again in a few minutes. Is This Content Helpful? Back to top. In the Table To Excel window, click Parameters. Click the drop-down menu of Input Table or Browse the folder iconand select the feature layer with the desired attribute table. Click the All supported drop-down menu, select a format. In the Table To Excel tool, click Run. Navigate to the specified folder location in Windows.
In the Copy Rows window, click the drop-down menu of Input Rows or Browse the folder iconand select a desired feature layer. Under Output Tableclick Browse the folder icon. In the Output Table window, specify a folder path for the exported table. In the Name section, specify a name with.
In the Copy Rows window, click Run. In the Contents pane, right-click the desired feature layer, and select Attribute Table to open it. In the Field section of the attribute table, click Copy to copy all the records. Open a new Microsoft Excel file. In the Microsoft Excel file, right-click the A1 cell. Under Paste Optionselect a desired paste option, and paste the records. Save the file. How can we make this better? Please provide as much detail as possible.
Contact our Support Team. Request Case Start Chat. Translation Feedback How can we make this translation better? Get notified about latest updates to this technical article?
Yes No. Do you want to Unsubscribe? Questions or issues with the site? Send Feedback. Please rate your online support experience with Esri's Support website. Below Satisfied. Above Satisfied. What issues are you having with the site?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. These tables are read-only when they are in a map. If you edit this data externally, for example in Excel, you must add the text file to the project again.
Some attributes are not editable in the table. 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. You can also copy and paste values from applications external to ArcGIS Proas described in the Copy and paste values from other applications section below.
Use the Fields view to create, modify, and delete fields. ObjectIDs are necessary for managing data. Non-OID tables contain read-only tabular data that cannot be modified.
To edit non-OID tables, the best practice is to create a stand-alone database table. Additionally, the Table To Table tool gives you control over the output location. For data with spatial information, the XY Table To Point tool creates a new point feature class based on the x- and y-coordinates defined in the table.
For Excel tables, this can be done using the Excel To Table tool. To update an existing database table with information from another application, such as Microsoft Office Excel or Word tables, you can paste a single cell value, values for an entire row, or values of consecutive columns.
Copy the information from the other application that you need to the clipboard. New rows are created if the number of pasted values for a field is greater than the current table row count. Pasted values are also rounded to match the numeric format of the field. For example, pasting 2. If a pasted item is invalid for the field you are editing, a warning appears.It is used for creating and using maps, compiling geographic data, analyzing mapped information, sharing and discovering geographic information, using maps and geographic information in a range of applications, and managing geographic information in a database.
The system provides an infrastructure for making maps and geographic information available throughout an organization, across a community, and openly on the Web. ArcGIS includes the following Windows desktop software:. Extensions can be purchased separately to increase the functionality of ArcGIS. Receiving a certificate in ArcGIS software is also available for professionals from beginners to experts through Esri's training programs.
The various products had branched out into multiple source trees and did not integrate well with one another. In JanuaryEsri decided to revamp its GIS software platform, creating a single integrated software architecture. In lateEsri released ArcMap 8. This ArcMAP incorporating some of the functionality of ArcInfo with a more intuitive interfaceas well as a file management application called ArcCatalog v8. The release of the ArcMap constituted a major change in Esri's software offerings, aligning all their client and server products under one software architecture known as ArcGIS, developed using Microsoft Windows COM standards.
ArcGIS 8. One major difference is the programming scripting languages available to customize or extend the software to suit particular user needs. These models can be executed directly or exported to scripting languages which can then execute in batch mode launched from a command lineor they can undergo further editing to add branching or looping. In Esri announced that the prospective version 9. Older Esri products, including ArcView 3. ArcInfo Workstation handled coverages, which stored topology information about the spatial data.
Coverages, which were introduced in when ArcInfo was first released, have limitations in how they handle types of features. Some features, such as roads with street intersections or overpasses and underpasses, should be handled differently from other types of features. ArcGIS is built around a geodatabasewhich uses an object-relational database approach for storing spatial data. A geodatabase is a "container" for holding datasets, tying together the spatial features with attributes.
The geodatabase can also contain topology information, and can model behavior of features, such as road intersections, with rules on how features relate to one another. With shapefiles, each file can only handle one type of feature. A geodatabase can store multiple feature classes or type of features within one file.
The insides look similar to that of a coverage but is not, in fact, a coverage. Similar to the personal geodatabase, the file geodatabase only supports a single editor. However, unlike the personal geodatabase, there is virtually no size limit.