Atlas logo
⌘K

Documentation

Getting Started
Data
Maps
Builder
Workflows
Forms
Sharing & Collaboration
Projects & Management
Connections

Data Table

View and edit your dataset in a spreadsheet-like interface

The Data Table provides a spreadsheet-like view of your dataset's attributes. View, edit, sort, and filter your data directly within Atlas.

Opening the Data Table

Access the Data Table in several ways:

  • Click the three-dot menu (⋮) on a layer and select Data table
  • Double-click a layer in the Layers panel
  • Select a feature on the map and click Open in table

Table Interface

The Data Table displays your data in rows (records/features) and columns (fields/attributes).

Header row: Shows field names and data type indicators. Click any column header to access column options.

Data rows: Each row represents a feature in your dataset. Click any cell to view or edit its value.

Footer row: Displays aggregations for each column (Sum, Unique values, etc.) based on the current selection or filter.

Table Controls

The toolbar at the top right provides quick access to common actions:

ControlDescription
+ Add fieldCreate a new column in your dataset
FilterShow only rows matching specific criteria
SearchFind values across all columns
ExportDownload the data in various formats

Working with Columns

Column Header Menu

Click any column header to access these options:

OptionDescription
Sort ascendingSort the table A→Z or smallest to largest
Sort descendingSort the table Z→A or largest to smallest
Edit columnModify field name, type, or settings
Delete columnRemove the field from your dataset

Adding Columns

  1. Click + Add field in the toolbar
  2. Select the field type (Text, Number, Date, etc.)
  3. Configure field settings
  4. Click Create

See Data Table Fields for details on available field types.

Reordering Columns

Drag column headers left or right to reorder columns. The new order is saved automatically.

Resizing Columns

Drag the edge of a column header to resize. Double-click the edge to auto-fit the column width to its content.

Working with Rows

Zoom to Feature

Click the Zoom link in the first column to pan and zoom the map to that feature's location.

Selecting Rows

  • Click a row to select it and highlight the feature on the map

Adding Rows

Use the Drawing Tools to create new features directly on the map.

Deleting Rows

  1. Select the row(s) you want to delete
  2. Press Delete or Backspace
  3. Confirm the deletion

Editing Data

Editing Cells

  1. Click on any cell to select it
  2. Start typing to replace the value, or double-click to edit
  3. Press Enter to save, or Escape to cancel

Copy and Paste

  • Ctrl/Cmd + C to copy selected cells
  • Ctrl/Cmd + V to paste values
  • Paste works across multiple rows and columns

Sorting

Sort your data by any column:

  1. Click the column header
  2. Select Sort ascending or Sort descending

To remove sorting, click the column header and select the opposite sort direction, or refresh the table.

Filtering

Filter rows to show only data matching specific criteria:

  1. Click Filter in the toolbar
  2. Select a field to filter by
  3. Choose a condition (equals, contains, greater than, etc.)
  4. Enter the filter value
  5. Click Apply

Multiple Filters

Add multiple filter conditions:

  • AND - All conditions must be true
  • OR - Any condition can be true

Clearing Filters

Click the X on individual filter badges, or click Reset to remove all filters.

Aggregations

The footer row shows automatic aggregations for each column based on your current view or selection:

AggregationApplies toDescription
SumNumber fieldsTotal of all values
AverageNumber fieldsMean of all values
Min/MaxNumber, Date fieldsSmallest/largest value
CountAll fieldsNumber of non-empty values
Unique valuesAll fieldsNumber of distinct values

Click on an aggregation to cycle through available options for that column type.

Map Integration

The Data Table and map are synchronized:

  • Selecting rows highlights corresponding features on the map
  • Selecting features on the map highlights corresponding rows in the table
  • Zoom links navigate the map to individual features
  • Filtering the table also filters visible features on the map

Tips

  • Pin important columns by dragging them to the left side of the table
  • Use filters to focus on specific subsets of your data
  • Check aggregations for quick statistics without formulas
  • Sort before editing to group similar records together
PreviousGeocodingData
NextGeoreferencingData