Which columns does the CSV use?
| Header | Required | Notes |
|---|---|---|
| type | Yes | stock or part |
| label | Yes | 1 to 120 characters |
| material | Yes | Stock and parts match by material and thickness |
| thickness, width, length | Yes | Or thickness_mm, width_mm, length_mm; not both |
| quantity | Yes | Whole number, 1 to 150 |
| grain | No | none, length or width |
| can_rotate | No | true or false, parts only |
| unit | No | mm or in; mm if missing |
| id | No | Must 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.