CSV Format specifications

Shape or "Shp"

Round = RB, RN, BR, RBC
Princess = PRN, PR
Cushion = CU, CS, CUS, C
Pear = P, PE, PS
Emerald = EM, E, EC
Radiant = RAD, RA
Oval = OV, O
Marquise = MQ, M
Heart = HS, HT, HE, H
Asscher = AC, AS
Trilliant = T, TR
European Cut = EC, EU
Trapezoid = TP
Old Miner = "Sq. Emerald", SQEM, SQE
Square Emerald = Faint
Cushion Modified Brilliant = Cushion Modified, CMB, CM, CB
Baguette = BAG, BG
Kite = K
Half Moon = HM
Bullets = BU
Shield = SH
Triangular = TRIANGLE, TRI
Octagonal = OC
Square
Rectangular
Other = X

Weight or "Size", "Carats", "Carat"

Numeric field with two decimals, e.g. "1.19".

Color or "Col", "Colour"

D
E
F
G
H
I
J
K
L
M
N
OP = O-P
QR = Q-R
ST = S-T
UV = U-V
WX = W-X
YZ = Y-Z

Color Distribution

"even", "uneven"

Fancy Color #1, Fancy Color #2 or "FancyColor", "Fancy Color" for field with one or two values

Yellow
Brown
Pink
Blue
Green
Black
Orange
Gray
Purple
Champagne
Red
White
Violet
Chameleon
Cognac
Other

Fancy Intensity or "FancyColorIntensity"

FNT = Faint
VLT = Very Light
LGT = Light
FCL = Fancy Light
FCY = Fancy
FDK = Fancy Dark
FCI = Fancy Intense
FCV = Fancy Vivid
FDP = Fancy Deep

Color Overtone #1, Color Overtone #2 You can combine the two into one field called Overtone.

Brownish
Greenish
Yellowish
Pinkish
Purplish
Grayish
Orangey
Orangy
Reddish
Bluish
None

Clarity

FL
IF
VVS1
VVS2
VS1
VS2
SI1
SI2
SI3
I1
I2
I3

Cut or "CutGrade", "Cut Grade"

Ideal = ID, I
Excellent = EX, X
Very Good = VG
Good = GD, G
Fair = FR, F
Poor = PR, P
N

Lab

GIA
IGI
AGS
HRD
PGS
DCLA
EGL USA
CGL

Polish or "Pol"

Ideal = ID, I
Excellent = EX, X, E
Very Good-Excellent = VG-EX
Very Good = VG, V
Good-Very Good = G-VG
Good = GD, G
Fair-Good = F-G
Fair = FR, F
Poor = PR, P

Symmetry

Ideal = ID, I
Excellent = EX, X, E
Very Good-Excellent = VG-EX
Very Good = VG, V
Good-Very Good = G-VG
Good = GD, G
Fair-Good = F-G
Fair = FR, F
Poor = PR, P

MeasLength or "MeasLength", "Length"

Measurement in mm. with two decimals, e.g. 6.32

MeasWidth or "MeasWidth", "Width"

Measurement in mm. with two decimals, e.g. 6.32

MeasDepth or "MeasDepth"

Measurement in mm. with two decimals, e.g. 6.32

Measurements (combo field)

Measurements in mm. with two decimals, e.g. 6.32x6.28x3.54

DepthPercent or "DepthPCT", "Depth %", "Depth"

Depth with one decimal, e.g. 64.5

TablePercent or "TablePCT", "Table %", "Table"

Table with two digits only, e.g. 61

GirdleMin or "Girdle Thin", "GirdleThin"

XTN = Extremely Thin, Extr. Thin, Ex. Thin, Ext. Tn
VTN = Very Thin, I
TN = Thin
STN = Slightly Thin
MED = Medium, M
STK = Slightly Thick, Sl. Thick
THK = Thick, TK
VTK = Very Thick, I
ETK = Extremely Thick, XTK, Ex. Thick, Extr. Thick

GirdleMax or "Girdle Thick", "GirdleThick"

GirdleStyle or "Girdle Style", "GirdleCondition", "Girdle Condition"

