Share via

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

17 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-07T07:39:11+00:00

    Hi hi,

    i could not find how to open the old control panel and the region applet. Could you make a screenshot?

    0 comments
  2. Anonymous
    2023-09-07T08:25:57+00:00

    Hi Dave,

    I found it, took me a while because everything is in Dutch. the decimal should be comma i assume?

    1 person found this answer helpful.
    0 comments
  3. DaveM121 813.1K Reputation points Independent Advisor
    2023-09-07T08:29:40+00:00

    All settings n there look to be correct, the List Separator is set to a comma and so CSV files should generate correctly, there is no wrong settings on your PC.

    0 comments
  4. Anonymous
    2023-09-07T08:48:15+00:00

    allright, then I have no idea what is wrong haha. but thanks a lot for your fast and detailed help!

    0 comments
  5. DaveM121 813.1K Reputation points Independent Advisor
    2023-09-07T08:50:28+00:00

    Try this option to repair your Office installation, if there is any problem with Excel, this will fix it.

    Open the Settings App (gear icon on your Start Menu)

    Go to Apps and Features, then scroll down to find Microsoft Office

    Select that and choose Modify - Online Repair

    That is a comprehensive fix

    That should fix any issues with your Office Installation.

    0 comments