Drill chart generator
Drop the Excellon drill files from your CAD export and get a drill chart: every tool with its diameter in mm and mil, hit count, plating, slots and aspect ratio, plus flags for holes your fab may not drill.
Files are read in your browser: your drill data never leaves your machine and nothing is uploaded.
Drill files
Excellon / NC drillDrill chart
| Tool | Ø mm | Ø mil | Plating | Hits | Slots | Aspect ratio | File |
|---|
How it works and assumptions
- Format. The header’s
METRICorINCH,LZ/TZzero suppression, digit format (for example000.000),M71/M72,FMAT, absolute and incremental modes are read. Without a declaration the Excellon defaults (inches, 2.4 digits) are assumed and you are told so. - Tools and hits. Each
Tdefinition gives a diameter, converted to millimetres and mils. Every coordinate drilled with a tool counts as one hit. - Slots.
G85drilled slots and routed slots (G00…M15…G01…M16) are counted separately from hits; the slot length includes the tool diameter. - Plating. Read from KiCad and X2 attributes (
TF.FileFunction,TA.AperFunction,;TYPE=PLATED/NON_PLATED), Altium’s hole-size comments, or a PTH/NPTH file name. - Limits. Holes under the minimum mechanical drill you set (0.2 mm by default) are flagged, and plated holes with an aspect ratio (board thickness ÷ hole diameter) above 8:1 or 10:1. These are common fab limits rather than universal ones: check your fab’s capabilities.
Repeat codes (R) and canned patterns are not expanded; they are rare in CAD output and are reported if found.
FAQ
Are my drill files uploaded?
No. Files are read with your browser’s File API and parsed on this page. Nothing is sent to our servers, and the CSV is generated locally.
Why does aspect ratio matter?
Plating has to reach the middle of the hole. The deeper and narrower the hole, the harder that is, so fabs limit the ratio of board thickness to drill diameter for plated holes. Thinner boards or larger vias bring the ratio down.
Are these finished or drill sizes?
CAD tools usually write the finished hole size. Fabs drill plated holes slightly larger to allow for plating, so the bit they use is typically 0.05–0.1 mm bigger than the number in the file.
My hit counts look wrong. Why?
Check the units and zero format in the summary. A file with no LZ/TZ declaration and no decimal points is ambiguous for positions, but hit counts do not depend on it. Repeat codes are not expanded and are reported as a warning.