Configuring your computer to read CSV files

CSV files are basic text files where commas separate values and periods are decimal points. The first line contains the column names, also separated by commas. For example:


The bad news is that some computers expect semicommas to separate values with commas as decimal marks.


In Windows, the following system settings will make it easier to import CSV files into Excel:

Settings - Time & Language - Additional settings - Change number format
Decimal symbol = .
Digit grouping symbol = ,
List separator = ,


As for Excel, it's best to let the above system settings apply. This is the default option in Excel:

File - Options - Advanced - Use system separators = Yes

Other software

Most other software, such as R and LibreOffice, can import CSV files without changing the system settings.