CSV excel sheets do not open in columns

Hi,

I'm Sneha and I'd be happy to help you out with your question. Sorry for the inconvenience caused.

To ensure that your CSV files open correctly by default, you can follow these steps:

• Open Excel and go to the "Data" tab.
• Look for the "Get & Transform Data" section and click on "From Text/CSV".
• In the "Import Data" dialog box, navigate to the location of your CSV file and select it.
• In the "Text Import Wizard" dialog box, select "Delimited" and click "Next".
• Choose the delimiter that your CSV file uses (usually a comma or semicolon) and click "Next".
• Make sure that all the columns in your CSV file are highlighted in the preview section and click "Next".
• Choose the appropriate data format for each column (General, Text, Date, etc.) and click "Finish".

After following these steps, Excel should now open your CSV files correctly by default. However, if you still encounter issues with certain CSV files, you may need to check that the delimiter is consistent throughout the file, that the file does not contain any hidden characters or leading/trailing spaces, and that the encoding is set correctly.

For more Information, please refer to following resource :-

I want Excel to be the default App to open CSV files - https://answers.microsoft.com/thread/7390de35-c424-4870-bc8f-8a239d9f5edd

If you have any other questions or need assistance with anything, please don't hesitate to let me know. It will be my pleasure to Assist you.

Best Regards, Sneha

Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

Follow the steps this articles:

System settings - How to import a CSV file that does not match your - Microsoft Community
Power Query - How to import a CSV file that does not match your locale - Microsoft Community

Andreas.

how csv works?

Good day,

I need my Excel CSV files to open correctly. I know how to change it correctly when it is open but when i do that the files does not always work correctly. I have gone through the region settings and all. Can you help me maybe to do a default setting so that my CSV files open correctly from the start?

I know it's painstaking when you work with .csv often. Every time you must use Import Wizard if you want to edit it, and 'save as' once you are done.

There's an easy option, I tested it on office version 16.78 on Mac OS.

Simply go to Excel > Preferences > Edit

Under the "Edit Options" Section, disable the "Use system separators' and then set Decimal separator to period (.) and Thousands separator to comma (,). If you see these already exists, just swap them.

You are done! Now your .csv file open normally just like an xlsx file.

Alert: Be sure to switch back to the original settings when you are done working with .csv files. Otherwise, your formulas in other files may not work properly, and the numbers, currencies etc may confuse you.

Thank you!
Prashanth

This Does not work with windows 11