How to fix CSV File open not properly on Microsoft excel?

When opening standard CSV (Comma Separated Values) files in Excel you may find that Excel did not recognize the fields and simply displays all data in the first column.

How to fix CSV File open not properly on Microsoft excel?

1. Change Region settings

- Click Start Button and Search => Region

- Click Additional Settings...

- On column List separator change to Comma "," and Apply.

- After apply this setting. Now you can open a CSV file in Excel it will automatically find the data fields and open it appropriately.

Conclusion

In this post, we have made a step-by-step tutorial on How to fix CSV File open not properly on Microsoft excel?.I hope you liked it and please do share it with your friends and follow our social media for more.

If you face any problems with the code or have any questions, please feel free to ask in the comments section or contact us.