Import Parts List from Excel into iFurn.pro - XLSX Template Workflow

#150

Import from Excel into iFurn.pro is the simplest and most universal way to load a parts list when the original CAD program is not supported directly. You use a ready-made XLSX template, populate it with parts, dimensions, material and edge banding. Useful for manual cut lists, supplier specifications, or transferring data from unsupported programs via copy-paste.

One caveat: this import supports one edge band per part side. Drillings and routing are not added through this path - for those, use a CAD import (TopSolid, Bazis, 3D-Constructor).

When to use Excel import

  • The parts list is already a table (a PDF from the client, an ERP report, a manual calculation)
  • The originating program is not on the supported list (Cabinet Vision, K3, IFC, etc.)
  • You need to load simple parts without complex operations quickly
  • An order from a subcontractor who sent only a specification

Step-by-step instructions

Step 1. Download the template

  1. On the main order page in iFurn.pro open "Add" -> "Project import".
  2. Download the parts list table template (XLSX file).

Step 2. Fill in the template

The template has the following columns (rough layout; the exact headers are in the downloaded file):

  • A. Part code - internal number or SKU
  • B. Material code - SKU from your database or a new name
  • C. Part name - e.g. "Left side", "Shelf"
  • D. Dimension X (length) in mm
  • E. Edge band T (top)
  • F. Edge band B (bottom)
  • G. Dimension Y (width) in mm
  • H. Edge band L (left)
  • I. Edge band R (right)
  • J. Quantity
  • L. Rotate (grain) - "yes" / "no" for parts with directional grain

The template supports up to 500 rows of parts. Fill in following the example and do not leave empty rows in the middle.

Step 3. Save the file

  1. Save the file in .xlsx format (not the old .xls).
  2. Do not change the column structure - the order and headers must stay as in the template.

Step 4. Upload into iFurn.pro

  1. Open "Add" -> "Project import" again.
  2. Pick the filled XLSX file and upload.
  3. The import dialog shows the parts list with recognized materials and edge bands.
  4. For each material from the import you can pick a replacement from your company database, or keep the one in the file (the material will be created automatically).
  5. Confirm the import - the parts list with the specified edge banding appears in the order.

CSV support

Beyond XLSX the importer also accepts CSV (separator - semicolon, encoding UTF-8 or Windows-1251). CSV is handy when your ERP exports plain text.

The CSV structure matches the XLSX template: 18 columns (A-R) in the same order. The encoding is detected automatically.

What is NOT supported via Excel import

  • Drillings - these need a CAD import (Bazis, TopSolid, 3D-Constructor)
  • Routing and grooves - same
  • Complex hardware tied to the carcass - Blum Configurator
  • 3D model - Excel is a flat spec, with no 3D

Common issues

"File will not upload"
Check the format - must be .xlsx (Excel 2007+), not the old .xls. Size up to 10 MB.
"CSV encoding was not detected"
If non-Latin text shows up as "????" - re-save the file as UTF-8 (in Excel: "Save As -> CSV UTF-8").
"Materials are not recognized"
The template has a column for the material. If it is empty or contains unknown values, every part lands on a single material called "default". Fill the column with SKUs from your database.
"Part thickness is wrong"
Thickness is taken from the material-thickness column (if present) or from the linked database material. Verify that the material has the correct thickness.
"Edge bands end up on the wrong side"
Check the T/B/L/R column order - top/bottom/left/right. Do not swap them.

See also