This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to separate data in excel (csv)

Former Member over 7 years ago

When i export my training data to a csv file i got the lines separated with "," and i am not able to separate the lines into cells in excel. How should it be done?

0 olni65 over 7 years ago

There's a function in Excel you need to use order to split the values into columns.
https://support.office.com/en-us/article/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7

0 WillNorthYork over 7 years ago

Another way to do this (without applying the method in #2 every time you open a CSV file in Excel) is to change your Windows regional settings:

- The list separator has to be changed to comma
- The decimal separator must not be a comma

In macOS, the decimal separator has to be a period.

https://superuser.com/a/606274