Is Orders Export formatting broken?

[dogogo]

I heavily use the 'export orders' functionality, always download it as "CSV for Excel...". But a few days ago, the downloads come up in a weird format that is unusable. Attaching screenshots of the exports from before and after.

Any idea what's wrong or how to fix this?

BEFORE

AFTER

[Jonathan-HA · Accepted solution]

Just did a test export on my end and the CSV file looks normal.

Maybe a setting in your spreadsheet software changed (such as the delimiter/separator option (make sure you're only using the comma delimiter and not multiple selected), encoding (you want to use UTF-8 encoding))?  Have you tried opening it with another spreadsheet software like Google Sheets?

[dogogo]

Hi, thanks a lot for this. I tried opening with Google Sheets and it worked. Very bizarre, never happened to me before. Will post again once I figure out how to fix it in Excel.

But you've saved me hours of time, thank you, truly appreciate it!

[dogogo]

FYI, the issue here was that I've changed "Region" settings in Excel, and that messed with the formatting. It worked fine after that.