Enter Interval Data

The Drillhole Data page is where you spend most of your time: logging core, recording assays, capturing whatever interval data your project tracks. It’s a spreadsheet-style interface that should feel familiar if you’ve used Excel.

This page covers everything you can do once a drillhole is open. To create a hole in the first place, see Create a Drillhole.

Open a drillhole

Click any card on the Dashboard. The drillhole page has three areas:

• Left sidebar — the list of data tables defined for this project
• Main spreadsheet — the rows for the currently-selected table
• Right panel (optional) — the Strip Log, toggled with the chart icon in the header

Header actions

The Details panel

Click Details in the header to expand a panel showing every collar field for this drillhole. The fields shown here are defined by your drillhole template — common fields include dip, azimuth, collar coordinates, geologist, dates, and hole status, but your project may have different ones.

To edit any of them, click the Edit (✏) button in the header. To collapse the panel, click Details again.

Switch between tables

The left sidebar lists every data table in the project — Lithology, Assays, Alteration, Geotechnical, Samples, whatever you’ve created. Click a table name to load its rows in the spreadsheet.

The same set of tables appears for every drillhole. Each hole has its own data within those tables.

To get more horizontal space for the spreadsheet, click Collapse at the bottom of the sidebar. To jump to the templates editor, click Edit Templates.

Add and edit rows

The spreadsheet shows the rows for the currently-selected table.

• Depth From / Depth To are pinned on the left if you’ve marked them in Data Tables.
• Other columns appear in the order set in the template.

Add a row

• Click + Add Row above the spreadsheet, or
• Press Ctrl+Enter while in any cell (adds a row at the bottom)

Edit a cell

• Click any cell to select it; type to edit
• Tab — confirm and move right
• Enter — confirm and move down
• Arrow keys — navigate
• Esc — cancel an edit

For the full list, see Keyboard Shortcuts.

Dropdown columns

Cells with a dropdown type show a chevron (∨). Click to pick from the list. Dropdown options are configured in Data Tables.

Formula columns

Cells of type formula are read-only — you can’t type into them directly. Their values recalculate whenever a referenced column changes. See Formula Columns.

Row ordering

Rows can’t be manually reordered. They appear in creation order. Geological ordering comes from your Depth From / Depth To columns — enter rows in depth order as you log, or sort by depth after a bulk import. (Sorting is currently a one-time operation; the displayed order reflects creation, not depth.)

Delete a row

Right-click the row and choose Delete row, or click the 🗑 in the row header. Deletes are local first, then synced — see Offline & Sync.

Validation feedback

Validation runs as you edit. Cells with issues are highlighted:

• Red — error. The row cannot be saved.
• Yellow — warning. The row can save but a toast explains the issue.

The header counter shows the total number of errors and warnings for the current table (e.g., 3 errors · 2 warnings). Click the counter to jump to the first issue.

For step-by-step resolution, see Fix Validation Errors. For the rule reference, see Validation Rules.

Quick CSV export of the current table

The Export button in the top-right of the spreadsheet exports only the currently-selected table as a quick CSV download. Useful when a colleague asks for “just the assays for DDH-001.”

For multi-table, multi-format, multi-drillhole exports — including XLSX and ZIP — use the full Data Export wizard from the Dashboard instead.

Row count

The bottom-left of the spreadsheet shows the total row count for the current table (e.g., 27 rows, 357 rows).

Open the Strip Log alongside

Click the chart icon (Strip Log) in the header to open the strip log panel on the right. It renders interval fills, bar tracks, and text labels at the same depth scale as the spreadsheet, so you can log and visualise side by side. Drag the divider to resize. See Strip Log for configuring tracks.

Tips

• Log in depth order. Because rows display in creation order, logging top-down means the spreadsheet visually matches the hole.
• Use @PREV defaults. If a column rarely changes between rows (e.g., logger name, drilling unit), set the default to @PREV(column_name) in Data Tables — new rows pre-fill from the row above.
• Manual sync after long offline sessions. The 30-second auto-sync usually keeps things current, but if you’ve been offline a while, the manual Sync button gives you an immediate confirmation that everything’s uploaded.