Drill Hole CSV Cleaner
Inspect drillhole CSVs in the browser before they leave the workstation.
Load collar, survey, assay, and lithology tables together, review mismatches, and export clean CSVs without sending the data to a server.
Inspect drillhole CSVs in the browser before they leave the workstation.
Load collar, survey, assay, and lithology tables together, review mismatches, and export clean CSVs without sending the data to a server.
The sample includes a depth reversal, an overlap, and a missing collar depth.
# collar.csv hole_id,x,y,z,total_depth,project DH-001,500000,6200000,1250,305,North Ridge DH-002,500120,6200120,1242,,South Ridge DH-003,500240,6200250,1238,180,South Ridge # survey.csv hole_id,depth,azimuth,dip DH-001,0,90,-60 DH-001,50,92,-58 DH-001,45,94,-57 DH-002,0,110,-65 DH-003,0,180,-70 DH-003,30,181,-69 # assay.csv hole_id,from,to,au_gpt,cu_pct DH-001,0,10,0.12,0.18 DH-001,10,20,0.19,0.22 DH-001,18,30,0.21,0.25 DH-002,0,15,0.05,0.09 DH-003,40,30,0.08,0.11 # lithology.csv hole_id,from,to,lithology,code DH-001,0,25,Oxidized,OX DH-001,25,55,Fresh,FR DH-002,10,40,Andesite,AN DH-003,0,20,Basalt,BA
The sample includes a depth reversal, an overlap, and a missing collar depth.
Errors: 4 Warnings: 2 Fixable: 3 - DH-001 survey depth reversal at 45 m - DH-001 assay overlap at 18-20 m - DH-002 collar is missing total depth - DH-003 lithology extends past collar depth
Yes. Processing stays in your browser and the CSV content is not uploaded to a server.
No, but the cross-table checks are strongest when collar, survey, assay, and lithology are all loaded together.
No. The source text stays as-is until you export a cleaned CSV after choosing fixes.
It flags suspicious ratios, but the unit assumption is still yours to confirm before release.
Use the field mapping controls. The tool also tries common aliases such as hole_id, BHID, from_m, and to_m.
The hole start point and collar location, usually with coordinates and total depth.
A downhole station table with depth, azimuth, and dip values.
A sample interval table with grade or chemistry results.
A logged geology interval table describing rock types or codes.
Two intervals that claim the same depth range.
A missing depth range between two adjacent intervals.
A sharp change in drillhole direction between survey stations.
When a later row has a smaller depth than the previous row.