Import manual

Introduction

FeneCAM provides powerful data import/export features. Data can be loaded into the application using plain text CSV (.csv) files or from Microsoft Excel? sheet files (.xls, .xlsx). Usually, similar applications have to load stocks data and parts from two different files which is uncomfortable. FeneCAM uses more sophisticated data import process and can load all data (not only stocks or parts) from a single file.

Tip: The simplest way to prepare data file for import is to export configuration from an existing cutting plan and then edit it in Microsoft Excel?.

Key column

One of the most important part of our CSV and Microsoft Excel? file format is the first column, called Key column. Value in this column identifies, what type of data are stored in corresponding row and its cells.

Key column is marked red in the following examples. As you can see, data file looks very similar as our input forms for linear cutting plans.

Data files description

Linear data file format

CSV format MS Excel? format

Key	Description	Parameters (columns after key)
`N`	Cutting plan name	Name text
`M`	Material description	Material name/description
`K`	Kerf (blade thickness)	Width in mm
`LT`	Left trim cut	Length in mm
`RT`	Right trim cut	Length in mm
`O`	Optimization algorithm	`c` = cost minimization
`MR`	Minimal remnant length	Length in mm
`S`	Stock material definition	Length, Quantity, Group, Price, Priority
`P`	Part to cut	Length, Quantity, Label, Group
`@`	Comment (row ignored)	Any text

Example data format

N,My Cutting Plan
M,Aluminum Profile 6060
K,3
LT,5
RT,5
MR,100
S,6000,10,Main Stock,15.50,1
S,4000,5,Offcut,10.00,2
P,500,20,Part A,Group1
P,750,15,Part B,Group1
P,1200,8,Part C,Group2
@,This is a comment line

Useful tips

None of mentioned keys/rows is mandatory. You can create your own CSV or Microsoft Excel? file which contains (for example) data for stocks and/or parts only.
Import file may contain multiple rows for Stocks or Parts - similarly as in our cutting plan input forms.
Same data structure is valid for CSV and Microsoft Excel? files. Cells in CSV file must be separated by comma.
All numeric values should be plain numbers without units or formatting.
Rows starting with @ are treated as comments and will be ignored during import.
The Group parameter allows you to organize stocks and parts into logical groups for easier management.

Last update: January 5, 2026