Recommendations for viewing CSV files

CSV files have been devised using the following numerical punctuation symbols:

  • decimal points: .
  • to separate thousands: none
  • to separate lists: ,

They may therefore be viewed correctly if this configuration is defined in the Windows control panel (regional configuration).

If the regional configuration is different (as is usually so, for example, in Spain, where the symbols , . ; are used in the three foregoing cases), the CSV files can be viewed correctly on an Excel spreadsheet. It may be necessary to use the Assistant for converting text in columns from the Data menu of Excel or some other procedure controlled by the user. Further, if the file contains data with decimal figures, it will have to be edited to change the field separator and the decimal point separator before opening it with Excel.