Sheet-Map — Field Guide

Getting in

There are two ways to start using Sheet-Map, and you can switch from one to the other later without losing anything you've entered.

Try it now — no account needed

The fastest way to get going is the Try it now — no account needed button on the account screen. This drops you straight into a working sheet with no sign-up step. Anonymous sessions are capped at 100 items and everything is saved locally in your browser — it's the right choice for a quick look or a one-off exercise, but it won't sync to another device.

Create a free account

If you want your data to save to the cloud and sync across devices — or you're working as part of a team — create a free account instead. Signing up gives you persistent storage, the ability to invite teammates, and an item allowance well above the browser-only anonymous mode. A larger allowance (up to 25,000 items per Sheet-Map) is a Pro upgrade. You can always start anonymous and create an account later; your local work carries over.

The account screen — sign in, sign up, or continue anonymously.

Sheets basics

A sheet is a spreadsheet where each row is a point you can put on the map. Rows have columns just like any spreadsheet, but one of those columns typically holds a coordinate — that's what turns a row into a map point.

A sheet — each row can become a point on the map.

Add a row

Click + Add Row to add a new blank row. It appears at the top of the sheet, and the table resets to show the top. Every row starts empty — you fill in whatever columns matter for that point.

Adding a new row with + Add Row.

Add a column

Click + Add Column to add a new column. You'll be asked to name it and pick a column type: Text, Date (a date-and-time picker — a custom column, distinct from the built-in Date field below), Media (photos & videos), Location (province & district), Grid (MGRS), or Number — picking the right type gives you the matching editor for that kind of data, and a value that doesn't fit the type (an unparseable grid reference, non-numeric text) gets a red border so you can spot it.

A Grid (MGRS) column is a reference coordinate for display and validation only — it never moves the row's map pin or creates a marker. Only the built-in Coordinates column (below) drives where a row shows up on the map.

Every sheet also comes with three built-in columns you don't need to add yourself: Coordinates, Symbol, and Date. They're already there on every row — Add Column is only for extra columns beyond those.

