Gems List to Excel by Selection

These two commands export the gem list of a selection to a spreadsheet file instead of drawing it in the viewport. They live in the submenu of the Gems List to Excel button.

Gems List to Excel by Selection

Run the command and Rhino asks you to select the gemstones to export. Objects that are not diamonds or gemstones are ignored; if the selection contains none, the command reports that no gemstones were found and stops.

A Save as dialog then appears, pre-filled with the name of your Rhino file followed by Gems Info. The file type list offers two options:

• CSV files — numbers are written using the decimal separator of your Windows regional settings.
• CSV files Force Point as Decimal — numbers always use a point as decimal separator, which is what most non-local spreadsheets and production systems expect.

The exported file is a semicolon-separated CSV with one header row and one row per gem size:

Shape;Size X;Size Y;Carats;Quantity;Total Carats

As in the viewport list, identical gems are merged into one row: same shape, same material and same X and Y sizes within 0.005 mm. Round diamonds are weighed with the commercial round-brilliant chart, so the carat totals match the ones shown by the Gems List table.

Gems List to Excel by Selection Groups

Same selection and same save dialog, but the CSV is split by Rhino group.

Each Rhino group that contains selected gems produces its own section: a line with the group name, then the Shape;Size X;Size Y;Carats;Quantity;Total Carats header, then the rows of that group, then a blank line. Selected gems that belong to no group are written in a last section headed Ungrouped Gems.

A gem that belongs to more than one Rhino group appears in each of those sections, so read the sections as groups, not as a single running total.