Polished = "Pol."
Faceted = "fac".
Bruted
Partially Polished = "part. pol", "par. pol"
Partially Faceted = "part fac.", "par fac.""
Par.Pol./Par.Fac. = "pol/fac"

GirdlePercent or "Girdle %", "GirdlePct"

Numeric value, e.g. 2.10

Stock# or "VendorStockNumber", "Stock #", "StockNum", "StockNumber", "Packet No"

String up to 20 characters, e.g. ABC-12345

Report Number or "CertificateNum", "CertificateID", "CertNumber", "Cert Number", "Certificate Number", "Certificate #", "Report No"

String up to 20 characters, e.g. 3205693254

Report Comment or "cert comments", "Cert Comment", "CertComment", "Report Comments"

String up to 250 characters

Report Type

String, e.g. "Diamond Dossier"

Report Issue Date

String, e.g. Jan 2016

PricePerCarat or "Price", "Price/ct"

Numeric, e.g. 4500
*Price per carat takes precedence of total price.

PriceTotal or "Total Price"

Numeric, e.g. 5200
*Price per carat takes precedence of total price.

PriceListPercent or "RapnetDiscountPct", "% Discount"

Numeric, e.g. -30.5
* This will be shown as provided.

CuletSize or "Culet Size"

None = N
Large = L
Medium = M
Small = S
Very Small = VS

CuletCondition or " Culet Condition"

Pointed
Chipped

Culet (combo field)

You can combine fields from CuletSize and CuletCondition into this field. E.g Large Pointed

Treatments or "Treatment", "Enhancements"

Color Enhanced = High Pressure High Temperature, HPHT, Coating, Color Enhanced, Irradiation, Irradiated, Color Enhancement
Clarity Enhanced = Clarity Enhanced, Clarity Enhancement, Laser Drilled, Fracture Filled
Other = Anything else

Fluorescence Intensity or "Fluor. Intensity", "FluorescenceIntensity", "Fluor# Intensity"

None = N, NON
Very Slight = VSL, V.Slight
Faint = FNT, F
Slight = SL
Medium = MED, M
Strong = STG, ST
Very Strong = VST, V.Strong

Fluorescence Color or "Fluor. Color", "FluorescenceColor"

Blue = B
Yellow = Y
Green = G, F
Red = R
Orange = O
White = W

Fluorescence (combo field)

Use this field to combine Fluorescence Intensity and Fluorescence Color, e.g. Medium Blue

Crown Height or "CrownHeight"

Decimal value

Crown Angle or "CrownAngle"

Decimal value

Crown (combo field)

You can combine fields from Crown Height and Crown Angle into this field.

Pavillion Depth or "PavilionDepth", "Pavilion Depth"

Decimal value

Pavillion Angle or "PavilionAngle", "Pavilion Angle"

Decimal value

Pavillion (combo field)

You can combine fields from Pavillion Depth and Pavillion Angle into this field.

Inscription or "LaserInscription"

String up to 50 characters.

Ref Number

String up to 20 characters

Seller Comments or "Comment"

String up to 250 characters

Bundle Code

String up to 20 characters

Bundle Separable

Boolean:
True = true, 1, yes
False = false, 0, no, -1

Bundle Type

Matched Pair
Pair
Set
Bundled

Availability

In Stock = IS, A, Available, Guaranteed Available
Hold = H, on hold
Memo = M, out on memo
Private = P, Not available, NA

AllowResale

Boolean:
True = true, 1, yes
False = false, 0, no, -1

Formation Type

Natural = NAT
Synthetic = SYN, CVD, HPHT

AllowMarketPlace

Boolean:
True = true, 1, yes
False = false, 0, no, -1

Brand

Canada Mark
Canadian Origin

Location

Israel
USA
India
Belgium
Hong Kong
U.A.E.
Ramat Gan
New York
Mumbai
Antwerp
Hong Kong
Surat
Dubai

HeartsAndArrows

H&A 100%
H&A 90%
H&A 80%
H&A 70%
H&A 60%
H&A 50%
H&A = EX, VG, GD, Hearts&Arrows

Shade

White
Yellow
Brown
Green
Grey
Black
Pink
Blue
Other
None

StarLength

Decimal value

Key to Symbols

Free text, up to 200 characters.
* Must be exactly as it appears on the grading report

ReportUrl