How to convert txt to csv?

Question

big data

There is a txt file, in one line, through a dot with a coma, 5 blocks of information like this are written:
03/03/2015 09:38:43; 49.23497097; 28.41250193; 126;
you need to get a csv / xls file in which it will be in 5 columns.
How to achieve this? Thank you.

Answer 1

Rename file to csv.
I don't know about excel, but libreoffice will prompt you to choose the delimiter and file encoding when importing.

Answer 2

Out of the box, Excel cannot determine the format?

Answer 3

There, when you open it, you need to select the text format, then the separator will prompt you to select

Answer 4

into 4 columns is converted automatically if you just convert to excel