Multiple columns of excel only shown as 1 column

Question

One of my coworker's excel files (*.csv) contains several rows and columns, as can be seen in the image below.

However, there is only one column under her Office 365 account. This implies that even if she switches computers while using the same account, this will still occur.

And the identical Excel file on other computers (not hers) does not have this problem.

Could someone kindly offer advice?

Answer 1

Data is separated into CSV (Comma Separated Value) files by Comma, Semicolon, etc. In some regions, Excel is configured differently. Semicolons are used as delimiters in place of commas, the same as in Europe. Excel will read a CSV file correctly if the operating system's regional settings match the delimiter used in the file.