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:
| Control | Description |
|---|---|
| + Add field | Create a new column in your dataset |
| Filter | Show only rows matching specific criteria |
| Search | Find values across all columns |
| Export | Download the data in various formats |
Working with Columns
Column Header Menu
Click any column header to access these options:
| Option | Description |
|---|---|
| Sort ascending | Sort the table A→Z or smallest to largest |
| Sort descending | Sort the table Z→A or largest to smallest |
| Edit column | Modify field name, type, or settings |
| Delete column | Remove the field from your dataset |
Adding Columns
- Click + Add field in the toolbar
- Select the field type (Text, Number, Date, etc.)
- Configure field settings
- 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
- Select the row(s) you want to delete
- Press Delete or Backspace
- Confirm the deletion
Editing Data
Editing Cells
- Click on any cell to select it
- Start typing to replace the value, or double-click to edit
- 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:
- Click the column header
- 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:
- Click Filter in the toolbar
- Select a field to filter by
- Choose a condition (equals, contains, greater than, etc.)
- Enter the filter value
- 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:
| Aggregation | Applies to | Description |
|---|---|---|
| Sum | Number fields | Total of all values |
| Average | Number fields | Mean of all values |
| Min/Max | Number, Date fields | Smallest/largest value |
| Count | All fields | Number of non-empty values |
| Unique values | All fields | Number 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