On my colleague's computer, one of her excel file (*.csv) contains multiple row and columns, like below picture shown.

But under her office 365 account, it shows only one column. That means even she changes computer but still uses her account, this will happen.

And the same excel file in others' computer (not her account) has no such issue.

Could anyone please help to advise?

CodePudding user response：

CSV (Comma Separated Value) files contain data delimited using Comma, Semicolon etc. Different settings are used for Excel in different regions. Like in Europe, semicolon is used as delimiter instead of comma. If regional settings in Operating system match with delimiter applied in CSV file, Excel read it correctly.

For Windows:

1. Go to Region Setting under Region & language Option
2. Click Additional settings
3. In 'List separator', type ","(without quotes)
4. Press 'OK' twice to save the changes

Source: https://harvestmedia.zendesk.com/hc/en-us/articles/360023978031-Opening-Excel-files-with-the-correct-CSV-list-separator