If your export file looks something like this, continue reading to learn how to fix!

This is because the diamond export file downloads in CSV format where the decimal separator should be a . (period/full stop) instead of a , (comma)

If your decimal separator is comma instead of period/full stop, here's how to update it

  1. Open an blank Excel sheet

  2. Go to File > Options > Advanced > Editing Options >

  3. Check the box: Use System Separators
    Decimal separator is .
    Thousands separator is ,

  4. Click OK

Now go to your computer's Control Panel

  1. Control Panel

  2. Region

  3. Formats > Click Additional settings

  4. Set List Separator is set to , (comma) > OK

Did this answer your question?