Which columns does the CSV use?

Headers the importer recognises
HeaderRequiredNotes
typeYesstock or part
labelYes1 to 120 characters
materialYesStock and parts match by material and thickness
thickness, width, lengthYesOr thickness_mm, width_mm, length_mm; not both
quantityYesWhole number, 1 to 150
grainNonone, length or width
can_rotateNotrue or false, parts only
unitNomm or in; mm if missing
idNoMust be unique among stock or parts

What does an example look like?

type,label,material,thickness,width,length,quantity,grain,can_rotate,unit
stock,Plywood sheet,Plywood,18,1220,2440,1,length,,mm
part,Side,Plywood,18,300,1800,2,length,false,mm
part,Shelf,Plywood,18,280,564,3,none,true,mm

What happens when a row is wrong?

The app shows a preview with errors by row number before it replaces anything. Typical errors are a missing required header, a quantity that is not a whole number, a duplicate id or a unit other than mm or in. Commas, semicolons and tabs are detected as separators.

Are there limits?

Up to 20 columns, 200,000 bytes per file and 150 pieces in total. The app also exports a CSV cut list and a JSON backup. The JSON file is the lossless format.

Frequently asked questions

Can I import in the web planner? No, CSV import is in the Android app. The website planners take typed rows.

Do fractions work? In inches, decimals and mixed fractions such as 15 1/4 are read. See fractions and units.

Related: Make a cut list · Kerflio FAQ

How this page was made: written by Certloom Learning from the Kerflio planning engine and the arithmetic shown. Not reviewed by a tradesperson. Check your own material and equipment.