question

NaughtySusan-7020 avatar image
0 Votes"
NaughtySusan-7020 asked NaughtySusan-7020 edited

Data writing to the .csv file

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


office-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@NaughtySusan-7020 I've added [office-excel-itpro] to the tags and removed [openspecs-office-fileformats]. The Open Specifications don't cover .csv format so you'll get better support from the Excel IT Pro folks.

Best regards,
Tom Jebo
Sr Escalation Engineer
Microsoft Open Specifications Support

0 Votes 0 ·
SandervandeVelde42 avatar image
2 Votes"
SandervandeVelde42 answered emilyhua-msft commented

Hello @NaughtySusan-7020 ,

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.



image.png (54.7 KiB)
image.png (76.6 KiB)
image.png (86.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NaughtySusan-7020

Please refer to SandervandeVelde42's suggestion to check the "list separator" of Windows system.

0 Votes 0 ·
NaughtySusan-7020 avatar image
0 Votes"
NaughtySusan-7020 answered NaughtySusan-7020 edited

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.