Picked the wrong type, need to move a column, or delete it? A custom column’s header menu (⋮) groups Position (Move Left/ Right), Column Settings, and Delete Column. Column Settings opens a popover with Name, Data Type (Text, Date, Location, Grid (MGRS), or Number — Media can't be changed once created), and Alignment — changing Data Type retypes the column in place, with no re-entry of existing values: an existing text column reassigned to Grid or Number is re-validated immediately, and any values that don't fit the new type pick up the red-border flag.

Naming a new column and choosing its type.

Importing a CSV auto-recognizes genuine date columns by their content, not just a column literally named "date" — a column of real calendar values (e.g. 3/15/2024 or ISO dates) comes in already set to Date and displays them. A column of bare years, IDs, or coordinates is left as Text, and so is a dash-separated day-month column like 15-03-2024 — that order can’t be guessed, so it’s left alone rather than risking a wrong read. You can also assign an existing text column to Date yourself via Column Settings; its values now display as real dates for common formats like M/D/YYYY or ISO.

Column types

Every column you add has a data type, set when you create it or changed later from the column’s kebab menu (⋮) → Column Settings → Data Type. The type decides how a cell is edited, how its value is checked, and which filter control the column gets.

• Text — anything at all. The default.
• Date — a date-and-time picker. Common written forms like 3/15/2024 are shown as real dates. A value that isn’t a date is outlined in red.
• Number — digits only; anything else is outlined in red.
• Grid (MGRS) — a grid reference, checked as you type. This is for reference only: unlike the built-in Coordinates column, a Grid column never moves the row’s pin or creates a marker.
• Location (province & district) — chosen from a picker rather than typed, so every row meaning the same place holds exactly the same value. That is what makes the Breakdown counts below trustworthy.
• Media — photos and videos. Attachments last for the session only.

Changing an existing column’s type re-checks its values immediately, with no re-entry: anything that doesn’t fit the new type picks up the red outline so you can find it. Importing a CSV also guesses Date and Location columns from their content — conservatively, so a column of bare years or ID numbers stays Text.

Filtering a column

Any column can filter the sheet. Open its kebab menu (⋮) → Filter…, or click the small funnel that appears in the header of a column that is already filtering. Each column type offers the control that suits it: a searchable checklist of the values actually present, a contains-search, a from/to range for numbers and dates, or has-a-value / is-empty.

Filtering a text column — tick the values you want to keep.

The Symbol column’s checklist shows the symbols themselves alongside their names, since the sheet cells show only the graphic. Typing in the search box matches the name.

Filtering by symbol — the list shows what the cells show.

Filters from different columns combine: a row must satisfy all of them to stay visible. Each active filter appears as a chip above the table, naming its column and what it keeps, with an × to remove just that one and Clear all to drop the lot. Row numbers keep their true position in the sheet while filtered — they are never renumbered from 1.

Two filters at once — one chip each, removable individually.

Hiding filtered rows on the map

By default a filter changes the sheet only; the map keeps showing everything. Tick Also hide these on the map in the filter popover and that filter’s hidden rows lose their markers too. A note on the map names every sheet currently hiding markers and how many, with a button to bring them back — so points are never missing without explanation.

A location filter hiding its markers, with the map note explaining why.

A filter you have opted into the map stays active when you switch sheets (an ordinary sheet-only filter is cleared when you leave). The header’s total points count is unaffected either way — a hidden row still exists and still counts toward your workspace total.

Location breakdown & filtering

A Location column's header has a Breakdown button that counts rows by province and district. Clicking a province's caret expands or collapses its list of districts without changing what the table shows. Clicking the province or district row itself (not the caret) closes the dialog and filters the sheet table down to just those rows — a province's filter includes all of its districts. A filter bar above the table reads Filtered: <name> — N rows; its Clear button restores every row, and switching sheets also clears the filter automatically. Row numbers keep their true position in the full sheet even while filtered — they're never renumbered starting from 1.

While a filter is active, bulk actions — Apply to column and the header's select-all checkbox — act only on the visible (filtered) rows, so a bulk edit or a Delete Selected can't reach rows the filter is hiding. The filter affects the sheet table only; the map keeps showing everything it already showed.

Fill in a cell

Click any cell to select it, then type to enter or replace its value — the same way you'd edit a cell in any spreadsheet. Your change saves automatically as you type; there's nothing to confirm. Click another cell when you're ready to move on.

Coordinate systems

The Coordinates column understands four coordinate notations: MGRS, UTM, Lat/Long, and DMS (degrees-minutes-seconds). You can type a coordinate in whichever notation is convenient, and Sheet-Map parses it the same way regardless of which one you use.

The coordinate-system control in the header switches which notation is displayed across the whole sheet. This doesn't move or change any point — it's the same underlying location, reformatted. Switch it and every coordinate in the sheet updates in place.

Here is the same row shown in each of the four notations:

MGRS notation.

Lat/Long notation.

UTM notation.

DMS notation.

Same point, four notations — pick whichever one matches how your team reads coordinates, and switch back and forth as needed without ever re-entering data.

Sheet↔Map link

A sheet that's turned on for the map is "broadcasting" — every row with a valid coordinate shows up as a live point on the map. The data flows one way, sheet to map, and the connection stays live: edit a row's coordinate and its point moves on the map immediately, add a row and a new point appears, delete a row and its point disappears.

Moving yourself between the two works in both directions: a row can jump you to its point, and a point can jump you back to its row — see Point detail.

Points from an on-map sheet, live on the map.

There's nothing extra to "sync" — as long as a sheet is broadcasting, the map is always showing its current rows.

Map basics

The Map workspace is where your sheets' points come together on one map. Along the left side, a panel gives you two things: Layers & Annotations, where basemaps and any drawn overlays live, and Sheets on map, the list of sheets currently broadcasting — each with its own visibility toggle, so you can show or hide one sheet's points without turning off the others.

The left panel — Layers & Annotations, and Sheets on map.

This part of the guide covers just enough to get points on the map and control which sheets are visible. Drawing tools, the point detail pane, heatmaps, switching basemaps, the Analysis workspace, and sharing your map with others are all covered in the next part of this guide.

Drawing tools

The map's drawing toolbar lets you sketch directly on top of your sheet data: Point, Line, Polygon, Circle, GRG (gridded reference graphic), and Text. Each tool works the same way — click the tool to arm it, then click (and for shapes, click again to add vertices) on the map to draw. Double-click, or click the starting point again, to finish a line or polygon.

A More menu next to the main tools holds Tactical Symbols — unit and equipment markers you place the same way as any other drawing tool, then configure affiliation and type. Heatmap is not in this menu — it has its own dedicated toolbar button, covered in the next section.

The drawing toolbar and its More menu.

Whatever you draw is an annotation, not a sheet row — it lives on the map itself rather than in a spreadsheet. Annotations are saved with your workspace, so they're still there the next time you open the map; they don't sync into any sheet's rows.

Folders in the Layers panel

Everything you draw, place or import appears in Layers & Annotations. A handful of items is easy to scan; several hundred is not, so annotations can be filed into folders.

All Layers & Annotations at the top is the main list, and anything you have not filed sits there. + New Folder makes an empty one, and a folder’s name can be edited in place. Each folder shows how many items it holds and carries its own visibility toggle, so you can hide or show everything inside it at once — useful for switching a whole import off without touching anything else. Delete Folder deletes the folder and everything in it. It asks you to confirm first, naming the folder and how many items will go, and the deletion cannot be undone. To keep the items, move them out of the folder first (see below).

Folders are a single level. There are no folders inside folders, so a new folder is always a sibling of the existing ones rather than a child of whichever one you happen to be looking at.

Most folders make themselves

Three things create a folder, and only one of them is you:

• A run of the GRG tool files itself. Arm the GRG tool and the points you place go into GRG 1; the next run makes GRG 2, and so on. Numbering continues from the highest run that still exists, so a new run never takes the name of a folder you still have. The match is exact, so a folder you named yourself — GRG notes, say — is never mistaken for a run and never shifts the numbering.
• An import is named after the file it came from. Importing patrol-boundary.kml gives you a folder called patrol-boundary.kml, whatever the file happens to call itself internally. This matters when you re-import something this app exported: naming from the file’s internal document name used to produce a second folder with the same name as the first.
• + New Folder, for everything you want to organise yourself.

Moving things into a folder

For a single item, open it on the map and use the folder dropdown in its detail pane; choosing (No folder) moves it back out to the main list. For many at once, use Select Area on the drawing toolbar, drag a box around the items you want, then pick a folder from the dropdown in the Area Selection box and click Move to folder.

Layers & Annotations with folders — a GRG run that filed itself, and an import named after its source file, each showing how many items it holds.

Measuring distance and elevation

The Ruler tool measures between any two points on the map. Click it in the toolbar, click a start point, then click an end point. The readout shows the straight-line distance and the bearing from the first point to the second, plus the elevation of each point and how much higher or lower the second one is.

Two clicks give distance, bearing, and the elevation of each end.

You can pan the map between the two clicks, so a measurement is not limited to what fits on screen. Over steep ground the readout also shows a slope distance, which accounts for the height difference between the two ends — it appears only when the terrain actually makes a difference to the number. Distances are labelled straight-line: they follow the ground between your two points, not a road or a path.

Bearings read in degrees by default. To work in mils instead, open the coordinate button in the header (the one showing MGRS) and switch Bearing to Mils — NATO convention, 6400 to a circle. That choice is remembered between sessions.

A measurement is scratch work: it is not saved, not shared with teammates, and disappears when you measure again, press Escape, or leave the Map. Nothing is added to your sheets.

Elevation along a route

Any line you draw can show you the terrain along it. Draw a line across the ground you care about, click it to open its details, and choose Load elevation profile. You get a chart of the elevation from one end of the line to the other, so you can see where a route climbs, where it drops, and how steep it gets — without leaving the map.

A drawn line and its elevation profile, with total ascent and descent.

Under the chart you get the total ascent and descent along the route, the highest and lowest points, and a note saying how far apart the samples are. That last figure matters: the profile is measured at a fixed number of points spread evenly along the line, so a short route is sampled every few tens of metres while a very long one is sampled every kilometre or so. Rises and dips smaller than that spacing will not appear.

For the exact numbers, choose Show values to reveal a table of every sample point — its distance along the route, its elevation, the change since the previous point, and the grade as a percentage.

The profile is worked out fresh each time and is not saved with the line. If you move the line or change its shape the old profile is discarded, so you are never looking at a chart of a route you have since changed — just load it again.

Point detail

Click any point on the map to open its detail drawer along the side. The drawer shows that record's fields exactly as they're stored in its sheet — Coordinates, Symbol, Date, and any custom columns you've added, such as a name, a status, or a note.

Clicking a point opens its detail drawer.

This drawer is a read-only view of the underlying sheet row — it's there so you can check a point's details without leaving the map. To change any of the values, use Edit in Sheet at the bottom of the drawer: it takes you straight to that row in its sheet, scrolled to it and briefly highlighted.

Jumping the other way: from a row to its point

The same jump works in reverse. Every row in a sheet has a small map-pin button at its left edge — click it and you land on the Map, zoomed in on that row's point with its detail drawer already open. Between the two buttons you can move back and forth between a row and its point without hunting for either.

Clicking a row's map-pin button jumps to that point, drawer open.

The button is greyed out on any row that has no point to jump to — either because no coordinate has been entered yet, or because the coordinate can't be read. Hover it to see which. Nothing is changed by jumping: it only moves you and the map, so it's safe to use on a workspace you share with others.

One thing worth knowing: if the row's sheet isn't currently switched on for the map, the jump still takes you to the right place, but you won't see a marker there — the app will tell you so, and you can turn the sheet on from Sheets on map to make its points appear.

Heatmap

The Heatmap toolbar button opens the Heatmap panel, where you pick a sheet and click Build to generate a density overlay from that sheet's points — areas with more points glow more intensely, making concentrations easy to spot at a glance.

Building a heatmap from a sheet's points.

A heatmap is additive — it draws on top of your existing markers without hiding, removing, or replacing them. If your sheet's rows change, rebuild the heatmap from the panel to refresh it, and use the panel's toggle to show or hide it whenever you like.

Basemaps

The basemap control lets you swap the map's underlying imagery — for example between satellite, street, and topographic views — to match whatever you're trying to see: satellite for terrain detail, street for roads and place names, topographic for elevation and contours.

Switching basemaps from the map control.

Changing the basemap only changes what the map looks like underneath your points — it never changes your sheet data, your markers, or any drawn annotations.

Analysis workspace

Analysis is a third workspace, alongside Sheets and Map, built for briefing rather than editing. It lays out four quadrants at once: a live map, charts, a plain-language summary, and the underlying source data — everything you need to walk someone through a picture of your data in one screen.

The Analysis workspace — map, charts, summary, and source data.

Start by picking a subject sheet — the sheet whose points the charts and summary are built from. The map quadrant shows whatever the Map workspace is already displaying and highlights the subject's points additively, without hiding or filtering anything else on it. Analysis is read-only: it's a view for presenting what's already in your sheets, not for changing it.

Charting a date column

Set Group by to a Date column and the chart groups records into time buckets rather than treating every timestamp as its own category. Sheet-Map picks the bucket size from your data — by day for a short span, by month or year for a wider one — and says which it chose in a note under the chart, so the axis is never quietly coarsened without telling you. Bars run oldest to newest, and any records with a missing or unreadable date collect into a single (undated) bucket at the end instead of disappearing from the count.

Grouping by a Date column — one bar per day, with the bucket size stated under the chart.

This works with dates that arrived by import as well as ones you typed. A column of dates recognized during import becomes a real Date column, so it can be charted this way without any extra setup, and the Line chart type becomes available for it too.

Sharing a workspace

The Team members & sharing dialog is laid out in four parts: who already has access, inviting someone by email, invitations still waiting to be accepted, and a shareable invite link — plus a one-line summary at the top ("3 people have access · 1 pending invitation") so you always know where things stand at a glance.

Every person in the workspace has one of three roles — Owner (full control; there's exactly one, and it isn't transferable from this dialog), Member (can edit — adds and changes data alongside you), or Viewer (read-only — can see the workspace but not change it). As the Owner, you can change any other member's role from the dropdown next to their name, or remove them, right from the People with access list.

The Owner and Members can both invite teammates, in two ways: an email invite sent directly from Sheet-Map, or an invite link you paste anywhere — chat, email, wherever your team already talks. Viewers can't invite anyone. The invite link's role defaults to Viewer, the least-privileged option, since a link is the easier of the two credentials to accidentally share with the wrong person; pick Member instead if you mean to hand over edit access. Managing invitations is the Owner's alone: only the Owner sees Pending invitations, where an email invite waits until it's accepted (with its own Revoke button if you change your mind), and only the Owner can disable an active link at any time. A Member can copy and share the link, but not switch it off.

The Team members & sharing dialog — People with access, Invite by email, Pending invitations (with Revoke), and the Invite link (defaulting to Viewer).

Inviting teammates requires a free account. An anonymous, browser-only session has no team to invite anyone into — it's local storage for you alone. Create a free account (your local work carries over) when you're ready to share a workspace with others.

Team chat

Each workspace has one chat channel, shared by everyone in it. It is for the running commentary that does not belong in a cell — what changed, what to look at, what to ignore — kept beside the map instead of in a separate app.

Open it with the speech-bubble icon. In the Map workspace it sits just above the zoom control; in Sheets and Analysis it sits in the bottom-right corner. It is the same conversation in all three, so switching workspace never loses your place.

The panel opens as a column beside your work, not on top of it. The sheet, map or Analysis quadrants narrow to make room, so nothing you were reading is covered, and the details drawer can stay open alongside it.

Reading a conversation

Your own messages sit on the right; everyone else’s on the left. Each teammate’s name keeps the same colour for everyone — it is derived from their account, not assigned per session, so the colour you see beside a name is the colour your teammates see too. Messages arrive live, and if the connection drops and recovers, the panel re-reads the conversation rather than leaving a silent gap.

A number on the icon counts messages that arrived while the panel was closed. It clears when you open it.

Writing, editing and deleting

Enter sends; Shift+Enter starts a new line. The box grows as you type and shrinks back when it is cleared. You can edit or delete your own messages: editing happens in the message itself, not in a pop-up box, so you can still see the conversation around it — Enter saves, Escape abandons. An edited message is marked as edited, and a deleted one leaves a short placeholder rather than vanishing silently, so a conversation never rearranges itself under someone mid-read.

Viewers can post. Read-only access applies to the data — sheets, rows and map objects — not to the conversation, so someone at a dispatch desk who cannot change a single cell can still tell the team what they are seeing. Chat messages do not count towards your workspace’s item limit.

Team chat open in the Map workspace. The panel is a column, so the map narrows beside it rather than being covered; your own messages sit right, teammates’ left, each name in its own colour. The icon sits just above the zoom control.

The header menu

The ☰ icon in the header opens the workspace menu — controls for the current Sheet-Map workspace and your account, not export or invites. Depending on how you're signed in, it can hold: Copy local data to this Sheet-Map (folding anonymous local work into a real workspace), Rename this Sheet-Map, Create a free account (anonymous sessions only), Leave this Sheet-Map, Delete this Sheet-Map, Appearance (toggles light/dark theme), and Log Out — plus a build-number stamp at the bottom.

The header menu (☰).

Which items appear depends on how you're signed in — Rename and Delete appear only for the workspace's Owner, and Create a free account only shows up for anonymous sessions. Exporting and inviting live elsewhere: CSV export is in each sheet tab's own menu, KMZ export is in each map overlay's own menu, and Invite is its own always-visible button in the header next to the workspace selector — none of them are in this menu.

On a phone

Sheet-Map is laid out separately for phones — not the desktop screen shrunk down. The same data and the same workspaces, arranged so the grid and the map get the screen instead of the toolbars.

Getting around. The control in the middle of the header — the one showing MGRS, UTM or Lat/Lng — opens one menu with two sections: Workspace (Sheets, Map, Analysis) above Coordinate system. The ☰ menu at the top right is unchanged and still holds the workspace and account controls.

In a sheet. The sheet tabs become a single selector that names the sheet you are in; tap it to switch. Add Row and Add Column stay in the open, and the ⋮ button beside them holds New Sheet, Import, Add to Map and the map-label picker. Delete Selected appears as soon as you tick a row and is out of the way the rest of the time. Nothing is removed on a phone — it moves into a menu.

On the map. Pinch zooms the map, and only the map: the interface itself never changes size, so nothing has to be panned back into place. The Layers panel and a point’s details slide over the map instead of squeezing it, and swipe back or tap the arrow to close. Press and hold anywhere on the map for the same menu a right-click gives on a desktop.

A note on big sheets. A phone shows 150 rows at a time against 500 on a desktop, and the pager under the toolbar says which rows you are looking at — “Rows 1–150 of 634”. That keeps a large sheet responsive on phone hardware; use Next and Prev, or the column filters, to reach the rest.

Changelog

• v1.19 · 2026-10-01 — Corrected: Sharing a workspace said "an admin can disable" the invite link, but the app has no role called admin: that control is the Owner's alone, as are Pending invitations, Revoke, and changing or removing members. Members can invite and copy the link but not disable it; Viewers can't invite. The header menu likewise now says Rename and Delete appear only for the Owner, not "admin-only".
• v1.18 · 2026-10-01 — Corrected: Delete Folder deletes the folder and everything in it, after a confirmation naming the count (the guide said it removed only the folder, which had not been true since the folder-delete change). Corrected the GRG numbering claim: a new run never takes the name of a folder that still exists, but deleting the newest run does free its number. Replaced the account-screen screenshot, which had been showing a sheet instead of the sign-in screen since v1.17.
• v1.17 · 2026-09-29 — Added: an On a phone section. Phones now get their own layout rather than a shrunken desktop one — the workspace buttons moved into the centre header menu, the sheet tabs became a selector that names the current sheet, secondary actions folded into a ⋮ menu, panels slide over the map, and pinch zooms the map without ever resizing the interface. Also notes the 150-row phone window and its pager. Desktop and tablet are unchanged.
• v1.16 · 2026-09-20 — Added: a Team chat section. Each workspace now has one shared channel, reachable from Sheets, Map and Analysis; it opens as a column beside your work rather than over it, own messages sit right and teammates’ left with a stable per-person colour, editing happens in the message itself, and viewers can post even though they cannot change data.
• v1.15 · 2026-09-16 — Added: a Folders in the Layers panel section. Annotations can be filed into folders, and most folders now make themselves — a run of the GRG tool files itself into "GRG 1", "GRG 2" and so on (numbered from the highest existing run, so deleting one never re-issues its name), and an import is named after the file it came from rather than the name stored inside it. Documents the single-level structure (no folders inside folders), the per-folder visibility toggle and item count, and both ways to move things in: the detail pane’s folder dropdown for one item, and Select Area → Move to folder for many at once.
• v1.14 · 2026-09-10 — Added: Jumping the other way: from a row to its point in the Point detail section. Every sheet row now carries a map-pin button that jumps to the Map, zoomed on that row's point with its detail drawer already open — the mirror of the drawer's existing Edit in Sheet. Documents the greyed-out state for rows with no readable coordinate, and what happens when the row's sheet isn't switched on for the map. Also clarified Sheet↔Map link: the data flows one way, but navigation now genuinely goes both ways.
• v1.13 · 2026-09-09 — Updated: Sharing a workspace rewritten for the redesigned Team members & sharing dialog — People with access, Invite by email, Pending invitations (with per-invite Revoke), and a separate Invite link section whose role now defaults to Viewer. Role terminology is now consistently Owner/Member/Viewer, and members' roles can be changed in place from the People with access list.
• v1.12 · 2026-09-09 — Updated: Sharing a workspace now includes a screenshot of the Team dialog, showing every member's role (admin, member, viewer) labeled in the members list.
• v1.11 · 2026-09-08 — Added: an Elevation along a route section. Any drawn line can now show an elevation profile chart for its full length, with total ascent and descent, high and low points, the sample spacing, and an optional table of every sample point (distance, elevation, change, grade). The profile is recalculated on demand and discarded if the line's shape changes.
• v1.10 · 2026-09-07 — Added: a Measuring distance and elevation section for the new Ruler tool (two-click distance, bearing, per-point elevation, the relative height statement, and the slope distance shown over steep ground), plus the degrees/mils bearing preference. Also: the topographic basemap is now labelled Topographic (OpenTopoMap) rather than just "Terrain".
• v1.9 · 2026-09-07 — Added: Charting a date column to the Analysis section. Setting Group by to a Date column now buckets records by day, month or year (chosen from the span and stated in a note under the chart) instead of treating every timestamp as its own category; bars run oldest to newest, blank or unreadable dates collect into a single (undated) bucket, and the Line chart type is now available for sheets whose dates live in an imported Date column.
• v1.8 · 2026-09-07 — Added: a Column types section covering all six types (Text, Date, Number, Grid, Location, Media), how to change a column’s type and what re-validates when you do; a Filtering a column section covering the filter popover and its per-type controls, the Symbol checklist showing the symbols themselves, chips for multiple simultaneous filters, and the funnel marking a filtered column; and Hiding filtered rows on the map, covering the opt-in map toggle, the map note that explains hidden markers, and the fact that a map-enabled filter survives a sheet switch while a sheet-only one does not. Four new screenshots.
• v1.7 · 2026-09-06 — Added: a Location column's Breakdown button lets you click a province or district to filter the sheet table to just those rows (a filter bar shows the count and a Clear button); the caret still expands/collapses without filtering, row numbers keep their true position while filtered, switching sheets clears the filter, and bulk actions (Apply to column, select-all) act only on visible rows while a filter is active. The map is unaffected by this filter.
• v1.6 · 2026-09-06 — Added: two new assignable column types, Grid (MGRS) and Number, to both Add Column and the Column Settings Data Type list. Both validate on typing and show a red border on an unparseable value (a grid reference that doesn't parse, or non-numeric text in a Number column); reassigning an existing text column to either type re-validates its values immediately with no re-entry. A Grid column is a reference coordinate for display/validation only — it never moves the row's map pin or creates a marker, unlike the built-in Coordinates column.
• v1.5 · 2026-09-06 — Added: CSV import now auto-recognizes genuine date columns by their content, not just a column literally named "date" (bare years, IDs, and coordinates stay Text; a dash-separated day-month column like 15-03-2024 stays Text too, since the order can’t be guessed). Assigning an existing text column to Date via Column Settings now displays its values as real dates for common formats (M/D/YYYY, ISO).
• v1.4 · 2026-09-06 — Updated: column-types list now includes Date (a custom date+time column, distinct from the built-in Date field) in both Add a column and the Column Settings Data Type description.
• v1.3 · 2026-09-06 — Updated: column kebab note now describes Column Settings (Name / Data Type / Alignment) plus Position and Delete Column, replacing the old 'Type: Text' / 'Type: Location' wording.
• v1.2 · 2026-09-06 — Added: column kebab 'Type: Text' / 'Type: Location' note under Add a column.
• v1.1 · 2026-09-05 — Added: drawing tools, detail pane, heatmap, basemaps, Analysis, invites, hamburger menu.
• v1.0 · 2026-09-04 — Initial guide: login, Sheets, coordinate systems, Sheet↔Map, map basics.