Hello and thanks.
I would like to work with Excel so that I can sort by date or time.
I can open it with Excel without any problems.
In German-speaking countries, however, Excel saves with “;”
It should be possible to choose the CSV separator while importing files into Excel (or any other similar software). I’ve found this article on the Microsoft Support page. I believe it’s helpful.
Hello Svetlana.
Importing is not the problem. this works out.
However, the edited file can be exported again with the separator “,” that just doesn’t work.
Excel automatically renders “;” in European countries
Sounds like an issue with Excel. If you cannot find a way to configure Excel to export the way you would like, you could try another spreadsheet app, or as suggested, just open the file in a code/text editor and "find “;” and replace with “,” . It takes literally 15 seconds after you have done it once.
We to have to reformat the file every time we use it but mostly for column order and field mapping so we share our files to an email address, modify it however we need it and store that in the project folder. It literally takes about 10-15 seconds to replace all the symbols.