Data writing to the .csv file

NaughtySusan 21 Reputation points
2021-10-31T09:35:47.297+00:00

I am interested in what is the correct data writing to the .csv file? In older versions of Excel, columns were separated by commas in newer semicolons and now when I double-click on a .csv file, it does not read it correctly.

Thanks

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,638 questions
Accepted answer
  1. Sander van de Velde 28,236 Reputation points MVP
    2021-10-31T10:55:49.833+00:00

    Hello @NaughtySusan ,

    Excel uses a regional setting from the OS to separate values in a CSV file.

    Do you use Windows? Go to the start menu and open 'Control panel'.

    Here, use the search bar and search for 'region':

    145228-image.png

    Open the dialog and click 'Additional settings':

    145156-image.png

    The 'List separator' is the value used by Excel:

    145233-image.png

    Compare this with your CSV file. Remember not to 'reuse' the same character as the decimal symbol or the digit grouping symbol.

    If this is still not satisfying, check out the text file import wizard.

    2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. NaughtySusan 21 Reputation points
    2021-11-04T12:11:32.98+00:00

    I did not expect that the Windows configuration has an impact on the operation of external programs, including Excel, and that an ordinary user can modify such important data.

    Thank you for your help

    0 comments