info@lse.cc
DE EN
LEBERT Software Engineering
Industry solutions for EMS providers
GitHub
EFA CAMverse

Home › EFA CAMverse compact › From practice · episode 05

SeriesEFA CAMverse compact · episode 05 of 06 Feature in focus

With the CAM file
straight to the shopping list.

Quotation and purchasing need a bill of materials with all purchasing data. With EFA CAMverse it comes complete from the CAM data, as an Excel file or CSV, with no retyping.

How it works Download for free
1click on Bill Of Material
8formats with components
0lines retyped by hand

It is all in the data. Just not as a list ..

Every request needs a bill of materials with ordering data for costing and purchasing. The information is often already in the CAM data, as attributes on each component.

Needed for the requestBOM

Qty RefDes Maker MPN ? C1, C3 … ? ? ? R4, R5 … ? ? ? U3 ? ?

Purchasing and costing need the quantity, manufacturer and MPN for each line, ideally straight in Excel.

Already in the CAM dataper component

U3 ATTRIBUTES OF U3 ValueSAMD21G18PackageQFN-48MakerMicrochipMPNATSAMD21G18A-MU + more attributes

ODB++, IPC-2581 or KiCad bring the purchasing data as attributes, but per component and not as a list.

Many programs cannot export this purchasing data, for example from ODB++. That leaves only retyping.

One click on Bill Of Material ..

  1. Choose Bill Of MaterialOn the “Output” tab, click “Bill Of Material”. This works with ODB++, IPC-2581, KiCad, EAGLE, PADS, GenCAD, Gerber X3 and DXF.
  2. Set the groupingEFA CAMverse combines identical components automatically. Alternatively, you group by value and package or list every component on its own line.
  3. Save and openYou save as an Excel file or CSV. If you like, EFA CAMverse opens the file right away.
QTYREFDESVALUEMPN 12C1, C3, C7 …100nGRM155R71C104KA88D8R4, R5, R8 …10kRC0603FR-0710KL2D1, D2BAT54SBAT54S,2151U3SAMD21G18ATSAMD21G18A-MU + package, manufacturer, CPN, IPN, supplier and every other attribute

All purchasing data. No retyping ..

The customer’s CAM data becomes the basis for request and quotation, as an Excel file or CSV.

Content · ordering data and attributes

Every attribute in its own column.

Components with different properties get their own line with their own quantity.

R410k 06031 %R510k 06031 %R910k 06035 % QTYREFDESVALUETOL. 2R4, R510k1 %1R910k5 % Different tolerance, own line
  • The ordering data is included: quantity, references, value, package, manufacturer, MPN, CPN, IPN, supplier with order number, description and placement side.
  • Other attributes such as tolerance, voltage, RoHS status, datasheet or prices sit alongside in their own columns, named as in the source data.
  • Components marked as not fitted in EAGLE or KiCad are left out of the bill of materials.
  • References are sorted naturally, so R1, R2, R10. Empty columns are dropped.

Where many programs leave out the purchasing data, EFA CAMverse exports everything the source data contains.

More about BOM and quotation →
The result · your shopping list

Ready to use right away.

The bill of materials fits Excel, ERP and inventory systems directly.

BOM AND COORDINATESFrom the same CAM file
ExcelEvery value stays as it is. The header row is bold and frozen, and every column has a filter.
CSVThe file is UTF-8 encoded and uses the separators and decimal marks from your Windows settings.
CoordinatesA second click on “Coordinate data” gives reference, X, Y, rotation and side for each component.
PanelsFor panels from ODB++, IPC-2581 or GenCAD you choose a single circuit or the whole panel, for example with reference R12#3.
All features at a glance →

No more retyping by hand.

The Excel export deserves special mention: EFA CAMverse transfers every value unchanged from the CAM data. Package 0402 stays 0402, and an MPN never turns into a date. The quantity is a real number in the table, so you can calculate with it in Excel straight away.

Good to know ..

Which formats can EFA CAMverse create the BOM from?

From every format with components: ODB++, IPC-2581, KiCad, EAGLE, PADS Layout, GenCAD 1.4, Gerber X3 or Gerber with a coordinate file, and DXF. IPC-D-356 contains no components, so there is no BOM there.

What does the BOM contain?

The ordering data from quantity to placement side, and every other attribute of the source data in its own column, commercial and technical. How much of it appears depends on what the source data contains.

Why does the BOM fit Excel directly?

In the Excel file, EFA CAMverse transfers every value unchanged from the CAM data: package 0402 stays 0402, and the quantity is a real number in the table. The CSV file is UTF-8 encoded and takes the separators and decimal marks from the Windows region settings, the same ones your Excel uses.

And the placement positions?

A second click on “Coordinate data” creates the coordinate list from the same data: reference, X, Y, rotation, side, value and package for each component in millimetres, plus Z where component heights are available.

All about BOM and quotation →

Try it yourself? ..

EFA CAMverse is free to use as a viewer – unlock advanced features whenever you need them. Native on Windows, your data stays local.

More about EFA CAMverse
EFA CAMverse 2026 · free viewer · Windows 10/11 · 64-bit

Talk to us ..

Do you have any questions? We will be happy to advise you – by phone, online or in person.

Send an email Request a callback
LEBERT Software Engineering
Maybachstr. 15, 63456 Hanau, Germany
+49 6181 96942-0
info@lse.cc
Mon–Thu09:00–17:00 Fri08:00–16:00 Sat10:00–12:00

Newsletter

You will receive an email with a confirmation link and can unsubscribe at any time. Privacy policy