M
M
Meri19952020-11-02 13:52:35
excel
Meri1995, 2020-11-02 13:52:35

Why doesn't Excel save csv with a comma?

The problem is, I need to save csv with comma delimiters, but when I select "csv (comma delimiter)" through "export" Excel saves with semicolon delimiters ... I changed the delimiter to comma and in the regional settings of Windows and in the Excel options "advanced" "editing options"... nothing helps, it still saves with a dot and a comma. Please tell me how to fix this?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Ivan, 2020-11-02
@Iv_and_S

use OpenOffice and/or LibreOffice.
where the delimiters are set explicitly.
though there are some restrictions on the number of lines (I don’t remember the exact number)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question