Share via

Multiple columns of excel only shown as 1 column

Anonymous
2023-01-28T11:07:40+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points
    2023-01-28T11:30:03+00:00

    The user who sees the "wrong one" probably uses comma as decimal separator and semicolon as list separator.

    Therefore the commas in the CSV files are not interpreted as delimiters.

    She could open the file as a text file (press Ctrl+O, select Text Files as file type). She should then be able to specify comma as delimiter.

    Or change the system separators.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest