Machine shop inventory

Turn messy CNC tool inventory spreadsheets into a cleaner tool crib list.

Join the waitlist for a spreadsheet cleanup tool for cutters, inserts, holders, locations, reorder points, and duplicate tool descriptions.

Join the waitlistSee example

Example

Clean CNC tool inventory spreadsheets.

See how messy tool crib rows could be normalized before building a bigger inventory system.

Example input

Uploaded file: cnc_tool_crib.xlsx

Tool ID,Description,Holder,Location,Qty,Min Qty,Vendor,Notes
T-1001,1/2 CARB EM 4FL,ER32,A1-03,3,2,North Tool,
T1001,0.500 carbide endmill 4 flute,ER-32,A1-3,1,2,North Tool,duplicate?
T-2040,CNMG 432 insert,,B2-10,18,20,InsertCo,low
T-3300,3/8 drill,HSS chuck,,6,4,DrillWorks,no bin
T-4400,Face mill 2.5in,CAT40,C4-01,,1,Mill Supply,qty missing
T-5000,ER32 collet 1/4,ER32,A1-07,2,2,,

Example output

Report summary

Tool crib spreadsheet normalized into locations, counts, and reorder flags.

medium

10

Tool rows checked

4

Low stock tools

2

Duplicate tool IDs

7

Locations normalized

Detected findings

Duplicate tool ID detected

high

EM-250-4F appears in two rows with different quantities and locations.

Location names normalized

low

Cab A, Cabinet A, and CAB-A were grouped under CAB-A.

Reorder threshold missing

medium

Three rows have on-hand quantity but no minimum stock value.

Holder and insert mixed in same column

medium

Some rows combine toolholder and insert details, making filtering difficult.

Cleaned inventory sample

Tool IDLocationOn handFlag
EM-250-4FCAB-A2Reorder
DR-125-CBDRAWER-039OK
INS-CNMG-432BIN-124Low stock
TH-CAT40-ER32RACK-021Review duplicate
Recommended next step: Merge duplicate tool IDs and fill missing reorder thresholds before using the sheet for purchasing.

Waitlist

Get notified when this tool opens

Leave your email and optionally describe the exact file or workflow you would want checked.

Optional, but useful for ranking which tool to build first.

FAQ

Questions before you join

Is this a tool crib system?

No. The waitlist is for a spreadsheet cleaner that normalizes tool rows, locations, holders, quantities, and reorder flags.

Who is this for?

Small CNC/job shops that already manage tools in Excel or shared spreadsheets and need a cleaner working list.

Would it recommend cutting tools?

No. It would clean and organize inventory data; it would not recommend machining parameters or tooling choices.

What should I describe when joining?

Mention whether your pain is duplicate tool names, messy holder numbers, locations, min/max levels, or reorder tracking.