Export Data is the wizard you use when someone asks for “the assays for the project” or “a full drill data dump for the modeller.” Five steps: pick the holes, pick the collar fields, pick the tables and columns, configure how sheets are arranged, choose a format and download.
If you’re going to run the same export repeatedly, save it as a Workflow at the end.
Open the export wizard
From the Dashboard, click Export Data.
For a quick CSV of just the current table on a single drillhole, use the Export button in the spreadsheet header instead — see Enter Interval Data.
Step 1 — Select drillholes
A checklist of every drillhole in the project. Tick the ones you want to include.
- All / None buttons toggle the whole list
- Search narrows by name
- The counter shows your current selection (e.g.,
12 / 47 selected)
Step 2 — Template fields
Pick which collar fields to include. These come from your drillhole template. Optional: rename a column header for the output file (e.g., easting → Easting (UTM)) without changing the underlying field name.
Tick fields you actually need. Including everything bloats the output unnecessarily.
Step 3 — Tables and columns
For each data table in your project, choose which columns to include. Tick the table to include it; tick individual columns within. Reorder columns if needed.
If you only need lithology, untick everything else. If you need everything, All at the table level handles that.
Step 4 — Configure sheets
For XLSX exports, this step controls the sheet layout. Each output sheet can be named and arranged independently. For CSV exports, this step is mostly cosmetic.
The big decision here is output mode (set in step 5 but visible here):
- Standard — one row per interval; collar fields stay in their own collar sheet
- Merged — collar fields are repeated on every interval row (alongside the interval data). Many GIS and 3D modelling packages need this flat-table layout
If you’re not sure which to pick, Standard is more compact and Merged is more universally compatible.
Step 5 — Preview & export
A preview shows the first rows of the export so you can spot mistakes before downloading. Set the output options:
Format
- CSV — comma-separated text. Simple, universal, one type of data per file.
- XLSX — Excel workbook. Multiple sheets in a single file.
Output mode
- Standard — one row per depth interval. Collar fields are separated into their own collar sheet (or collar file in CSV).
- Merged — collar fields are joined to every interval row. Useful when downstream software (GIS, 3D modelling) expects a flat table.
File mode
- Single File — everything in one
.xlsx(multiple sheets) or one.csv(concatenated, less useful) - ZIP — each table as a separate
.csvfile, packaged into a single.ziparchive
Note. ZIP is a file mode, not a format. You still pick CSV or XLSX as the format; ZIP just controls whether you get one file or many.
Click Export to download.
Save as a workflow
Tick Save Workflow before exporting and give it a name. The configuration — selected holes, fields, tables, columns, mode, file format — is saved and can be re-run later. See Export Workflows.
Common exports and how to set them up
”Send everything to the modeller”
- All drillholes
- All collar fields
- All tables, all columns
- Output mode: Merged
- File mode: Single File, XLSX
”Weekly assay update”
- All drillholes
- Just
name,easting,northing,elevation - Just the
Assaystable - Output mode: Standard
- Save as workflow named
Weekly Assays
”Hand off DDH-001 to a logger”
- Just
DDH-001 - All collar fields
- All tables
- Output mode: Standard
- Single File, XLSX
Tips
- Standard for archival, Merged for analysis. Standard preserves the relational structure; Merged is what most analysis tools want.
- CSV for tools that fight Excel. Some QGIS and Leapfrog importers prefer CSV. ZIP gives you all the CSVs in one download.
- Save the workflows that matter. If you’re sending this same data weekly, saving the workflow turns a 5-step wizard into a 1-click button.