HOMER uses the period "." mark as the decimal marker. The number "one thousand, two hundred, thirty four point five" would be written as "1,234.5". In some locations, on the other hand, the convention is to write this number as "1.234,5". If we mix these two conventions, numbers may be multiplied or divided by many factors of ten. If you are in a country where the comma "," is the decimal marker, your csv export may have this problem.

Microsoft Excel offers options to let you import CSV data that uses the period "." as the decimal marker. Below are steps to do this for some versions of Excel. Newer or older versions might require different steps.

1. In the Data menu, choose "Get External Data From Text". Excel gives a window where you can select the CSV file.



2. Choose "Delimited" and click "Next".



3. Choose "Comma" and then choose quote (") as the "Text qualifier" and click next.



4. Click "Advanced" and change the Decimal separator to the period "." and the Thousands separator to the comma ",".



5. Then click OK and Finish.