Microsoft Excel CSV Format on Load Fix
.CSV format on load not working?
This is something I find really annoying and finally worked out the reason that this happens. You open a .CSV in Microsoft Excel and it does not autodetect the columns and format the data. This is actually an easy fix and relates to the regional formatting settings for numbers (see image below). To get Microsoft Excel to automatically format .CSV data on import use these steps on Windows and hopefuly it should work. Note I run Windows 10 (not 11) so there may be some slight differences in the appearance however the fix should still work regardless of what version of Windows you are using.