This walkthrough takes you from a brand-new account to a logged drillhole exported as CSV. We’ll set up a fictional project — Golden Ridge — define a small schema, create one hole (DDH-001), log a handful of lithology and assay intervals, and export the result. About fifteen minutes start to finish.
If you only read one doc, read this one. Everything else fills in detail around the workflow described here.
1. Sign up
Open Blue Butterfly in your browser. You’ll land on the sign-in screen.
- Click the Sign Up tab.
- Enter your email and a password.
- Tick I agree to the End User License Agreement — the Sign Up button stays disabled until you do.
- Click Sign Up. You’ll be redirected to the Dashboard.
The EULA checkbox only appears during account creation. On subsequent sign-ins, just enter your email and password.
2. Install the app (optional but recommended)
Blue Butterfly works as a Progressive Web App, which means you can install it like a native application — useful in the field, where you may want it pinned to your taskbar or home screen.
- Desktop (Chrome / Edge): click the install icon (⊕) in the address bar.
- iOS (Safari): Share → Add to Home Screen.
- Android (Chrome): ⋮ menu → Install App.
See Install as an App for details. You can come back to this later — it isn’t required to follow the rest of the walkthrough.
3. Create the Golden Ridge project
You’ll land on the Dashboard with a prompt to create your first project.
- Click Create Blank Project.
- Enter the name:
Golden Ridge. - Click Create Project.
A blank project opens. The dashboard is empty — no drillholes yet, no schema yet. That’s the next step.
Tip. If a colleague has already shared a template JSON file from another project, you can use Import a Template instead and skip most of step 4. See Drillhole Template for how template sharing works.
4. Set up the schema
The schema has two parts: drillhole template (collar fields that apply to every hole) and data tables (the interval tables you’ll log into).
Click the settings gear (⚙) in the top-right and choose Templates.
Drillhole Template
This defines the collar-data fields that appear on every drillhole. Click the Drillhole Template tab. The name field is already there as a system field.
Add four more fields by clicking + Add Field for each:
| Name | Type | Notes |
|---|---|---|
easting | number | Required |
northing | number | Required |
elevation | number | Required |
geologist | text |
Drag the ⠿ handle to reorder if needed. See Drillhole Template for the full list of field options (validation rules, default values, depth markers, etc.).
Data Tables
Click the Data Tables tab. We’ll create two tables: one for lithology, one for assays.
Click + Create Table and name it Lithology. Add these columns:
| Name | Type | Marker |
|---|---|---|
depth_from | number | Depth From |
depth_to | number | Depth To |
rock_type | dropdown | — |
description | textarea | — |
For rock_type, click into the column card and add dropdown options: Granite, Basalt, Schist, Sediment. Mark depth_from as Depth From and depth_to as Depth To in their column cards — this pins them to the left of the spreadsheet and enables depth-interval validation.
Now click + Create Table again and name it Assays. Add these columns:
| Name | Type | Marker |
|---|---|---|
depth_from | number | Depth From |
depth_to | number | Depth To |
sample_id | text | — |
au_g_t | decimal | — |
interval_m | formula | — |
For interval_m, set the formula to depth_to - depth_from. This auto-calculates the interval thickness for every row. See Formula Columns for the full syntax.
You’re done with setup. Click out of Templates back to the Dashboard.
5. Create your first drillhole
From the Dashboard, click + New Drillhole. Fill in:
| Field | Value |
|---|---|
| name | DDH-001 |
| easting | 500123 |
| northing | 6712450 |
| elevation | 425 |
| geologist | your name |
Click Save. DDH-001 now appears on the Dashboard. Click the card to open it.
6. Log three lithology intervals
You’re now on the Drillhole Data page. The left sidebar lists Lithology and Assays. Click Lithology.
The spreadsheet is empty. Click + Add Row (or press Ctrl+Enter). Enter:
| depth_from | depth_to | rock_type | description |
|---|---|---|---|
0 | 12.5 | Sediment | Overburden, weathered |
12.5 | 45.0 | Granite | Coarse-grained, biotite-rich |
45.0 | 78.2 | Schist | Foliated, garnet porphyroblasts |
Tab between cells. Press Enter to confirm and drop down a row. For rock_type, click the chevron to pick from the dropdown. See Keyboard Shortcuts for the full list.
7. Log two assay intervals
Click Assays in the sidebar. Add two rows:
| depth_from | depth_to | sample_id | au_g_t | interval_m |
|---|---|---|---|---|
30.0 | 31.0 | GR-0001 | 1.42 | (auto) |
31.0 | 32.0 | GR-0002 | 2.18 | (auto) |
The interval_m column is greyed out — it’s a formula column and recalculates automatically. You can’t type into it directly.
8. Export to CSV
Click ← Back to Dashboard and then Export Data in the header. The 5-step wizard opens.
- Select Drillholes — tick
DDH-001. - Template Fields — tick all five collar fields.
- Tables & Columns — tick
LithologyandAssaysand all their columns. - Configure Sheets — leave defaults.
- Preview & Export —
- Format: XLSX
- Output Mode: Standard
- File Mode: Single File
- Click Export.
You’ll get an .xlsx file with three sheets: collar data, lithology intervals, and assay intervals. Open it in Excel or your tool of choice.
If you’d like to deliver this same export weekly, tick Save Workflow before exporting and give it a name. See Export Workflows.
What’s next
You’ve now done the core loop: set up → log → export. From here:
- Add more holes. Either manually via + New Drillhole, or in bulk by importing collar data — see Import Drillholes.
- Bring in legacy data. If you have historical assay or lithology CSVs, see Import Interval Data and Import a Workbook.
- Visualise. Open the Strip Log panel on a drillhole, or open the 3D Viewer from the Dashboard.
- Share with your team. Add collaborators in Project Settings.
- Tighten your schema. Add validation rules so bad data is caught at entry — see Validation Rules.