How can I create the equivalent of an explode() USING set data in each different column using WPS office or any others

Question

I have the following default data set:

I convert from .TXT to .CSV format but I get one row of all data. how can divide into a different row?

I have 200 000 data.

My default CSV data :

A

ath;006400005;1

I want to CSV data :

A       B           C

ath     006400005   1

Answer 1

Separate it by comma, not semicolon.

From your .txt file, find and replace ";" to "," then convert it to .csv