Work with tables

You can display an interactive table at the bottom of a map to see information about features or records in a layer. Seeing a tabular view of the data can be a quick way to analyze information and start making decisions. You can sort and filter the attribute data and hide fields to focus on specific data.

You can also access information about each field in the table to understand what the data represents, and get more information about the layer by viewing related data tables, photos, or other file attachments. If you have privileges to edit the layer, you can edit or delete attribute values.

Learn more about editing attributes

Show a table

Showing tables can be a useful way to see the information associated with the feature and table layers in a map.

Complete the following steps to show a table for a feature layer or table layer:

1. Open a map in Web Editor.
2. On the Contents (dark) toolbar, do one of the following:
   • Click Layers to show the feature layers on the map.

     You can also use the Alt+Shift+L shortcut for Windows or Option+Shift+L shortcut for Mac.

   • Click Tables to show the tables on the map.

     Note:

     The Tables pane is only available if the map includes one or more table layers.

   The Layers pane or Tables pane appears.

3. Click Options next to a layer or table.
4. Click Show table.

   The table appears at the bottom of the map.

5. Click Close in the table header to close the table.

Sort a column

Sorting a column can help you explore the data in the table or find rows that need to be edited.

To sort a column, click the arrows in the column header once to sort ascending or twice to sort descending. Click the arrows a third time to remove sorting for the column.

Alternatively, click Menu in the column header and choose Sort ascending or Sort descending .

Show or hide columns

If a dataset contains fields that aren't necessary for your current work, you can hide them from view.

Hiding or showing columns only applies to the table and does not affect which fields are visible in the Attributes pane. Hidden columns are shown again when a table is closed and reopened.

To show or hide columns, complete the following steps:

1. Follow the steps to show a table.
2. On the table header, click Show/hide columns .
3. Check or uncheck the check box for columns you want to show or hide, respectively.

Reorder columns

To reorder columns in a table, click and drag the column header into a new position.

Reordering columns in a table does not affect the field order in the dataset. The columns return to the default order if the table is closed and reopened.

Work with table selections

Features selected on the map are also selected in the table and vice versa. The following options are available from the selection menu in the table header when one or more features are selected:

• Clear selection deselects all features from the map and table.
• Zoom to selection zooms the map to the extent of the selected features.
• Show selection temporarily hides all unselected rows from the table view. You can click Show all to make all rows visible.