Drill Hole CSV Cleaner

Inspect drillhole CSVs in the browser before they leave the workstation.

Load collar, survey, assay, and lithoskráy taflas together, yfirferð mismatches, and export clean CSVs without sending the data to a server.

No signup / Free Browser-only processing Checks four taflas together

How to use

  1. Load or paste the collar, survey, assay, and lithoskráy CSVs.
  2. Confirm the detected headers and adjust the kortlagning sviða if needed.
  3. Choose the units and cleanup settings that match the source files.
  4. Run validation, then yfirferð the issue list and suggestions.
  5. Apply safe fixes and download the clean CSVs plus the issue skýrsla.

Sample

Mixed drillhole QA sample

The sample includes a depth reversal, an overlap, and a missing collar depth.

Inntak
# collar.csv
hole_id,x,y,z,total_depth,verkefni
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

# lithoskráy.csv
hole_id,from,to,lithoskráy,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

Expected úttak

The sample includes a depth reversal, an overlap, and a missing collar depth.

Expected úttak
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 lithoskráy extends past collar depth

Algengar spurningar

Can I use it offline?

Yes. Processing stays in your browser and the CSV content is not uploaded to a server.

Do I need all four taflas?

No, but the cross-tafla checks are strongest when collar, survey, assay, and lithoskráy are all loaded together.

Will it change my original file?

No. The source text stays as-is until you export a cleaned CSV after choosing fixes.

Can it detect feet-versus-meters mistakes?

It flags suspicious ratios, but the unit assumption is still yours to confirm before release.

What if my header names are different?

Use the kortlagning sviða controls. The verkfæri also tries common aliases such as hole_id, BHID, from_m, and to_m.

Glossary

Collar

The hole start point and collar location, usually with coordinates and total depth.

Survey

A downhole station tafla with depth, azimuth, and dip values.

Assay

A sample interval tafla with grade or chemistry niðurstaðas.

Lithoskráy

A skráged geoskráy interval tafla describing rock types or codes.

Overlap

Two intervals that claim the same depth range.

Gap

A missing depth range between two adjacent intervals.

Dogleg

A sharp change in drillhole direction between survey stations.

Depth reversal

When a later row has a smaller depth than the previous row.