default setting to correctly open a csv file

Anonymous
2023-09-06T11:52:10+00:00

Hi there,

I'm trying to open a csv file in excel, but the columns are messed up, and I cannot fix it so there is a clear overview of data for every specific column.

I have tried to select a column (and not selecting at all); went to data and then text to with comma, but nothing changes.

This always happens, and i want to know if there is a default setting that i can change, so i can directly import the csv file and all columns are correct.

Thanks in advance!

Windows for home | Windows 10 | Settings

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 No comments
{count} votes

17 answers

Sort by: Most helpful
  1. Anonymous
    2023-09-07T12:23:24+00:00

    i did all this, but unfortunately still does not work. i have no idea why this is not working. i will try ask the people that i download the data from to see if i can fix it. thanks for all the help!

    0 comments No comments
  2. DaveM121 813.1K Reputation points Independent Advisor
    2023-09-07T12:27:43+00:00

    Glad to help!

    0 comments No comments