Attribute Table on iPhone and iPad: Filter, Edit, Summarize and Export to Excel (CSV)

Everything you do with a layer's table in desktop GIS, on the device you carry: select by attributes, edit cells, change hundreds of features in one step, total a field and send the result to a spreadsheet.

Every GIS layer is two things: shapes on a map, and a table about them. GoGIS gives that table the room it deserves on an iPhone or iPad. You can find the features you need, fix their values in the field, change a whole set at once with an Undo behind you, and hand the result to someone who works in Excel.

This guide goes through the attribute table one task at a time. In the app it's Attribute Table on the layer menu, and the Help calls it the Attribute Grid. The pictures show a sample inventory of 86 park trees, imported from a GeoJSON file.

GoGIS on iPad: park trees on the map colored by condition, with the attribute table docked underneath, filtered to trees in Poor condition and sorted by trunk diameter
The map and its attribute table on iPad, filtered to trees in Poor condition and sorted by trunk diameter. Sample data.

What an Attribute Table Is

Each row is one feature: one tree, one parcel, one culvert. Each column, which GIS calls a field, holds one fact about every feature, such as its species, its owner or, here, its trunk diameter in centimeters (dbh_cm). A few rows of the tree inventory look like this:

tree_idspeciesconditiondbh_cmheight_mactioninspected
GGP-1001Blue Gum EucalyptusPoor13926Prune2025-07-27
GGP-1004Monterey CypressGood12327None2026-04-06
GGP-1008Victorian BoxFair397Monitor2025-01-09

The person who made the file chose the columns, so every table is different. If the idea is new to you, New to GIS files? explains features, attributes and the formats that carry them.

Two Ways to Open It

Long tables come 100 rows to a page. Your filters, sort and lock are still there when you close the table and open it again.

Filter and Select by Attributes

Under every column heading is a filter. Tap its small operator badge to choose how it compares. There are ten operators: contains, equals, not equal, starts with, ends with, greater than, less than, between, empty and not empty. Pick-list columns and the Layer column give you a list of their values to tick instead, and date columns get a date picker.

That is select by attributes. Filter the table to the features you mean, then tap Select and All, the button that shows the number of matches (for example All 86), to take every matching row, ready for the next step.

Edit Cells Like a Spreadsheet

Tap any editable cell and change it where it is. The editor fits the field:

The layer's field rules still apply. A value the form wouldn't accept, such as a blank in a required field, is refused with the reason, so the table can't be used to slip bad data past the form.

Change Many Features at Once, and Undo

When a whole set of features needs the same value, don't edit them one at a time:

  1. Tap Select, then check the rows you want, or tap All with the match count, for example All 86, to take every row that matches your search and filters.
  2. In the bar at the bottom, choose the column after Set.
  3. Enter or pick the value after to, then tap Apply.

Every selected feature changes in one go. If the field's rules refuse the value on some rows, those rows are left as they were and the table tells you how many and why. The same Select mode can also Delete the selected features. Tap Done to leave it.

Select mode in the GoGIS attribute table on iPad: four rows checked and the bar at the bottom set to change the action column to Remove for the selected trees
Select mode: the four biggest trees in Poor condition checked, and their action column about to be set to Remove.

After a cell edit, a change to many rows, a photo change or a delete, an Undo button appears for a moment. It takes back the last change in one step, however many features it touched. It's one step back, not a full history. While a big change, Undo or delete is being written, the table shows Updating… and holds still until it's done, and a large Undo counts the features it restores.

The GoGIS attribute table on iPad after Apply: the four selected trees now show Remove in the action column, with the message Updated 4 features and an Undo button
After Apply: the change is saved, and Undo takes it back in one step.

Calculated Fields That Update Themselves

GoGIS isn't a spreadsheet you type formulas into, cell by cell. You give a field a formula once, and the app keeps that column right on every feature from then on. That's what a calculated field, or a field calculator column, is for.

To set one up, tap the layer's …, open Base Attributes, and tap f(x) on the field. A formula can add, subtract, multiply or divide other fields, take their sum, minimum or maximum, join text, count the days between two dates or since a date, or follow a custom formula. It can read the feature's own fields and the latest entry of a related form. The custom forms guide shows the formula editor step by step.

Then the table does the work. After a cell edit, or after a Set across a selection, every formula column on the changed rows is recalculated and saved. That holds for a change to thousands of rows at once too: each formula column is written in a single pass, not row by row. Undo puts the calculated values back along with the values you changed.

A few rules make the results predictable: a blank input counts as 0, dividing by zero gives a blank, and a formula refers to fields by their internal name, so renaming a field's label doesn't break it.

Summary Statistics for a Column

Press and hold the heading of a number column and choose Summarize. A bar under the table shows the sum, average, minimum and maximum of that field, with the number of rows. The figures cover the rows you're looking at, so they follow your search and filters as you change them. Filter to one species and you have its average diameter.

Column summary in the GoGIS attribute table on iPad: sum, average, minimum and maximum trunk diameter of the filtered trees
Summarize on dbh_cm for the 21 trees in Poor condition: sum 1,318, average 62.76, minimum 20, maximum 149.

The same heading menu styles the map. Color Map by This Column colors a number field in five classes from yellow to red, or gives each value of a text field its own color, up to 30 values. Label Map with This Column writes the value beside each feature. Both make an ordinary legend or label that you can adjust later in Layer Style. They're on tables opened from a single layer.

Hide Columns, Move or Copy Features to Another Layer

Export the Attribute Table to CSV and Excel

The CSV button (the small table icon) exports the table as you see it:

Excel, Numbers and Google Sheets open the CSV directly, so this is how you get a shapefile's attribute table into Excel, or a KML into Excel, from an iPhone. Filter first and the spreadsheet holds just the rows you need. On a related-form tab, the button exports that tab's entries the same way. For a layer of more than 50,000 features, search or filter first: the CSV button exports the matching set.

When the shapes have to go too, export the layer itself as a Shapefile, GeoPackage, GeoJSON, KML or CSV from the layer's menu.

Shapefile, GeoPackage and KML Attributes

Looking for a DBF viewer on a Mac? GoGIS runs on Macs with Apple silicon, and opens a shapefile's attribute table there the same way: see GIS software for Mac.

Map and Table Side by Side on iPad

On iPad, the attribute table opens under the map, so you can work with both at once:

If the window is too narrow, for example in Split View, the table opens full screen and moves back under the map when there's room again.

On iPhone

On iPhone, the table opens full screen, with the same filters, editing, Select and column summary. A row's zoom button closes it, zooms the map to that feature and opens its attributes.

The GoGIS attribute table full screen on iPhone, with one filter on and the sum, average, minimum and maximum of the dbh_cm column for the 21 matching trees at the bottom
On iPhone: the same filter and column summary, full screen.

Questions

Can I edit a shapefile's attribute table on an iPhone without a computer?

Yes. Open the shapefile's ZIP in GoGIS from Files, email or AirDrop, then open its attribute table and tap a cell to change it, or change many rows at once with Select. When you're done, export the layer as a shapefile, with a new .dbf, and share it. No computer is involved at any step.

Can I open the attribute table in Excel?

Yes, as a CSV. The CSV button in the attribute table exports every row that matches your search, filters and sort, with the columns you have showing, in their order. Excel, Numbers and Google Sheets open it directly.

Does the attribute table work offline?

Yes. Your layers are stored on the iPhone or iPad, so searching, filtering, editing, summarizing and exporting to CSV need no connection. Only the basemap behind the map needs a connection, or a download made beforehand: see offline maps for fieldwork.

Can I change one field for many features at once?

Yes. Tap Select, check the rows you want or tap All, which shows the number of matching rows (for example All 86), to take every row that matches your filters, choose a column, enter the value and tap Apply. Every selected feature changes together, and Undo takes the whole change back in one step.

Can a column calculate itself?

Yes. Give the field a formula once, with the f(x) button in the layer's Base Attributes, for example a total from two other fields or the days since a date. After that, the table recalculates it on every row you change, including a change to thousands of rows at once.

Related Guides

Work with your attribute tables in the field

GoGIS for iPhone, iPad, Macs with Apple silicon, and Android.

Get GoGIS on the App Store Get GoGIS on Google Play

Ready to try it?

No subscription. No account. Just download and go.

Get it on the App Store Get it on Google Play