All Collections
Buying Diamonds on RapNet
Tips and Advice
Diamond Export to CSV does not format properly
Diamond Export to CSV does not format properly

How to fix when your CSV diamond file is badly formatted

Philippa Corrick avatar
Written by Philippa Corrick
Updated over a week ago

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?